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.

Loading

One thought on “ANN: kbmMemTable v. 7.79.00 Standard and Professional Edition released”
  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.