BrainPatchworkDX.com

I spent sometime looking for the explanation to the subject. When to use TDataSource instead of TDataSet?

The reason is, your component becomes dependent upon DB, not Your*Dataset unit. Thus allowing for releasing without having to give out your component suite, plus your Dataset suite. (Keeping ...

-- 06_create_tables_basic.sql
-- Lesson 6: Create tables, and the basic column types and constraints.
--
-- Requires: Database = training.shop (lesson 5).
--
-- A table has a name and a list of columns. Each column has a name, a type
-- and optional rules (constraints).
--
-- SQLite column types ...

-- 05_select_database.sql
-- Lesson 5: Select a database.
--
-- IMPORTANT: on this server, you do not select a database with SQL.
-- The connection chooses it. There is no "USE database" statement.
--
-- In the application, set the Database property of the connection:
--
-- DXSQLConnection1 ...

-- 04_create_database.sql
-- Lesson 4: Create a database inside a schema.
--
-- A database is one file on the server that holds tables. You create the
-- tables in lesson 6, once you have selected this database in lesson 5.

-- Make sure the schema exists (it is safe to run more than once).
CREATE ...

-- 03_use_schema.sql
-- Lesson 3: Choose the current schema with USE.
--
-- USE sets the current schema for your session. After USE, a database name
-- without a schema part means "inside the current schema".
-- For example, after USE training, the name shop means training.shop.
-- USE does not ...

-- 02_create_schema.sql
-- Lesson 2: Create a schema.
--
-- A schema is a group of databases. It is the first level of organisation.
-- Creating a schema makes a folder on the server. Schemas are created by
-- an administrator (or by a user with the right to create in the server).

-- Create the ...

-- 01_look_around.sql
-- Lesson 1: Look around the server before creating anything.
--
-- Run this with no database selected. These are server commands, not
-- table commands: they work on the server itself.

-- List every schema (a group of databases) that you can see.
SHOW SCHEMAS;

-- List ...

00_README.txt

DXSQL(cube) SQL LESSONS
=======================

Who these are for: someone who has never written SQL.

How to run?
----------
1. Using our 32bit Windows Client - Connect with a user who can create schemas (an administrator), or a user
who has been granted CREATE on a schema ...

dxsql-lessons/
00_README.txt how to run the lessons, sample data model
01_look_around.sql SHOW SCHEMAS, SHOW DATABASES
02_create_schema.sql CREATE SCHEMA, DROP SCHEMA
03_use_schema.sql USE, current schema
04_create_database.sql CREATE DATABASE, DROP DATABASE
05_select_database.sql selecting ...

SQL is a Standard - BUT....

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. From SQL:92 ... https://en.wikipedia.org/wiki/SQL:2023 "SQL:2023" - Wikipedia - there current is not a SQL:2026 version.

However, to be compliant with the ANSI standard, they all ...