Elevate Software


Login Login

ProductsBulletSalesBulletSupportBulletDownloadsBulletAbout





Home » Elevate Software Blog

Icon Elevate Software Blog

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

Elevate Web Builder 2.06 Build 11 Released
Posted by Tim Young on Tue, Nov 28 2017

Elevate Web Builder 2.06 Build 11 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 bug fixes, which are detailed here.

Tags: Elevate Web Builder, New BuildsPermanent Link0 Comments

Progress Update on Elevate Web Builder 2.07
Posted by Tim Young on Mon, Nov 27 2017

I just wanted to take some time to update everyone on the (now) very-late 2.07 update to Elevate Web Builder and solicit some comments on potential areas of improvement in the IDE. I also figured that I would do this in a proper blog post, primarily because I don't blog enough about what's going on here at Elevate Software and this is an effort to change that. Smile

To recap, Elevate Web Builder 2.07 will be quite a big update for a minor release. In fact, it's essentialy a major release crammed into a minor release. The list of improvements include:
  • The IDE has been given a facelift and looks quite a bit different in several ways. Part of this is due to the need of starting the process of making the IDE high-DPI aware, and the other part is the need to improve the look and feel of the IDE, especially in terms of negative space and ease-of-use. The new IDE tries very hard to make sure that what one needs is only a single click or keystroke away, whether it be recent projects or saving debug messages to a text file.


  • The web server has also been given a facelift, in addition to several other major improvements listed below. There isn't a user interface for the web server anymore, and instead all administration is performed through the IDE or via a web interface. You can still run the web server as an interactive console process for development purposes, but it is primarily designed now to run exclusively as a service without a user interface.


  • The web server now includes built-in SSL support. The first platform supported will be Windows, of course, so I have implemented the SSL support using the Windows crypto API. This will make things easier to deal with in terms of Windows security updates and improvements, and allow administrators to control how the web server works in terms of which crypto cipher suites are used, as well as which base versions of SSL/TLS are used. And all of this can occur without the developer needing to configure anything in the web server itself, making deployments much easier. Other future platform targets will use the OpenSSL libraries.


  • The web server now includes built-in GZip support. This will greatly improve the Elevate Web Builder client application loading performance over slow connections (mobile), especially when updates to the client applications are deployed.


  • The web server now includes support for loading and executing server-side applications that use the Elevate Web Builder runtime. The runtime is an interpreted Object Pascal execution environment that has been present in the IDE since Elevate Web Builder 2.00, but has only been used for design-time execution of code. It has been updated to include functionality for working with web server requests, files, HTML, and more. What this means is that 2.07 will allow you to create and deploy server-side applications in much the same way that you do now for client applications that run in a browser.


  • The IDE now includes support for creating server-side applications that use the Elevate Web Builder runtime available in the web server. The server-side applications are monolitic and self-contained, so there are no dependency issues. The server-side applications are also compressed, and can be encrypted in order to keep the code secure.
At this point, I'm hoping that we can get a public beta out before Christmas. However, in the meantime, I need some input from everyone on any minor changes that they want to see in the IDE that aren't there currently. What I mean by "minor" are features that are useful for productivity or usability and are mostly cosmetic. Features like code completion or other related code editor features rely on incremental compilation improvements to the Elevate Web Builder compiler, and will be coming next in the compilation improvements to the Elevate Web Builder compiler. So, those types of features are not what I'm looking for. For example, a component navigator was added to the IDE for 2.07 that allows you to see the designer components in a treeview on the left. The component palette was also changed so that it shows the name of the component in addition to the component icon. Things along those lines are what I'm looking for, especially if it deals with improving the productivity or usability of the IDE.

Thanks very much for your feedback.


Tags: Elevate Web Builder, 2.07 Progress Update, Server-Side ApplicationsPermanent Link37 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

Elevate Web Builder 2.06 Build 10 Released
Posted by Tim Young on Thu, Oct 26 2017

Elevate Web Builder 2.06 Build 10 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: Elevate Web Builder, 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 133-138 139-144 145-150 151-156 157-162 163-168 169-174 175-180 181-186 187-192 193-198 199-204 205-210 211-216 217-222 223-227
Image