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 SQL’92 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.

New features:

  • New SQL functions were added: ABS; CEILING, CEIL; FLOOR; MOD; POWER, POW; RANDOM, RAND; ROUND; SIGN; TRUNCATE,TRUNC; HEX.
  • New SQL operators were added: %, mod (same as MOD(x,y)); shl, << (shift left); shr, >> (shift right); xor, ^ (bitwise XOR); & (bitwise AND); | (bitwise OR); ~ (bitwise NOT).
  • Hex constants are now supported (both C++ and Delphi forms: 0xff and $FF)
  • C++ form of logical and comparison operators is now supported (!, &&, !=, ==).
  • The performance of in-memory tables in multi-threaded applications was essentially increased. Parallelism level is now much higher.
  • Import compatibility with MS Access database was essentially improved.
  • Column and table names can be quoted by back quote `.
  • Some demo scripts were added.

Homepage: http://www.accuracer.com/
Download: http://www.accuracer.com/products/unlock.php?product_id=12
File Size: 3.9 MB
Delphi Version: Delphi 4 - Delphi 2007
Source: None