Important InterBase XE 7 – Update 2

InterBase XE7 – update 2

InterBase XE7 update 2 is now available for Windows and Linux server and ToGo. This update is highly recommended for all users of InterBase XE7.

For what is new and resolved issues in InterBase XE7 Update 2, please see the online InterBase documentation. – but in short, following update 1 with some change view enhancements – update 2 contains a number of fixes to general bugs reported.

Working with reserved words.

A list of Known Issues is available in the documentation. One that I will highlight is the addition of CHANGE, CHANGED, INSERTED, UPDATED and DELETED as reserved words in InterBase XE7 due to the introduction of Change Views.

I have heard of a few cases where developers have SQL statements that have stopped workings because their tables have fields that are one of the reserved words, e.g. UPDATED; Its easily to ensure those keep working by putting field names in “quotes” in your SQL statement.

As we know a lot of developers don’t quote their field names, we are working towards either a hot-fix or an update for the future that will only work with these as reserved words IF Change Views are being used, however it is recommended that you add “quotes” to the fields in your SQL if you are at all in doubt.

Download

For registered users, you can find the patch downloads at http://cc.embarcadero.com/reg/interbase

Server Edition

Windows
http://cc.embarcadero.com/item/30198

Linux
http://cc.embarcadero.com/Item/30199 

ToGo & IBLite Edition

Registered Users Downloads

Developer edition and Trial

https://downloads.embarcadero.com/free/interbase

 

One thought on “Important InterBase XE 7 – Update 2”

Leave a Reply

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