New features and enhancements:

  1. Support of C++ Builder 2006 has been added.
  2. Support of charset UTF8 fields for Firebird 2 has been added.
  3. TpFIBDatabase has a new property UseBlrToTextFilter :Boolean. It activates/deactivates handling of BLOB fields with Blr (2) and Acl(3) subtypes.
  4. Now the FIBDatabase.QueryValueAsStr method returns an empty string, if the query returns nothing or the Null field.
  5. TpFIBDatabase has a new event handler: TOnApplyFieldRepository=procedure(DataSet:TDataSet;Field:TField;FieldInfo:TpFIBFieldInfo) of object;
  6. DSContainer has a new event handler: TOnApplyFieldRepository=procedure(DataSet:TDataSet;Field:TField;FieldInfo:TpFIBFieldInfo) of object;
  7. DSContainer has a new property: IsGlobal:boolean. If this property is set to True, DSContainer works for ALL datasets of the application.
  8. SQL queries "COMMIT" and "ROLLBACK" are handled differently now. Instead of the queries the server gets corresponding transactions. Such behaviour enables to correctly close the queries, executed in the closed transaction.

Note: New features 4-6 enable developers to easily use their own settings in the field repository.


If you need to set the EditMask property, add the EDIT_MASK field to the repository table; create a container; make it global by setting the IsGlobal property to True; and write the following code in the OnApplyFieldRepository event handler:

procedure TForm1.DataSetsContainer1ApplyFieldRepository(DataSet: TDataSet; 
Field: TField; FieldInfo: TpFIBFieldInfo); 

Bugs fixed:

  1. The error repository editor incorrectly worked on selecting "Unique Indices". Fixed .
  2. An error in the method FIBDataSet.RecordFieldValue(Field:TField;aBookmark:TBookmark):Variant; has been fixed.
  3. If the PLAN clause in TpFIBDataSet.SelectSQL used implicit JOIN which began with (, and a new value was set to TpFIBDataSet.PlanClause, the query resulted with a wrong PLAN clause (with unnecessary ( symbol after the word PLAN). Fixed.
  4. Incorrect error message handling of user exceptions in TpFibErrorHandler for Firebird 2 (because of a new feature PSQL Stack Trace in FB2). Fixed.
  5. Incorrect handling of lost connection on restoring attempts. Fixed.
  6. There was no BOOLEAN field handling in TFIBCustomDataSet.RecordFieldValue for InterBase 7. Fixed.
  7. An error CloneCurRecord: error with boolean field in record (IB7). Fixed.
  8. An error in LocateNext. LocateNext returned True if the last dataset record satisfied the Search conditions and Search started with this record. Fixed.
  9. Incorrect work of LocateXXX methods with calculated field filtering. It appeared if Locate was done in not calculated fields, whereas filtering (Filtered) was done in calculated fields. Fixed.
  10. EAccessViolation after handling OnUpdateError if CachedUpdates=True and OnUpdateError "UpdateAction:=uaAbort;". Fixed.
  11. An error of working with stored procedures in SQLEditor. Fixed.
  12. An error on generating RefreshSQL, if the table alias began with "AS". Fixed.
  13. An error of executing several execute blocks. Fixed .
  14. An error of lost connection handling in case of multiple connections to different databases. Fixed .
  15. A minor error in FIBQuery.PrepareArraySqlVar. Fixed.
  16. An error of setting a string value '000...' to the BCD field. An example: FIBBCDField1.asString:='0000'; Fixed.

Preview text: What's new in version 6.45: 7 enhancements, 16 bug fixes. Support of C++ Builder 2006.
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