SQLMemTable is a fast and easy-to-use in-memory table and query components
EditBy: SQLMemTable is a simple and fast in-memory table and query for Delphi and C++ Builder.
SQLMemTable includes three visual components:
-TSQLMemTable which is a fast and easy in-memory TTable replacement;
-TSQLMemQuery that provides a subset of SQL92 operators;
-TSQLMemBatchMove which is very close to TBatchMove and supports almost all of its functionality.

SQLMemTable does not require BDE and provides all the TTable functions such as master / detail relationship, filtering, searching, sorting, blob fields, key and range methods, as well as some advanced features like blob fields compression and Unicode support.

SQLMemTable provides the following services:
-SQL (DML & DDL) commands support;
-Referential Integrity support (foreign keys)
-BatchMove component;
-master / detail relationship;
-creating, renaming, emptying, deleting and restructuring tables;
-creating, editing, deleting, browsing and searching for records;
-creating and deleting multiple indexes;
-calculated and lookup fields;
-filtering support;
-BLOB fields compression;
-Multi-thread access;
-importing from and exporting to any dataset in fast and easy way;
-internationalization / localization and Unicode support.
SQLMemTable is a fully functional in-Memory Database System; it includes table, query and Batch MOVE components as well as useful utility (with source code), demos and comprehensive help. SQLMemTable does not require BDE or any external drivers and has small footprint.
Features:
-Compactness
-High performance
-Functionality
-Compatibility
-Convenience

new:
. New functions added to SQL engine:
# CUMSUM (Mathematical)
# CUMPROD (Mathematical)
# GROUP_CONCAT (Aggregate)

2. Compatibility with Delphi and C++ Builder 2010 Improve you can free download AidAim SQLMemTable (delphi 4) 4.10 now.