New features and enhancements:

  1. Now the SQLMonitor shows the SQL text after applying macros and conditions.
  2. Now the OnFillClientBlob event is called after the record is first read as well as after it’s modified.
  3. TpFIBDataSet.Options has a new option poUseSelectForLock. It can be used if poProtectedEdit = True. In case poProtectedEdit = True, the record will not be locked by “dummy update”, and the following statement will be used instead:
    Select * from TABLE1 WHERE ... for update with lock
    Note: This feature works ONLY for Firebird)
  4. The FIBQuery.ExecuteImmediate method has been added. It executes the query immediately, without Prepare (see the isc_dsql_execute_immediate function in the IB API manual)
  5. Now ExecuteImmediate executes DDL queries.
  6. The CopyFieldsProperties procedure has new properties:
    AutoGenerateValue, ConstraintErrorMessage, CustomConstraint, Tag and Index.
  7. The pFIBDataSet.ReceiveEvents property and the pFIBDataSet.OnUserEvent event are being deprecated and will be removed from the main code in future versions. People, who are still using this property should compile the library with the define USE_DEPRECATE_METHODS2 in

Bugs fixed:

  1. Occasionally an incorrect record was added to a sorted dataset. Fixed.
  2. An error in TpFIBCustomService.GenerateSPB occurred if the Params property was empty. Fixed.
  3. On changing the Filter property previous filter results were not refreshed. Fixed.
  4. An error in the Locate method on searching numerical values in string fields. Fixed.
  5. The SQLMonitor worked incorrectly on exception monitoring (sometimes caused suspension). Fixed.
  6. Incorrect behaviour of the SQL dataset editor with queries containing the same table in several places. Fixed (guaranteed for Firebird 2 only).
  7. Cached calculated fields in TFIBCustomDataSet.RecordFieldValue did not have the ftSmallInt type. Fixed.
  8. Incorrect handling of fields with charset UTF8 and collate, different from the default value. Fixed.
  9. If the database was in the shutdown mode, the connection automatically closed. Then the lost connection was handled (with pFibErrorHandler). Fixed.
  10. An error in the query generator has been fixed: the field type was not shown for DOUBLE PRECISION fields. Fixed.
  11. A small memory leak on working with the BLOB parameters. Fixed.
  12. An error on locating a Unicode-string in the field varchar(unicode_fss) if poTrimCharFields was set to True. Fixed.
  13. Function InvertOrderClause(const OrderText:string):string; incorrectly functioned:
    it did not handle Order By using NULLS FIRST, and thus caused incorrect work of the confined local buffer for such queries). Fixed.
  14. TpFIBDataSet.PSInTransaction, PSStartTransaction,PSEndTransaction methods functioned incorrectly. Fixed.
  15. An error on executing DDL queries in the Unicode Connect (comments in languages other than English were corrupted). Fixed.

Preview text: What's new in version 6.5: 7 enhancements, 15 bug fixes. Better support of Firebird 2.0
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