mwasoftware.co.uk

MWA Software is pleased to announce that release 2.3.4 of IBX for Lazarus is now available for download from https://mwasoftware.co.uk/ibx.

This is the first update in over a year and provides a consolidated set of minor bug fixes. The changelog for IBX itself is available from here and the changelog for the Firebird Pascal API is available from here.

The next release of IBX should be available in the near future and will focus on support for the forthcoming Firebird 4. It will provide support for the new Firebird data types including TIMESTAMP WITH TIME ZONE and extended precision numerics (DecFloat).

MWA Software is pleased to announce that release 2.3.3 of IBX for Lazarus is now available for download from https://mwasoftware.co.uk/ibx. This release continues to track Lazarus 2.0 updates. Recent updates to the LCL TDBLookupComboBox have necessitated further changes to TIBLookupComboEditBox in order to ensure that TIBLookupComboEditBox continues to work when the DataSource is nil (i.e. with only a ListSource).

Otherwise, 2.3.3 consoliates further updates added to the IBX svn trunk since 2.3.2 including:

- ConfigOverrides for both TIBDatabase and TIBXServicesConnection
- Improvements to TIBCSVDataOut, TIBInsertStmtsOut and TIBBlockFormatOut.
- Case Sensitive Parameter Name support
- TIBDatabase.Attachment and TIBXServicesConnection.ServicesIntf are now read/write properties
- TIBQuery and TIBDataSet now support the TDataset.Filter property for server side filtering of SQL result sets.
- Minor bug fixes (see release notes for details).

The latest release candidate for Lazarus 2.0 is recommended for use with IBX 2.3.3. IBX 2.3.3
has been tested with the up-to-date fixed branch for Lazarus 2.0.

MWA Software is pleased to announce that release 2.3.2 of IBX for Lazarus is now available for download from https://mwasoftware.co.uk/ibx. Older versions of IBX will fail to compile with Lazarus 2.0 and upgrade to this version is necessary for use with Lazarus 2.0. All users are recommended to upgrade to the new release. Please read the changelog before upgrading. The release also includes a new SQL Tokeniser and the ability to select the Firebird Library (DLL or shared object) as a property of TIBDatabase or TIBXServicesConnection. Several minor bug fixes are also included.

The release fixes two problems with use of Lazarus 2.0:

  1. A deprecated function that is no longer supported with Lazarus 2.0 has been replaced.

  2. TIBLookupComboEditBox is derived from Lazarus TCustomDBComboBox. In Lazarus 2.0, TCustomDBComboBox takes a more restrictive view of combo boxes that do not have a DataSource. This prevents TIBLookupComboEditBox from being used to select rows in a list dataset when no DataSource is present. TIBLookupComboEditBox has been updated to include a workaround in order to restore previous functionality.

The new SQL Tokeniser has been primarily developed in order to avoid mis-identification of PSQL parameters within BEGIN..END blocks as IBX query parameters. This allows parameterised EXECUTE BLOCK statements to be supported. The new SQL Tokeniser is also used for TIBSQLParser and TIBXScript, in both cases removing duplicate code.

Both TIBDatabase and TIBXServicesConnection now include a new property "FirebirdLibraryPathName". This can be used to explicitly specify the full path to the firebird client library (DLL or shared object). For example, when the library is in a non-standard location or to avoid ambiguity when more than one library is installed. In principle, each instance of TIBDatabase or TIBXServicesConnection could use a different version of the library.

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