This release is a requirement for kbmMW v. 5.06.00, and contains:
Fixed GROUP BY on selection field with alias.
Fixed compilation error when using kbmSQL’s filter expresion.
Changed to always mark inserted records as usInserted regardless of EnableVersioning setting.
Added support for specifying column index (1..n) in SQL ORDER BY and GROUP BY. The column index refers to the order of the selection expressions.
Added sanity check if GROUP BY is missing in some aggregation situations.
Changed SQL Date() and Time() functions to return ftDate, ftTime respectively.
Changed SQL Year(), Month(), Day(), Hour(), Minute() and Second() functions to return ftInteger.
Fixed kbmSQLMergeDataTypes to correctly merge ftDate and ftTime to ftDateTime.
Added support for SQL compilation of additional expressions based on already compiled node tree. Mostly for use by kbmMW.
Now bundles CHM documentation for no extra cost!
See the full list at end of post.
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.
Whats new in 7.79.00 Jun 2 2018
——————————–
– Required for kbmMW v. 5.06.00.
– Fixed GROUP BY on selection field with alias.
– Fixed compilation error when using kbmSQL’s filter expresion.
– Changed to always mark inserted records as usInserted regardless
of EnableVersioning setting.
– Added support for specifying column index (1..n) in
SQL ORDER BY and GROUP BY. The column index
refers to the order of the selection expressions.
– Added sanity check if GROUP BY is missing in some aggregation situations.
– Changed SQL Date() and Time() functions to return ftDate, ftTime respectively.
– Changed SQL Year(), Month(), Day(), Hour(), Minute() and Second() functions
to return ftInteger.
– Fixed kbmSQLMergeDataTypes to correctly merge ftDate and ftTime to ftDateTime.
– Added support for SQL compilation of additional expressions based on
already compiled node tree. Mostly for use by kbmMW.
One thought on “ANN: kbmMemTable v. 7.79.00 Standard and Professional Edition released”
In kbmMemTable v. 7.80.00 this not working
kbmMemSQL.ExecSql(‘SELECT * FROM A ORDER BY Field1, Field2’)
Gives exeption
Exception.Create(‘Order field not a selection field: A_Field1);
kbmMemSQL.ExecSql(‘SELECT * FROM A ORDER BY 1,2’) is fine
In kbmMemTable v. 7.80.00 this not working
kbmMemSQL.ExecSql(‘SELECT * FROM A ORDER BY Field1, Field2’)
Gives exeption
Exception.Create(‘Order field not a selection field: A_Field1);
kbmMemSQL.ExecSql(‘SELECT * FROM A ORDER BY 1,2’) is fine