EasyTable: Single-File Embedded Database,
a BDE replacement for Delphi and C++Builder
EasyTable supports a subset of SQL'92 commands since version 4.00. Now it includes most widely used SQL statements for data manipulation and definition - SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, DROP INDEX. EasyTable contains native TEasyQuery component that allows to run SQL commands and scripts in fast and easy way. EasyTable does not use any third party components or drivers. This approach allows to achieve high performance on most of SQL queries and makes distribution of applications very easy. No BDE, no dlls, no drivers needed.
You can run SQL Scripts by TACRQuery component - just assign script text to SQL property of TEasyQuery.
SQL commands should be separated by semi-colon ( ; ).
Supported SQL commands:
The examples of supported SQL commands are located in Utils directory. You can run the queries using EasyTable SQL Console utility.
The most of examples mentioned in this Guide can be executed on database DBDemos using EasyTable SQL Console.