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.
If not, please visit our shop at http://www.components4developers.com and extend your SAU with another 12 months.
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.
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