Elevate Software announces V2.27 release of ElevateDB

11Jan 2018 by richard@baronsoftware.com

ElevateDB

Elevate Software announces V2.27 release of ElevateDB

ElevateDB is licensed per-developer, and includes royalty-free distribution. License management isn’t required at all.  The software is written for Delphi development and brings out the ability of handling multiple users for a small company.  Flexible database commands allow SQL-like searches, modifications and extractions.  Great product for a small amount upfront.

The following are breaking changes in 2.27

  • The XML output from the EXPORT TABLE SQL statement now includes a top-level “table” element in order to properly adhere to the XML specifications and allow exported XML files to be properly validated.
  • Comparisons between timestamp values and date values now ignore the time portion of the timestamp value and only compare the date portion of the timestamp value with the date value.

2.27 New Features

  • New VCL TEDBDataSet Import and Export methods have been added to allow for the import/export of files to/from TEDBTable, TEDBQuery, TEDBScript, and TEDBStoredProccomponents.
  • A new LOG EVENT SQL/PSM statement has been added in order to allow SQL/PSM routines (scripts, procedures/functions, triggers, and jobs) to log information, warning, and error events directly to the logged events for the current ElevateDB configuration.
  • There are new VCL TEDBEngine AddDayTimeToDateTime, AddDayTimeToTime, AddYearMonthToDate, AddYearMonthToDateTime, SubtractDateFromDateAsDayTime, SubtractDateFromDateAsYearMonth, SubtractDateTimeFromDateTimeAsDayTime, SubtractDayTimeFromDateTime, SubtractDayTimeFromTime, SubtractTimeFromTimeAsDayTime, SubtractYearMonthFromDate, and SubtractYearMonthFromDateTime methods that allow for basic interval math directly from native code, in addition to SQL.
  • As noted above in the breaking changes section, you can now directly compare the date portion of timestamp values with date values.
  • ElevateDB now logs warning events to the logged events for the current ElevateDB configuration when a database is opened and the database path does not exist, or if the database catalog does not exist.
  • The ALTER INDEX and ALTER TEXT INDEX SQL statements no longer alter the entire index when only the description is changed.