AidAim Software introduces EasyTable 4.15.

EasyTable is BDE alternative database system with SQL support.

Key features:
-------------
- No BDE, no DLLs, no OCX
- SQL'92 subset
- Single database file
- Compiles right into EXE
- Small footprint
- The fastest access and search by multi-indexes
- Data encryption
- BLOB compression
- Shareable-in-memory tables
- In-memory mode
- Lots of demos for Delphi and C++ Builder
- Fully compatible with TTable, TQuery and standard DB-aware controls

SQL supported in EasyTable 4.15

- SELECT [DISTINCT | ALL] columns_list
[INTO destination_table]
FROM table_reference
[[join_type] JOIN] table_reference]
[ON join_condition] | USING (join columns)]
[WHERE predicates]
[ORDER BY order_list]
[UNION [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[EXCEPT | MINUS [ALL] [CORRESPONDING ...]]
[INTERSECT [ALL] [CORRESPONDING ...]]

- CREATE TABLE, DROP TABLE, ALTER TABLE statements
- CREATE INDEX, DROP INDEX statements
- INSERT, UPDATE, DELETE statements
- SQL scripts (multiple commands separated by ';')
- Parameters in queries

Further SQL supported in EasyTable 4.20 (scheduled to the end of November)

- SELECT [DISTINCT | ALL] columns_list
[INTO destination_table]
FROM table_reference
[[join_type] JOIN] table_reference]
[ON join_condition] | USING (join columns)]
[WHERE predicates]
[GROUP BY group_list]
[HAVING predicates]
[ORDER BY order_list]
[UNION [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[EXCEPT | MINUS [ALL] [CORRESPONDING ...]]
[INTERSECT [ALL] [CORRESPONDING ...]]

- BETWEEN, IN operators
- Aggregate functions COUNT,SUM,MIN,MAX,AVG
- Support for subqueries
- Saving database structure and data to SQL script

For a more detailed list of EasyTable features,
please visit http://www.aidaim.com

--
Best regards,
Andrew Harrison,
AidAim Software,
http://www.aidaim.com
Compression, encryption and database components