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

Overview

Introduction

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
Operators
Functions
Using parameters

EasyTable: Easytable Bde Alternative Single File Delphi Databas

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

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