Elevate Software


Login Login

ProductsBulletSalesBulletSupportBulletDownloadsBulletAbout





Home » Elevate Software Blog

Icon Elevate Software Blog

Tags Showing all blog entries tagged with "ElevateDB"

ElevateDB 2.27 Released
Posted by Tim Young on Thu, Jan 11 2018

ElevateDB 2.27 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The complete list of breaking changes and new features is below.

2.27 Breaking Changes
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.

    Information The IMPORT TABLE SQL statement can still import XML files formatted with or without the top-level "table" element.


  • 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. This means that you can now execute queries like the following:

    SELECT * FROM MyTable WHERE TimeStampColumn = DATE '2017-10-17'

    and the query will return all rows where the TimeStampColumn column contains a timestamp value whose date portion matches the specified date constant value.


  • As indicated in incident report #4609:

    # 4609 Default Expressions for DECLARE SQL/PSM Statements Not Being Properly Type-Checked

    default expressions for DECLARE SQL/PSM statements were previously not being type-checked properly, so you may see new type errors during compilation of routines that do not specify correct default expressions for a given variable type.
2.27 New Features
The following are the new features in 2.27:
  • New VCL TEDBDataSet Import and Export methods have been added to allow for the import/export of files to/from TEDBTable, TEDBQuery, TEDBScript, and TEDBStoredProc components.


  • 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.
In addition, this release contains several bug fixes, which are detailed here.

Tags: ElevateDB, New ReleasesPermanent Link0 Comments

ElevateDB 2.26 Build 7 Released
Posted by Tim Young on Fri, Nov 24 2017

ElevateDB 2.26 Build 7 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. This build contains several important bug fixes, which are detailed here.

Tags: ElevateDB, New BuildsPermanent Link0 Comments

ElevateDB 2.26 Build 6 Released
Posted by Tim Young on Mon, Oct 30 2017

ElevateDB 2.26 Build 6 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

This build contains one important bug fix:

# 4590 Querying an Updateable View with Sub-Query SELECT Expressions Can Cause AV


Tags: ElevateDB, New BuildsPermanent Link0 Comments

ElevateDB 2.26 Build 5 Released
Posted by Tim Young on Thu, Oct 26 2017

ElevateDB 2.26 Build 5 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

This build contains a few important bug fixes, which are detailed here.

Tags: ElevateDB, New BuildsPermanent Link0 Comments

ElevateDB 2.26 Build 4 Released
Posted by Tim Young on Wed, Sep 13 2017

ElevateDB 2.26 Build 4 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

This build contains a couple of important bug fixes, which are detailed here.

Tags: ElevateDB, New BuildsPermanent Link0 Comments

ElevateDB 2.26 Build 3 Released
Posted by Tim Young on Tue, Aug 15 2017

ElevateDB 2.26 Build 3 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

This build contains one important bug fix, which is detailed here.

In addition, in this build the VCL product DCUs for Delphi 10.2 Tokyo are now compiled with Delphi 10.2 Tokyo Update 1.

Tags: ElevateDB, New BuildsPermanent Link0 Comments


Previous Entries: 1-6 7-12 13-18 19-24 25-30 31-36 37-42 43-48 49-54 55-60 61-66 67-72 73-78 79-84 85-90 91-96 97-102 103-108 109-114 115-120 121-126 127-132
Image