FIBPlus version 6.5 (trial) is available for download

I am happy to inform that FIBPlus 6.5 (trial) is available for download.

As I have already announced, version 6.5 in particular has a better support of Firebird 2.0.

Purchase FIBPlus for 235 Euros only.

FIBPlus 6.5 Release Notes

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
    FIBPlus.inc.
  • 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.
  • 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...

    Leave a Reply