EasyTable: Single-File Embedded Database,
a BDE replacement for Delphi and C++Builder

Previous  Top  Next


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:
·SELECT Statement  
·INSERT Statement  
·UPDATE Statement  
·DELETE Statement  
·CREATE TABLE Statement  
·ALTER TABLE Statement  
·DROP TABLE Statement  
·CREATE INDEX Statement  
·DROP INDEX Statement  

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.

See also:
Naming conventions
Using parameters

© AidAim Software EasyTable: Easytable Bde Alternative Single File Delphi Databas