User defined functions and kbmMemSQL

Published on :

[updated with additional standard functions] As you may know, the widely used kbmMemTable also supports querying and more using a SQL92 like syntax via the component TkbmMemSQL. This article explains how to create UDF (user defined functions) that can be used as part of the SQL statement. Although UDF has been supported for a long […]

kbmMemTable SQL new features coming

Published on :

In the upcoming release of kbmMemTable, a number of improvements of the optional SQL parser is included. Now the following syntax is also supported (see examples further down): CASE … WHEN … THEN … ELSE… END SELECT … INTO… FROM…. CREATE TABLE CREATE INDEX DROP INDEX ALTER TABLE… ADD COLUMN… ALTER TABLE… DROP COLUMN… ALTER […]