The editor of FIBPlus DataSet Repository has been changed.
Now TpFIBDatabase has the UseRepositories property. Setting it equal False
you can deactivate by force use of any kind of repository support in the whole
The useRepositaries property has been renamed to useRepositories.
The TFIBXSQLDA.AssignValues method has been added.
have been added in FIBPlus DataSet Repository.
Dataset timers are created now not by default, but only when they are necessary.
The property ValidateAfterLoad: boolean has been added to TpFIBDatabase.CacheSchemaOptions.
If you set it equal False, FIBPlus will not try to check the saved metadata
scheme after loading.
TpFIBQuery has now the public read-write PlanClause property.
The button SaveSQL does not check the SQL syntax in SQLEditor if this check
is not activated.
The SqlTxtRtns module has been entirely rewritten.
The UpdateTransaction behaviour has been changed. Now it starts only at
the moment of execution of a modifying query. The query preparation is executed
in open transactions.
TpFIBDatabase.Gen_Id is called now in the first available open transaction
and does not create its own one.
Work with new InterBase keywords has been improved.
The AsIn64 property has been added to TFIBBCDField (for all Delphi versions
starting from Delphi 4).
A property responsible for the generator step has been added to AutoUpdateOptions
Some events have been renamed:
* TpFIBDatabase.Onlogin is changed to BeforeConnect,
* TpFIBDatabase.OnConnect is changed toAfterConnect.
Support of server exceptions during work with Foreign Keys, Check Constraints
and Unique Constraints has been added to TpFibErrorHandler.To activate this
feature you need to activate the corresponding option in the Options property
in TpFIBErrorHandler and create the following table in the database:
CREATE TABLE FIB$ERROR_MESSAGES (
CONSTRAINT_NAME VARCHAR(67) NOT NULL,
CONSTR_TYPE VARCHAR(11) DEFAULT 'UNIQUE' NOT
Creation of and work with this table is implemented in the TpFIBDataBase component
Two new properties have been added to AutoUpdateOptions:
a) ParamsToFieldsLinks: TStrings Enables to set accordance between dataset
fields and parameters in the form FieldName=ParamName. Then this accordance
is used in the internal handler before calling OnNewRecord. The parameter
value is automatically set to the defined field;
b) AutoParamsToFields: boolean If you set this property equal True, TpFIBDataSet
tries to set the ParamsToFieldsLinks property itself analyzing the SelectSQL
text. (run-time only)
The DefaultUpdateTransaction property has been added to TpFIBDatabase.
Being added to the form after setting DefaultUpdateTransaction, all the TpFIBDataSet
sets will use this property value in order to set the UpdateTransaction property.
Now TpFIBTransaction has methods:
* SetSavePoint(const Name: string) and
* RollBackToSavePoint(const Name: string)
(only for FB 1.5)
Now TpFIBDatabase has the property ServerActiveTransactions: TStringList,
which returns a list of active transaction identifiers of the current database
at the server. This list returns an ID list of transactions active at the
moment (only for FB 1.5)
Minor changes in TFIBSQLMonitor, enabling it to monitor new operations
On opening SQL Generator a table list from the database was shown while
in ListBox there was written "Closed". Fixed.
Names of the changed queries were not highlighted in the SQL editor. Fixed.
The choice variants of the key field (KeyFields) BIGINT were not added
to the dataset in AutoUpdateOptions. Fixed.
A number of bugs in FIBPlus DataSet Repository have been fixed.
The design-time editor of the Options property of TpFibDataSet did not
work, if there were chosen several components. Fixed.
Stack overflow on changing OrderClause, if the Conditions property was
Incorrect work of BatchOutputRawFile, if there were VARCHAR fields in queries.
Some changes in the FullRefresh method (the curent position of the cursor
did not remain).
UpdateTransaction works correctly now, if the database has the default
Work with macros has been improved. In particular, the error of hadnling
some SQL with macros has been fixed.
The bug with blob-fields in InternalPostRecord when CachedUpdates mode
is True. Fixed.
The default fields did not remain after FullRefresh. Fixed.
The SqlTxtRtns unit has been completely rewritten.
The insertion into an empty dataset on using a separate modifying transaction.
The changes were not written into the BLOB-field. Fixed.
In some cases Boolean fields were emulated only after Delphi restart. Fixed.
The Field designer did not start in case when an incorrect SelectSQL was
written in the dataset. Fixed.
Errors of work with RDB$DB_KEY have been fixed.
Incorrect transaction check on ApplyUpdates. Fixed.
An error in FIBDatabase.QueryValue, if the returned field is BLOB. Fixed.
The problem with non-text BLOB fields has been fixed.
Some bugs in macro functions have been fixed.
Some bugs with DDL queries have been fixed.
Access Violation in SQL Editor has been fixed.
Some bugs in the editor of the Options property of TpFIBDataSet have been
Errors of use of RDB$DB_KEY in TpFIBDataSet. Fixed.
Errors occured on checking an active transaction in ApplyUpdates. Fixed.
Errors in FIBDatabase.QueryValue, if the returned field is BLOB. Fixed.
Changes of a BLOB-field were not saved after the record insertion into
an empty dataset in the context of a separate modifying transaction. Fixed.
An error in the LocateNext method. Fixed.
An error of Boolean-field emulation in design-time. Fixed.
An error when Field Editor did not start if an incorrect SelectSQL was
set in TpFIBDataSet. Fixed.
An error of work with queries "Select for update". Fixed.
An error of handling Cancel after the exception during execution of the
Preview text: What's new in FIBPlus 5.0? Features, enhancements and fixed bugs.