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.