We are happy to announce the latest and greatest release of our memory table.
Whats new in 7.77.10 September 16 2017
Added support for SQL DDL statements:
LIST TABLES, LIST INDEXES FOR TABLE xxx,
DESCRIBE TABLE xxx, DESCRIBE INDEX xxx FOR TABLE xxx
and some variations (ON instead of FOR, TABLE keyword
optional in INDEX statement).
Added support for CASE WHEN THEN ELSE END in both forms.
Added support for NOT IN, NOT BETWEEN, NOT LIKE
Fixed CREATE TABLE issues.
Added support for SELECT INTO
Added support for SQL multistatements. Statements separated
by ; (semicolon)
Added support for ALTER TABLE ADD COLUMN, ALTER TABLE DROP COLUMN,
ALTER TABLE MODIFY/ALTER COLUMN, ALTER TABLE RENAME TO
Added support for EXISTS TABLE and EXISTS INDEX
Added support for DEFAULT value in CREATE TABLE
Added support for UNIQUE constraint in CREATE TABLE
Improved SQL field datatype parsing.
Added support for OUT parameters in SQL custom functions.
Added SQLSplit (Split) custom SQL function to split strings.
Added SQLRegExp (RegExp) custom SQL function for pattern
matching and splitting
Added SQLDataType (DataType) custom SQL function for splitting
SQL datatype declaration.
Added Options:TkbmSQLOptions property to TkbmMemSQL.
soOrderByNullFirst – Default Null orders last in comparison
soOldFieldNamingSyntax – Revert to old field naming syntax
soOldLikeSyntax – Revert to old wildcard style like syntax
else use true SQL style format using % and ?.
Added multiple overloaded ExecSQL functions to TkbmMemSQL to
allow easy one line calls. If source table names are not provided
they will be named T1..Tn.
Changed to support multiple SQL parsing errors before erroring out.
Professional Edition is released with source and additional performance enhancement features to holders of an active kbmMW Pro/Ent Service and Update subscription (SAU).
A free CodeGear Edition can be found bundled with kbmMW CodeGear Edition
for specific Delphi versions.
kbmMemTable supports the following development environments:
RAD Studio Delphi/C++ 10.2 Tokyo
RAD Studio Delphi/C++ 10.1 Berlin
RAD Studio Delphi/C++ 10 Seattle
RAD Studio Delphi/C++ XE8
RAD Studio Delphi/C++ XE7
RAD Studio Delphi/C++ XE6
RAD Studio Delphi/C++ XE5
RAD Studio Delphi/C++ XE4
RAD Studio Delphi/C++ XE3
RAD Studio Delphi/C++ XE2
Lazarus 1.2.4 with FPC 2.6.4
And can be used on Android, IOS, Linux, OSX and Windows 32/64 bit platforms.
kbmMemTable is the premier high performance, high functionality in memory dataset for Delphi and C++Builder with kbmMemTable Professional topping the scales as being the worlds fastest!
If you have an up to date Service and Update (SAU) subscription, then you can immediately visit https://portal.components4developers.com to download the latest kbmMemTable release.
