New features and enhancements:
  1. 1. Two TFIBDatabase methods supporting new commands RDB$GET_CONTEXT and RDB$SET_CONTEXT implemented in Firebird 2 have been added.

    function GetContextVariable (ContextSpace: TFBContextSpace; const VarName: string): Variant;
    procedure SetContextVariable (ContextSpace: TFBContextSpace; const VarName, VarValue: string);

Bugs fixed:

  1. 1. An error in the TpFIBQuery.SetAsExtended method. Fixed.
  2. A minor memory leak in RegUtils. Fixed.
  3. An error occurring on writing into a Blob field with TDataSetProvider. Fixed.
  4. An error "Can't read buffer. Invalid RecordNo”, occurred under certain conditions. Fixed.
  5. Wrong results of calling the Refresh method in TpFIBDataSet occurred under certain conditions. Fixed.
  6. An error on reading a Blob field in the OnCalcFields handler. Fixed.
  7. An error in the Locate method of the TpFIBDataSet component occurred in case when not all records were fetched from the server. Fixed.
  8. Wrong results of the Origin property with FieldOriginRule = forNoRule Fixed.
  9. An error of generating SQL statements with UpdateOnlyModifiedFields=True in the TpFIBDataSet component (appeared in NUMERIC(18,x) fields on trying to replace the NULL value by 0 and vice versa. FIBPlus wrongly considered these fields non changeable).
  10. Wrong work of DisplayFormat for NUMERIC(18,x) fields. It occurred on using non mask symbols, i.e. "$ #,000 and 00 cents". Fixed.
  11. An error in client calculated fields. (The buffer was not cleared before the field calculation. The error occurred in case when a field was calculated for the previous record, not for the current one in OnCalcFields. Then, instead of an empty value, the previous record value was shown in the current record). Fixed.
  12. Wrong search of the True Boolean value in TpFIBBooleanField. Fixed.
  13. An AV in TFIBStringField occurred under certain conditions when using the psSetEmptyStrToNull property. Fixed.
  14. Useless quotes in the automatic GeneratorName value. Fixed.
  15. An error of defining key fields in SQLEditor Fixed.
  16. Nested parameters were not set in RefreshSQL on using macros. Fixed.

Preview text: Read about new methods for better Firebird 2 support and many bug fixes
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...


During a re-write of a very large software system we were having some difficulties utilizing a 3rd party grid that we had chosen. The dataset connectivity was very flaky due to the complex joins and updates we were using which caused the grids to behave very sketchy.  FIBPlus was the perfect solution for us. After implementing it everything became so much easier. The grid functionality stabilized, data retrieval was much faster, and we were pleasantly surprised by many of the unique features of your components. We were especially impressed with your pFIBUpdateObject components which allowed us to very easily update the multiple tables we were using in our joins.  Many thanks for your great components.


Tracy Anderson, Team Leader, EDSS Division of AADG, Inc.
Download full versions and updates in your Personal Area