News

This is a very minor update and ensures that IBX will compile with the latest versions of Lazarus.. Lazarus 2.0.0 is expected to remove the deprecated function "ValidUTF8String" from the LazUtils unit. This update removes all references to  ValidUTF8String. The update is backwards compatible and should also compile correctly with earlier versions of Lazarus.

Currently, the update is only available via svn - see https://mwasoftware.co.uk/svn-repository

Details

Created: 25 October 2018

MWA Software is pleased to announce that release 2.3.0 of IBX for Lazarus is now available for download from https://mwasoftware.co.uk/ibx. All users are recommended to upgrade to the new release. Please read the changelog before upgrading.

IMPORTANT: the source code tree has been re-organised for IBX 2.3. Please remove all previous copies of the IBX source code tree before installing this release.

This release introduces the IBXServices unit. The IBXServices unit is a re-architectured update of the IBServices unit providing what is intended to be a clearer and easier to use set of IB Services components. See Chapter 10 of the IBX User Guide for more information and the guide to "Firebird Service Management Using IBX". The legacy services components are still available and provided in a separate package. There is no need to update working applications using the older versions except for an additional package dependency.

The update also includes several improvements/additions to TIBExtract and bug fixes to date.

Details

Created: 16 April 2018

MWA Software is pleased to announce that release 2.2.0 of IBX for Lazarus is now available for download from https://mwasoftware.co.uk/ibx. This is an important update to IBX and all users are recommended to upgrade to the new release. Please read the changelog before upgrade.

The main intent behind the release is to add support for the remaining Firebird 3 features (and some from earlier Firebird releases) that were not supported in release 2.1. This includes:

1. Support for SQL Statements INSERT/UPDATE/DELETE...RETURNING. The first two cases are now able to update the current row for all TIBCustomDataset descendents including TIBTable, using data returned following a row insert or update.

2. INSERT...RETURNING is used to provide support for Firebird "Identity" columns. For example, when used to provide auto-increment primary keys.

3. Firebird "Packages" are now supported by TIBStoredProc and by the SQL Component Editors.

4. Additional Firebird 3 properties are now supported by TIBDatabaseInfo and by the Services API components (e.g. TIBConfigService).

5. Alternative Security Databases are now supported by the Services API Components.

6. TIBExtract now supports DDL Grants and triggers on database objects.

7. A new IBServices component to support online validation of a database (TIBOnlineValidationService).

8. A major new example application (DBAdmin) is now included. This illustrates the use of IBX for Day-to-Day Database Administration tasks including User Management, Backup/Restore and Database Validation and Repair. It is also intended to provided a useable application that users may use directly or incorporate into their own toolsets. It also demonstrates User Management using Firebird 3 virtual tables and SQL statements. Note: this application also requires the standard Lazarus package MemDSLaz.

This release also incorporates recent bug fixes and includes a 33 page guide to the use of IBX for Firebird DBA activities.

IBX for Lazarus may be downloaded from: https://www.mwasoftware.co.uk/ibx

or by subversion from:

https://svn.mwasoftware.co.uk/public/ibx/tags/R2-2-0

Details

Created: 01 March 2018