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.

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.