What’s new in FIBPlus 5.2?

Features and enhancements:

  1. FIBDataSet handlers added:
  • property BeforeStartTransaction: TNotifyEvent;
  • property AfterStartTransaction: TNotifyEvent;
  • property BeforeEndTransaction: TEndTrEvent;
  • property AfterEndTransaction: TEndTrEvent;
  • property BeforeStartUpdateTransaction: TNotifyEvent;
  • property AfterStartUpdateTransaction: TNotifyEvent;
  • property BeforeEndUpdateTransaction: TEndTrEvent;
  • property AfterEndUpdateTransaction: TEndTrEvent;
  1. An ability to generate a single chosen modifying query instead of all has been added to SQL Generator.
  2. A component editor for pFIBQuery has been added.
  3. SQL Generator component editor and Dataset Repository editing dialog have been rewritten.
  4. The poFetchAll option has been added to TpFIBDataSet.Options. If it is true, after opening TpFIBDataSet all the records will be automatically fetched from the server.
  5. A new event OnApplyDefaultValue: TOnApplyDefaultValue has been added to TpFIBDataSet, where

    TOnApplyDefaultValue = procedure (DataSet: TDataSet; Field: TField; var Applied: boolean) of object;

    The event handler is called for each field with a not null DefaultExpression during insertion of a new record. In this handler you can handle DefaultExpression for some fields yourself if a standard handling procedure doesn’t suit for these needs. You should set Applied to True in order to handle it manually and deactivate standard handling.

  6. Now FIBPlus behaves differently on changing the saved metadata cache. The check is done not after connection, but at times, when necessary. So is some cache parts are not required in the meanwhile, it won’t be checked.
  7. DataSet Repository cache saving has been implemented. To make this possible we have added another field with a number of a repository record version to the DataSet Repository table. To automatically change the repository table structure call the repository editor using the pop-up menu in TpFIBDatabase.
  8. A new variable FIBHideGrantError: boolean = False has been added. When the variable is True, and TpFIBDataSet has no data modification rights, it deactivates data editing or deleting ability without error messages.
  9. In TpFIBDataSet the OnCompareFieldValues: TCompareFieldValues event has been added, where TCompareFieldValues = function (Field: TField; const S1,S2: variant): integer of object. The event handler is called during local sorting. Using it you can control sorting order and compare values transferred in pairs.
  10. Support of comments with the marker '--' has been activated.
  11. An ability to set defaults for TpFIBDataSet.DefaultFormats has been added to FIBPlusTools.


  1. A minor bug of work in the poProtectedEdit mode.
  2. Minor changes in Conditions saving procedures in the .dfm file.
  3. Now in the active poImportDefaultValue mode DefaultExpression for string fields is shown in single commas by default. This was done to avoid problems with ClientDataSet, if a string field is '1xxxxx' by default.
  4. The way of keeping the Options property in the .dfm file has been changed.
  5. Replacement of NULL parameters to "Is Null” is corrected now to avoid incorrect work for such expressions as ttt = :ttt <arithmetic operation> <statement>.
  6. Stack Overflow on local sorting by the calculated field. Fixed.
  7. Incorrect work of TpFIBDataSet in the poProtectedEdit mode. (The current position was lost in TFIBDataSet at times). Fixed.
  8. An error «XSQLDA index out of range» during work with macros in datasets with the poNoForceIsNull option. Fixed.
  9. Local sorting procedure has been corrected.
  10. Work with blob-fields for datasets working with two transactions. Fixed.
  11. In Delphi 5 after ReopenLocate in data-aware controls the data change event did not appear, so old data was shown. Fixed.
  12. After execution of Append the RecNo property returned an incorrect value. It was always equal to 1 irrespective of the real record number. Fixed.
  13. Incompatibility of poProtectedEdit and UpdateOnlyModifiedFields modes. Fixed.

Preview text: What's new in FIBPlus 5.2
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...


We are a small software company with thousands of customers delivering comany wide systems including accounting, logistics, e-commerce, POS, sales etc etc. Several years ago, when we were still a very small company, we used Delphi 3 and Paradox combined with BDE. As our system (and customer base) grew I decided to switch to Delphi 5 and Interbase. Being a huge improvement over Delphi 3 and Paradox, I encountered numerous problems with IBX: memory leaks, performance issues and other problems. Borland was not to be bothered: IBX was provided "as is" and no support was avaliable. 
Not being very eager to use third party components with Delphi at first, I decided to give FIBPlus a try. At once all problems where gone: no more memory leaks and  performance was very consistent. 
But the real advantage of switching to FIBPlus came with the upgrade to D2005: after upgrading there were some problems with the new FIBPlus version. After emailing the problem I received an update within an hour! And this was at 11 pm! A few other (smaller) errors where handled in the same way. 
Our motto is: software is as good as its support. And support of Devrace is just great!
Just a little indication of our FIBPlus use: all our software runs 100% on FIBPlus. Our customers have a total of aprox. 4.800 Firebird databases in production, with a combined size of over 130TB and over 80 million transactions a day. Every
day. And FIBPlus has not failed a single transaction. Not once. There is, however, one (minor) drawback in using FIBPlus: while debugging an application which uses and invalid SQL instruction, de Delphi Debugger returns to the FIBPlus code instead of to our calling code (where the actual error comes from), thereby complicating de debug proces a little. But that is a very small price to pay for a otherwise brilliant third party solution! >>

Bas Jordans JorSoft Ltd
Download full versions and updates in your Personal Area