MWA Software is pleased to announce the 2nd pre-release of IBX2 for Lazarus. it is available here.

This second pre-release fixes several problems with the first pre-release including an issue with processing large blobs (> 64K) using the FB3 API, and event handling. Issues with Character Set NONE have also been resolved.

This version also sees considerable enhancement to TIBExtract and TIBXScript. TIBExtract has been updated to ensure proper dependency order with the extracted SQL. Data extract now includes generator values, binary blobs and arrays. The latter two data types are extracted as text objects using a simple XML format. TIBXScript has been updated to support the processing of embedded XML values as exported by TIBExtract, as well as interactive use, and support for Create Database, Connect and Drop Database statements.

The changes to TIBExtract and TIBXScript can be seen in the updated example program "fbsql". This now includes the capability to dump an entire database including binary blobs and arrays into a single text file and to recreate the database by reading from such a text file. While less compact than gbak format, this nevertheless is potentially very useful for tasks such as complex DDL changes with multiple dependencies, or removing not null constraints. fbsql can now also be used interactively from the command line.

Although nearing stability, a further period of field testing is believed appropriate before IBX2 is declared suitable for operational use.

MWA Software is pleased to announce the release of IBX2 for Lazarus. This is formally a pre-release. Although the software has been put through more extensive testing that any previous release of IBX for Lazarus, there are nevertheless considerable changes to the codebase and a period of in service experience is needed before IBX2 should be considered for production use. User reports, both positive and negative, are encouraged.

IBX2 is available for download from here.

MWA Software is please to announce release 1.4.3 of IBX for Lazarus. This is a maintenance release primarily of interest to Windows users. Specifically:

1. A workaround is provided for bug http://bugs.freepascal.org/view.php?id=30622. This bug results in an empty string when transliterating to the CP_NONE character set on Windows and caused several reported errors in IBX.

2. TIBStringField and TIBMemoField now always return UTF8 encoded strings (strings received from the database), if necessary transliterated from the character used to return the string. This avoids LCL issues where the LCL assumes UTF8.

For other changes please see the change log.

This is intended to be the last release in the IBX 1.x.x series. IBX2 is now in testing and will include support for both the legacy Firebird API and the new Firebird 3 API. IBX2 will require fpc 3.0.0 and Lazarus 1.6.0 or later.

MWA Software is pleased to announce that release 1.4.2 of IBX for Lazarus is now available for download. This is a minor release necessary to overcome a compiliation problem with Lazarus 1.7.0 and later due to UTF8 functions being removed from Sysutils. The release also fixes some other minor bugs.