InterBase Data Access Components History

9.3.1 24-Oct-24

Restored support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.6

9.3.0 27-Sep-24

Added support for RAD Studio 12 Athens Release 2
Added support for C++Builder 64-bit Windows (Modern) Application Development
Added support for Lazarus 3.4
Fixed bug with using CutOffParams global variable when a string contains international symbols

9.2.1 01-May-24

Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
Fixed internal bug with TSharedObject

9.2.0 24-Apr-24

Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Fixed bug with incorrect results when using the RETURNING clause
Fixed a bug with an error message about a bad timezone ID

9.1.0 19-Feb-24

Added support for Lazarus 3.0
Added support for Firebird 5
Added support for parallel operations in TIBCBackupService, TIBCRestoreService and TIBCValidationService
Added support for minor ODS upgrade in TIBCValidationService
Added support for multiple rows being returned by DML with the RETURNING clause
Improved compatibility with macOS Sonoma
Fixed bug with setting ReadOnly properties of fields with the same names in a join SQL query
Fixed bug with using CutOffParams global variable when UseUnicode set to True
Fixed bug with using the parameter value size greater than the previous parameter size
Fixed bug with work Date/Time data types parameters

9.0.0 15-Nov-23

Added support for RAD Studio 12
Added support for macOS Sonoma
Added support for Android 13
Added support for iOS 17
Added support for iOS Simulator ARM 64-bit target platform
Added support for EnableMemos property in FastReport components
Added support for nested Macros in SQL queries
Added support Display Format for Aggregate fields
Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
Fixed bug with cutting value for VARCHAR columns with length greater than 255 when LongStrings = False and UseUnicode = True
Fixed bug with installing components for FastReport
Fixed bug with the 'GetDatabaseParameters' assertion when connecting to the server
Fixed bug with loading Unicode strings by TIBCLoader when EnableMemos is True
Fixed bug with memory leaks when using BLOB fields in TIBCLoader
Fixed bug with internal transaction handling when executing the Commit method returns an error
Fixed bug with insert\update ARRAY fields data
Fixed bug with moving the cursor when using Aggregate fields
Fixed bug with deleting a record when using Aggregated fields
Fixed bug with storing empty Aggregates collection in DFM
Fixed bug with AV when installing a package in the IDE
Fixed bug with AV in the CloneCursor method of the dataset
Fixed bug with using Aggregated and InternalCalc fields together
Fixed bug with duplicate resource IDs in CBuilder
Fixed bug with using "NOT Field LIKE" construction in Filter property

8.3.0 17-Mar-23

Added support for RAD Studio 11 Alexandria Release 3
Added support for Lazarus 2.2.6
Added support for Charset and UseUnicode properties in FastReport components
Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
Added support for the mathematical operations in TDADataSet.Filter
Added support for Aggregate Fields and InternalCalc Fields
Added ability to restore from file with TEncoding via the Dump component
Improved work with alias
Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
Fixed bug with "The SQL statement is not allowable for a bulk operation" when using SP in batch operations
Fixed bug with "Validation error" when using the Loader component

8.2.0 12-Sep-22

Added support for RAD Studio 11 Alexandria Release 2
Added support for Lazarus 2.2.2
Added support for iOS 15
Added support for Android 12
Added the CloneCursor method for Query and Table components that allows sharing data between datasets
Added support for working with time zone data types when clients don't have the ICU library
Added support for the isc_dpb_session_time_zone, isc_dpb_set_bind, isc_dpb_decfloat_round, and isc_dpb_decfloat_traps DPB
Added support for EXTENDED TIME/TIMESTAMP WITH TIME ZONE data types
Improved support for TIME/TIMESTAMP WITH TIME ZONE data types
Improved the performance of exporting to XML
Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using "UPDATE OR INSERT" batch operations
Fixed bug with using CAST in the SQL statement when UseUnicode set to True
Fixed bug with reading GUID data of stored procedure in using the AsGuid property
Fixed bug with processing GUID data in using in parameter
Fixed bug with working with the transaction when LockMode <> lmNone
Fixed bug with using the TIBCAlerter component in WebBroker applications
Fixed bug with "Invalid variant type" error when the DMLRefresh property is set to True
Fixed bug with reading BLOBs when the CacheBlobs property set to False and the UseUnicode property set to True
Fixed bug when a connection string parameter value contains a single quote

8.1.1 12-Apr-22

RAD Studio 11 Alexandria Release 1 is supported
Lazarus 2.2.0 is supported
Windows 11 is supported
macOS Monterey is supported
Fixed bug with the growing memory consumption
Fixed bug with loading BLOB columns using the Loader component
Fixed bug with including international characters in SELECT queries when UseUnicode set to True
Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using update batch operations
Fixed bug with an "Invalid class typecast" error when editing Blob in Trial Edition is fixed
Fixed bug with an "Invalid pointer operation" error when using custom constraints
Fixed bug with resetting param values when changing param values count

8.0.2 09-Dec-21

The CutOffParams global variable is added
The PoolId connection pool option is added
The WireCompression option for the Connection component is added
Now, fields of type dtFloat are created for system types INT128, DECFLOAT, and large NUMERIC by default
Fixed bug with value exceeds the range for valid timestamps when using AsDateTime property
Fixed bug with Access Violation when DescribeParams is True and using the AsBytes property
Fixed bug with setting the value of type UInt64 using the Value parameter property
Fixed bug with inserting a Byte value using the Value parameter property
Fixed bug with setting the numeric value of the parameter via AsString for TIBCStoredProc
Fixed bug with insertion of a string and binary values when UseUnicode set to True
Fixed bug with an incorrect encoding of table alias names
Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
Fixed bug with using the AsDate property when working with fields of the ftDate type
Fixed bug with updating the state of records at applying cached updates
Fixed bug with freezing multiply connection pools in threads

8.0.1 13-Sep-21

RAD Studio 11 Alexandria is supported
macOS ARM is supported
Firebird 4 is supported
Added demo project for FastReport FMX
Added the ExplainPlan property that obtains the query execution plan for Table, Query, and SQL components
Fixed bug with executing stored procedures when UseUnicode = True
Fixed bug with setting a DateTime value before the year 1800 to TTimeField
Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
Fixed bug with memoty leak on Locate by field with data type mapping
Fixed bug with escaping wildcards in the Filter property of the DataSet component

7.4.4 14-Jul-21

Support for TFieldOptions is added
Bug with transaction handling when using a stored prodcedure is fixed
Bug with processing VARCHAR fields with a size greater than 255 is fixed
Bug with displaying a connection dialog at design-time in Delphi versions older than 2006 is fixed
Bug with AV failure when using FastReport components is fixed
Bug with applying both Encryption and Data Type Mapping on a BLOB column is fixed
Bug with AV after adding the Lookup field to a prepared DataSet is fixed
Bug with setting a TimeStamp field value as a string is fixed

7.4.3 06-Apr-21

Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed
Bug with loading BLOB columns as strings using the Loader component is fixed

7.4.2 26-Mar-21

Lazarus 2.0.12 is supported
Bug with the ConvertEOL connection option is fixed
Bug with AV in applications using DBMonitor is fixed
Bug with committing a transaction when LockMode = lmPessimistic is fixed
Bug with getting values of calculated fields is fixed

7.4.1 02-Mar-21

RAD Studio 10.4.2 Sydney is supported
macOS 11 Big Sur is supported
iOS 14 is supported
Android 11 is supported
Over-the-Wire (OTW) encryption is supported
Performance of batch operations is improved
Memory consumption in batch operations is reduced
Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
Automatic detection of computed fields when generating update statements is improved
Bug with TIBCAlerter in 64-bit applications is fixed
Bug with the "SQLDA missing or incorrect version" error in FastReport datasets is fixed
Bug with "Unavailable database" when using Local protocol is fixed
Bug in TIBCDump with backing up boolean fields in Firebird 3 is fixed
Bug with incorrect parsing of the Database property value in IBDAC Services components is fixed
Bugs with handling computed fields in editable view are fixed
Bug with setting the ReadOnly field property at runtime is fixed

7.3.2 14-Sep-20

Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed

7.3.1 26-Aug-20

Lazarus 2.0.10 and FPC 3.2.0 are supported
Performance of Batch Insert, Update, and Delete operations is improved

7.2.4 01-Jun-20

RAD Studio 10.4 Sydney is supported
Lazarus 2.0.8 is supported
macOS 64-bit in Lazarus is supported
Bug with an incorrect value in the DBSQLDialect property is fixed
Bug with using a case-sensitive Role name is fixed
Bug with locating a record by a fixed string column in the Chinese locale is fixed
Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed

7.1.3 10-Mar-20

Bug with installing different editions of two or more DAC's in a single system is fixed
Bug with assertion failure when changing BLOB fields with the CacheBlobs property set to False is fixed
Bug with using ftFMTBCD datatype params in batch operations is fixed
Bug with the incorrect default value of the TField.Required property for columns of type DOUBLE PRECISION is fixed
Bug with loading Memo fields in TIBCLoader is fixed
Bug with SQL statements that contain fields with the same name from different tables is fixed
Bug with executing SQL statements that contain comments using the Script component is fixed
Bug with resetting the value of the parameter after adding a new TDACondition is fixed
Bug with reading a field value using the AsBytes method in Lazarus is fixed
Bug with using constraints after calling the Refresh method is fixed

7.1.2 26-Nov-19

Android 64-bit is supported
Lazarus 2.0.6 is supported
Interbase 2020 is supported
Now Trial edition for macOS and Linux is fully functional
Improved peformance when using pooling
Handling of BLOB fields in batch operations is improved
Bug with using the array data type in a table with quoted name is fixed
Bug with executing the CREATE DATABASE statement when Pooling is enabled is fixed
Bug with the IBCLoader component when BooleanDomainFields set to True for source dataset is fixed
Bug with the "segment buffer length shorter than expected" error is fixed
Bug with AV failure when using encryption is fixed
Bug with using the FieldOrigins property is fixed
Bug with the Loader component when UniDirectional set to True for source dataset is fixed
Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
Bug with mapping to BCD fields when TClientDataSet is used is fixed
Bug with resetting the range values when executing the Refresh method is fixed
Several bugs that occurred when using DataSet Manager are fixed

7.0.1 22-Jul-19

macOS 64-bit is supported
Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
Bug with using the AsMemo method in batch operations is fixed

6.4.12 24-Jun-19

Lazarus 2.0.2 is supported
Local connection is supported
The URL-style connection string format is supported
The TIBCConnectionOptions.IPVersion property is added
The TCustomIBCService.IPVersion property is added
Improved performance when inserting data into a table having BLOB fields using Loader component
The DefaultSortType property for TVirtualTable is added
Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
Bug with QueryRecCount when using GROUP BY clause is fixed
Bug with changing BLOB fields when the CacheBlobs property set to False is fixed
Bug with the AV failure when executing the Refresh method is fixed
Bug with calculating percentage in the OnRestoreProgress event in the TDADump class is fixed
Bug with the StackOverflow exception when using batch operations in CBuilder is fixed
Bug with using the SetRange method is fixed

6.3.11 21-Jan-19

Bug with using the AsBytes property is fixed
Bug with the AV failure when using the BLOB data type in Lazarus is fixed
Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed

6.3.10 26-Nov-18

RAD Studio 10.3 Rio is supported
Possibility to write large blobs by pieces is added
Support of UPPER and LOWER functions for Unified SQL is added
The boSkipData option for the BackupService component is added
The roSkipData option for the RestoreService component is added
TIBCQuery.OnGetBlobData event is added
Bug with using the FieldOrigins property is fixed
Bug with using the TrimFixedChar property is fixed
Bug with saving a dataset that contains BLOB fields to XML is fixed

6.2.9 17-Sep-18

Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
Now the SetRange method supports Null values
The enumerated property FieldOrigins is added
The Boolean property FieldsOrigin is deprecated
Bug with AV when using custom constraints is fixed
Bug with assertion failure when using BLOB data type in batch operations is fixed

6.2.8 09-Jul-18

Lazarus 1.8.4 is supported
Support for System Encryption Password (SEP) is added
Possibility to grant/revoke admin role for a Firebird user with the help of the IBCSecurityService component is added
Performance of batch operations is improved
Demo projects for IntraWeb 14 are added
Now the "Data type is not supported" exception is not raised by the Query component when the DescribeParams property is set to True
Memory leak in NEXTGEN is fixed
Bug with updating a record when using the OnFilterRecord event handler is fixed
Bug with using encryption and CacheCalcFields option is fixed
Bug with using a backslash in the Filter property is fixed
Bug with using First method in the Master-Detail relationship is fixed
Bug with loading GUID values using the Loader component is fixed
Bug with loading VARCHAR values using the Loader component is fixed
Bug with the BreakExec method is fixed
Bug with the "Stream read error" error is fixed
Bug with the "Incomplete multibyte char" error for non-Windows platforms is fixed

6.1.7 10-Apr-18

Bug with the "Attempt to reopen open cursor" error when trying to execute the Refresh method is fixed

6.1.6 02-Apr-18

Lazarus 1.8.2 is supported
Now Detail dataset is not refreshed when Master dataset editing is started
Bug with executing batch operations with iteration = 1 and offset = 0 is fixed
Bug with re-opening a filtered dataset is fixed
Bug with data decryption in SmartFetch mode is fixed
Bug with data truncation while decrypting is fixed
Bug with a query plan containing national characters is fixed
Bug with the "SQL information exception" error when trying to execute the COMMIT or ROLLBACK statement is fixed

6.1.5 18-Jan-18

Lazarus 1.8 and FPC 3.0.4 are supported
Support for custom constraints is added
The UseBlankValues property for the Loader component is added
Loading of the default client library for 64-bit applications is improved
Bug with memory leak when using BLOB data type in batch operations is fixed
Bug with resetting a previously set parameter value when using DescribeParams is fixed
Bug with backup/restore a database containing national characters in a database path in Firebird 3 is fixed
Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
Bug with assertion failure when using the OnFilterRecord event handler is fixed
Bug with script parsing in TDAScript is fixed
Bug with AutoInc fields in TVirtualTable is fixed
Bug with AV in TVirtualDataSet when editing Blob is fixed

6.1.4 29-Sep-17

Bug with the "Input parameter mismatch" error for procedure is fixed
Bug with transactions when working with Firebird 2.5 is fixed

6.1.3 19-Sep-17

Support for Firebird on Android platform is added
Support for Firebird 3 packages is added
Aliases handling in the RETURNING clause is supported
The WireCompression connection parameter for Firebird 3 is supported
Bug with using BLOB data type in batch operations is fixed
Bug with using batch parameters of the Bytes type is fixed
Bug with closing a connection that has an active transaction for Firebird 3 is fixed
Bug with recreating a connection on Linux and mobile platforms is fixed
Bug with generating SQL for batch updates is fixed
Bug with the Locate method for non-Windows platforms in Lazarus is fixed
Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed
Bug with accessing a product help from the IDE menu is fixed
Bug with recreating fields when calling Open after Prepare is fixed
Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed
Bug with AV failure when using calculated fields in TClientDataset is fixed
Bug with a key violation error when executing batch operations is fixed
Bug with Assert when calling the Locate method in the SmartFetch mode is fixed
Bug with using DAC components in DataModule for Linux is fixed

6.0.2 15-May-17

Support for using ROLE when connecting to FB service is added
Bug with memory leak when using the SQLMonitor component is fixed
Bug with processing NULL values in the Loader component is fixed
Bug with executing a query after executing a batch command is fixed
Bug with using the AsGuid property is fixed

6.0.1 05-Apr-17

RAD Studio 10.2 Tokyo is supported
Linux in RAD Studio 10.2 Tokyo is supported
Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
Possibility to manage batch operations using a transaction is added
Possibility to obtain active transaction number using DBMonitor is added
Bug with handling the "Database shutdown" error is fixed
Bug with showing values array for batch updates in IBCSQLMonitor is fixed
Bug with handling parameters of the Currency type is fixed
Bug with AV when the number of values of a batch parameter is too large is fixed
Bug with using batch parameters of Bytes type is fixed
Bug with setting parameters of a custom transaction in Lazarus is fixed
Bug with reading BLOBs when the CacheBlobs property is set to False is fixed
Bug with using several IBCAlerter components simultaneously is fixed
Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
Bug with detecting parameters by name in ExecSQLEx is fixed
Bug with reading Memo as WideMemo is fixed
Bug with field name quoting in a filter expression is fixed
Bug with handling parameter values of BLOB type in batch operations is fixed
Bug with memory leak in TVirtualDataSet is fixed

5.7.27 21-Nov-16

Bug with adding Calculated fields after calling Prepare is fixed
Bug with stored procedure parameters is fixed
Bug with setting query parameters as a string is fixed

5.7.26 01-Nov-16

Support for international characters in a role name is added
Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
Bug with international characters in a database path name in Interbase is fixed
Bug with missing error when an invalid KeyGenerator value is specified is fixed
Bug with handling the "Connection shutdown" error is fixed
Bug with setting query parameters as a string is fixed
Bug with an error message encoding in the RestoreService component is fixed

5.7.25 08-Sep-16

TDADataSetOptions.InsertAllSetFields property is added
Several bugs in SmartFetch Mode are fixed
Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
Bug with param values loss after changing TDAParam.ValueCount is fixed
Bug with PtrOffset function when Overflow Checking option enabled is fixed
Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
Bug with the duplicated MacroChar variable is fixed
Bug with executing an INSERT OR UPDATE batch operation is fixed

5.7.24 27-Jun-16

TVirtualDataSet component is added
The Timeout property for the TraceService component is added
OnConnectionLost event of the Connection component is improved
Bug with assertion failure on editing data in SmartFetch mode is fixed
Bug with AV on application closing when DLLs are used in the Trial edition is fixed
Bug with using parameters and column aliases in Master-Detail relation is fixed
Bug with re-assigning a value to a stored procedure parameter as a string is fixed
Bug with backup/restore a database containing national characters in its name in Firebird 3 is fixed
Bug with executing an application on iOS Simulator is fixed

5.7.23 28-Apr-16

Bug with AV failure when connection is not specified is fixed
Bug with batch operations is fixed

5.7.22 25-Apr-16

RAD Studio 10.1 Berlin is supported
Lazarus 1.6 and FPC 3.0.0 is supported
Support for the BETWEEN statement in TDADataSet.Filter is added
Bug with handling international characters in the VirtualTable component is fixed
Bug with displaying data in grid on error at applying cached updates is fixed
Bug in the SetOrderBy method in case when SQL contains ';' is fixed
Bug with using the LIKE clause in a dataset filter is fixed
Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
Bug with BLOB data loss after editing a record when DeferredBlobRead=True is fixed
Bug with AV on closing application when Pooling=True is fixed
Bug with memory leak on query execution is fixed
Bug with receiving messages in the Alerter component after Stop/Start is fixed
Bug with generating of UpdateSQL on using WITH clause is fixed

5.6.21 01-Feb-16

Data Type Mapping performance is improved
Bug with AV on setting TIBCAlerter.Active to True is fixed
Bug with executing a SET GENERATOR statement in Firebird 3 is fixed
Bug with possible application hanging on client library exception is fixed

5.6.20 14-Dec-15

Performance of TDALoader on loading data from TDataSet is improved
Several bugs in the SmartFetch mode are fixed
Bug with processing the cached data in the ApplyUpdates method is fixed
Bug with RecNo in the Unidirectional mode is fixed
Bug with storing some numbers with floating point is fixed
Bug with using output parameters in stored procedures is fixed
Bug with executing batch operation on x64 platform is fixed
Bug with a memory leak when accessing some of TIBCConnection.DatabaseInfo properties is fixed
Bug with executing TIBCConnection.ExecSQL with string parameters is fixed
Bug with international characters in a database path in Firebird is fixed

5.6.19 18-Sep-15

Bug with executing batch update or delete after batch insert is fixed
Bug with showing values array for batch updates in SQLMonitor is fixed
Bug with editing Blob and Memo fields used in local filter is fixed

5.6.18 09-Sep-15

RAD Studio 10 Seattle is supported
INSERT, UPDATE and DELETE batch operations are supported
Now Trial for Win64 is a fully functional Professional Edition
Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
SQLMonitor behavior on using similar objects is fixed
Bug with endless reconnection in assigned connection is fixed
Bug with editing Blob and Memo fields used in local filter is fixed
Bug when working with databases having charset NONE is fixed

5.5.17 14-Jul-15

Critical bug with data encryption is fixed
Bug in IProviderSupport.PSExecuteStatement with parsing a SQL query is fixed
Bug with missing IdeVer.inc in Trial version is fixed
Bug with updating a dataset when DescribeParams = True is fixed

5.5.16 30-Jun-15

Bug when parsing SQL query with parameters is fixed
Bug with the Refresh method in the SmartFetch mode is fixed
Bug with handling BOOLEAN parameters in Firebird 3 is fixed

5.5.15 17-Jun-15

AddCharsetRule methods are added in Data Type Mapping of Connection and DataSet components
Bug with KeyGenerator behavior when CachedUpdates = True is fixed
Bug with incorrect RowsUpdated value when executing an EXECUTE BLOCK statement is fixed
Bug with AV on unloading fbembed.dll is fixed
Bug with BooleanDomainFields=True when working with Firebird 3 is fixed
Bug with using bookmarks in a filtered dataset is fixed
Bug with restoring the original order of records after clearing IndexFieldNames is fixed
Bug with refreshing DbLookupComboBox of the detail dataset when Master-Detail relationship is used is fixed
Bug with SQL Monitor freezing when using in a DLL is fixed

5.5.14 14-Apr-15

RAD Studio XE8 is supported
AppMethod is supported
Firebird 3 is supported
Firebird 3 BOOLEAN column type is supported
The roMetadataOnly option in the RestoreService component is added
Bug with invalid names of Master-Detail parameters is fixed
Bug with AV on calling GetVersion() in C++Builder is fixed
Bug with using Firebird Embedded within a DLL is fixed
Bug with BLOB field types when using InterBase XE and higher is fixed
Bug with obtaining a generator value for a newly inserted record is fixed
Bug with inserting a record when the key field is not the first one in a query is fixed
Bug with AV when creating a connection in a thread is fixed

5.4.13 14-Jan-15

Lazarus 1.2.6 is supported
Bug with losing data after VirtualTable closing on SaveToStream is fixed
Bug with RestoreUpdates in CachedUpdates mode is fixed
Bug with KeyGenerator behaviour when CachedUpdates = True is fixed
Bug with mapping SMALLINT database columns to float fields is fixed

5.4.12 25-Nov-14

The QueryRowsAffected dataset option is added for increasing performance of update operations
Bug when using table aliases in the DetailFields name is fixed
Bug with using UPPER and LOWER functions in filter is fixed
Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
Bug with TCustomDADataSet.FindKey is fixed
Bug with editing DateTime fields when data type mapping from string to DateTime is used is fixed
Bug with 'Thread Error' when connecting on OS X is fixed
Bug with refreshing record if the key field has the TSQLTimeStamp data type is fixed
Bug with DLL unloading is fixed

5.4.11 29-Sep-14

ConnectionTimeout is now used on OSX and Mobile platforms
Translation of the DataSource property of the FIBPlus dataset into the MasterSource property in MigrationWizard is added
Bug with RecNo in the UniDirectional mode is fixed
Bug with setting SQL query when ParamCheck = False is fixed
Bug with AV failure on getting metadata by TCustomDADataSet is fixed
Bug with AV failure under Mobile when DacFMX is used is fixed

5.4.10 15-Sep-14

RAD Studio XE7 is supported
Lazarus 1.2.4 is supported
Demo projects for FastReport 5 are added
The TCustomDADataSet.GetKeyFieldNames method is added
The TCustomDAConnection.GetKeyFieldNames method is added
The ConstraintColumns metadata kind for the TDAMetadata component is added
Several bugs in the SmartFetch mode are fixed
Bug with quoting names in the EmptyTable method is fixed
Bug with calling the Refresh method after executing the EmptyTable method is fixed
Bug with setting calculated field values using the AsExtened property is fixed
Bug with re-calling the AfterExecute event is fixed
Bug with re-calling the BeforeExecute event is fixed
Bug with possible AV after TParam.Clear when the parameter has the type of ftBytes is fixed
Bug with updating a record when Disconnected = True and DeferredBlobRead = True is fixed
Bug with SQL generating in the Query Editor is fixed

5.3.9 31-Jul-14

Support for the Upper and Lower statements in TDADataSet.Filter is added
Support for the ftOraTimeStamp type in TVirtualTable is added
The NoDBTriggers option for the Connection component is added
The roFixFssData and roFixFssMetadata options for the RestoreService component are added
Bug with reopening TDADataSet after BreakExec is fixed
Several bugs in the SmartFetch mode are fixed
Bug with processing calculated and lookup fields in the SmartFetch mode is fixed
Bug with getting RecordCount when QueryRecordCount is True is fixed
Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
Bug with "Invalid field size" in TVirtualTable is fixed
Bug with AV failure on freeing objects on mobile platforms is fixed
Bug with parameters handling in the Query component is fixed
Bug with starting/stopping an alerter when executing a query is fixed
Bug with handling params of type ftFmtMemo is fixed
Bug with a query execution when AutoPrepare = True is fixed

5.3.8 27-May-14

Bug with compilation in C++Builder is fixed
Bug with setting boolean parameters in a non-English IDE at design-time is fixed
Bug with AV failure on fetching records in the UniDirectional mode is fixed
Bug with finding master parameters by original name on refreshing record when using master/detail relationship by parameters is fixed
Bug with incorrect table alias names detection is fixed

5.3.7 29-Apr-14

RAD Studio XE6 is supported
Android in C++Builder XE6 is supported
Lazarus 1.2.2 and FPC 2.6.4 is supported
SmartFetch mode for TDataSet descendants is added
Now update queries inside TDataSet descendants have correct owner
The TIBCDataSetOptions.MasterFieldsNullable property is added
The SetOrderBy method behavior is fixed
The GetOrderBy method behavior is fixed
Bug with displaying already installed DAC version in setup messages is fixed
Bug with the Filter behavior in the Metadata component is fixed
Bug with AV on modify table with one only Object field is fixed
Bug with Locate when a NULL value is present in the index field is fixed
Bug with IndexFieldNames when DataTypeMapping is enabled is fixed
TIBCTransaction.OnCommitRetainig and TIBCTransaction.OnRollbackRetainig events are added
Bug with carriage returned in the beginning of an error message is fixed
Bug with the Dump component when UseUnicode = True is fixed
Bug with AV when setting TIBCQuery.KeyGenerator = '' is fixed
Bug with installing IBDAC from sources is fixed
Bug with invalid client library when using connection pooling is fixed
Bug with refreshing a detail dataset in Master-Detail is fixed

5.2.6 19-Feb-14

Possibility to use MAS_ prefix for parameters when using master/detail relationship is added
Bug with post data when LockMode=lmOptimistic and Data Type Mapping is applied is fixed
Bug with opening dataset when persistent fields were created in dataset is fixed
Bug with parameter name quoting on assigning field value to parameter is fixed
Bug with deleting a record inserted earlier in CachedUpdates mode is fixed
Bug on sorting BLOB fields is fixed
Bug with percentage count in the OnRestoreProgress event of the TDADump class is fixed
Bug with generating SQL queries by "SQL Generator" in design-time is fixed
Bug with using '$' and '#' symbols in a parameter name is fixed

5.2.5 25-Dec-13

iOS in C++Builder XE5 is supported
RAD Studio XE5 Update 2 is now required
Now .obj and .o files are supplied for C++Builder
Performance is improved
Compatibility of migrating floating-point fields from other components is improved
Bug with data loss when updating records in the CachedUpdates mode is fixed
Bug with RefreshRecord in the CachedUpdates mode is fixed
Bug with mapping to BCD and FmtBCD types is fixed
Bug with mapping single types to float types is fixed
Bug with data display in Detail Dataset when master field is Null is fixed
Bug with mapping to BCD fields when using TClientDataSet is fixed
Bug with incorrect parameter sizes when re-opening a query is fixed
Bug with filtering boolean fields is fixed
Bug with freeing complex fields after refreshing before editing is fixed
Bug with Locate by fields where Data Type Mapping is applied is fixed
Bug with RefreshQuick when IndexFieldNames is set is fixed
Now RowsAffected returns a correct value without the need to prepare a statement explicitly
String truncation when using the Loader component is fixed
Bug with handling Firebird users using TIBCSecurityService is fixed
Bug with the TIBCLoader.LoadFromDataset method is fixed
Bug when working with parameters of the ftTimeStamp type is fixed

5.1.4 23-Sep-13

Critical bug with parsing unicode SQL queries is fixed

5.1.3 18-Sep-13

RAD Studio XE5 is supported
Application development for Android is supported
Lazarus 1.0.12 is supported
Performance is improved
Automatic checking for new versions is added
Flexible management of conditions in the WHERE clause is added
Support of the IN keyword in the TDataSet.Filter property is added
Like operator behaviour when used in the Filter property is now similar to TClientDataSet
The possibility to use ranges is added
The Ping method for the Connection component is added
The AllowImplicitConnect option for the Connection component is added
The SQLRecCount property for the Query and StoredProc components is added
The ScanParams property for the Script component is added
The RowsAffected property for the Script component is added
Trusted authentication mode for Firebird is supported
Migration from FIBPlus is added
Now the TIBCTransaction.Params property values can be separated by a semicolon
The ForceUsingDefaultPort global variable is added
TIBCLoader.LoadFromDataSet is optimized for cases when a dataset record count is less than the RowsPerBatch value
Bug in TDALoader with data loading from Dataset when the FetchAll option is set to False is fixed
Bug with TDALoader.LoadFromDataSet is fixed
Bug with storing the dbMonitor active state to DFM is fixed
Bug with setting ConnectionTimeout for Unix, Mac OS and iOS platforms is fixed
Bug with incorrect displaying of long names of parameters and macros in design-time is fixed
Bug with processing cached data when UpdateRecordTypes is not default is fixed
Bug with moving data from WideMemo to String fields by TCRBatchMove is fixed
Bug in TCRBatchMove when destination dataset has no key fields is fixed
Bug with TCRBatchMove and DataSets in the UniDirectional mode is fixed
Bug with showing a connection dialog in design-time when LoginPrompt is set to False is fixed
Bug with setting the connection string containing inline comments is fixed
Bug with unnecessary unlock calling after an update error is fixed
Bug with setting the TBlobField.AsString value when CacheBlobs = False is fixed

5.0.2 15-Jul-13

Connection dialog is improved
Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
Bug with setting the default transaction isolation level after opening a connection is fixed
Bug with accessing params with a AsSingle method is fixed
Bug with getting metadata when using Firebird 1.5 is fixed
Bug with cutting strings when getting metadata from system tables in the Unicode mode for InterBase 2007 is fixed
Bug with a "Dynamic SQL error" when querying record count is fixed
Bug in the alerter when DisconnectedMode is set to True for a connection is fixed
Bug with the connection OnLogin event is fixed
Bug with incorrect counting of connections in pool is fixed
Bug with time fields in Lazarus is fixed
Bug with varbinary fields in Lazarus is fixed
Bug with using case-insensitive filter is fixed
Bug with getting and setting the SQL property of FastReport datasets is fixed
Bug with positioning of Fields Editor is fixed
Bug with not using index fields on locating records is fixed
Bug with processing the cached data when UpdateRecordTypes is not default is fixed
Bug with processing persistent fields in TVirtualTable is fixed

5.0.1 25-Apr-13

Rad Studio XE4 is supported
NEXTGEN compiler is supported
Connection string support is added
Possibility to encrypt entire tables and datasets is added
Possibility to determine if data in a field is encrypted is added
Support of TimeStamp, Single and Extended fields in VirtualTable is added
Application development for iOS using InterBase XE3 ToGo Edition is supported
Additional database shutdown options for TIBCConfigService.ShutdownDatabase are added
Bug with Master-Detail for TClientDataSet in Rad Studio XE3 is fixed
Bug with Master-Detail by non-English fields is fixed
Bug with IndexFieldNames by non-English fields is fixed
Bug with incorrect RecordCount result when a query contains both ORDER BY and LIMIT is fixed
Bug with calling Cancel in the BeforePost event is fixed
Bug when setting the TDataSet.Filter property for empty dataset is fixed
Bug with incorrect TVirtualTable version displaying in the About box is fixed
Thread handle leak when using pooling is fixed
Bug with restoring incremental backups is fixed
Bug with opening large amounts of data in TClientDataSet using IBDAC is fixed
Now the TCustomDASQLMonitor.Options.moDBMonitor property is set to False by default

4.6.12 14-Feb-13

Rad Studio XE3 Update 2 is now required
Bug with AV on adding TFieldDef items to FieldDefs for Delphi 2009 and higher is fixed
Bug with incorrect detection of the numeric parameter type in ExecSQL is fixed
Bug with assigning data to blob fields when using Data Type Mapping is fixed
Bug with inserting a new record into TStringGrid in FMX is fixed
Bug with unlocking a record after constraint violation is fixed
Bug with quoting index field names in TCRDBGrid is fixed
Bug with Master-Detail link by fields with non-English names is fixed
'Range check error' when using TIBCAlerter is fixed
Bug with using unsigned integer values in parameters is fixed
Bug with connecting to InterBase 7 and lower is fixed
Bug with assertion failure on filling default field values is fixed

4.6.11 12-Dec-12

Rad Studio XE3 Update 1 is now required
C++Builder 64-bit for Windows is supported
TIBCConnection.Port property that allows specifying the port number or the service name for connection is added
Bug with using quoted field names in the IndexFieldNames property is fixed
Bug in TIBCStoredProc with closing dataset when the Disconnected property is True is fixed
Bug with processing macros named in Cyrillic is fixed
Bug with accessing dataset parameters with AsByte and AsWord methods is fixed
Bug with datetime field default values is fixed
Bug with field default values when using field aliases is fixed
Bug with BLOB fields when UseUnicode = True is fixed

4.5.10 07-Nov-12

Some improvements for NEXTGEN support are added
Support for ftGraphic and ftFmtMemo parameter data types is added
Informativity of messages about errors in connection is improved
Dependency of design-time packages on FMX packages is removed
Bug with data loss in pessimistic lock mode is fixed
Bug with AV failure in RefreshQuick method is fixed
Bug with renaming of fields with the same names is fixed
Bug with dependency parameters count in macros on delimeter is fixed
Bug with storing the LoginPrompt connection property is fixed
Bug with dump data from VIEW is fixed
Bug with creating columns on setting the TableName property in TDALoader is fixed
Bug with setting a client library name in the connection editor is fixed
Bug with an irregular AV in the TIBCAlerter component is fixed
Bug with sharing the same connection between an application and a DLL is fixed

4.5.9 04-Sep-12

Rad Studio XE3 is supported
Windows 8 is supported
Bug with storing empty MapRules collection in DFM is fixed
Bug with reading BLOB data when using Firebird x64 is fixed
For TIBCConfigService methods the used DB - Interbase/Firebird - is determined correctly, and correct "The function is not supported ..." messages are displayed

4.2.8 24-Jul-12

Bug with Data Type Mapping and persistent fields is fixed
Bug with Data Type Mapping to Bytes and VarBytes is fixed
Bug with decryption of binary fields is fixed
Bug with editing calculated fields is fixed
Connection dialog is now open in the screen center instead of the desktop center
Several bugs with compilation on Delphi XE2 from Source code are fixed
Bug with setting a value with the TIBCParam.AsShortInt method is fixed
Bug with an incorrect IBDAC version displaying on the connection editor form for InterBase Services components is fixed

4.2.7 21-Jun-12

Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Data Type Mapping support is added
Data encryption in a client application is added
The TIBCEncryptor component for data encryption is added
Calling of the TCustomDASQL.BeforeExecute event is added
Bug with executing a script that ends with a commented line is fixed
Bug with assigning outsize data to TWideStringField is fixed
Bug with AV failure at calling the SetRecNo method when using local sorting is fixed
Bug in design time editor of the TVirtualTable component with master-detail relationship is fixed
Now the TIBCDataSetOptions.PrepareUpdateSQL property is set to False by default for performance improving
Bug with cutting a string when getting data from system tables in Unicode mode is fixed
Bug with calling CommitRetaining instead of Commit after posting record when LockMode = lmPessimistic is fixed
Bug with the automatic preparing of TIBCTable parameters in design time is fixed
Bug with TIBCBackupService when the compiler "Optimization" option is set to "true" in Delphi 5 and 6 is fixed
Bug with accessing InterBase 64-bit from a x64 application built in Delphi XE2 is fixed

4.1.6 02-Apr-12

Lazarus 0.9.30.4 and FPC 2.6.0 are supported
Bug with SQL Generator in the design-time is fixed
Bug with generating Update SQL with fields that have aliases is fixed
Bug with saving BCD fields from TVirtualTable to a Stream is fixed
Bug with LocalMasterDetail is fixed

4.1.5 01-Mar-12

Update 4 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Bug with AV failure at executing ApplyUpdates is fixed
Bug with hanging RAD Studio XE2 when opening ConnectDialog is fixed
Several bugs in design-time editors are fixed
Bug with cutting a string when getting metadata from system tables in Unicode mode is fixed
Bug with detecting precision of BCD fields is fixed
Bug with AV failure at opening a dataset is fixed

4.1.4 28-Dec-11

The UniqueFieldIndexSeparator global variable is added
Bug with assertion failure at proccesing the cached data is fixed
Bug with Delphi IDE hanging at closing in case of using DBMonitor is fixed
Bug with freeing memory in Lazarus is fixed
Bug with executing the queries with parameters in Delphi 5 is fixed
Several bugs with 64-bit application development are fixed
Several bugs in design-time editors are fixed
Bug with query containing 'UNION' clause that is generated for the QueryRecCount option is fixed

4.1.3 23-Nov-11

Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Mac OS X in RAD Studio XE2 is supported
FireMonkey support is improved
Lazarus 0.9.30.2 and FPC 2.4.4 are supported
Mac OS X in Lazarus is supported
Linux x64 in Lazarus is supported
FreeBSD in Lazarus is supported
Bug with query containing 'WITH' clause that is generated for the QueryRecCount option is fixed
Bug with AV failure on freeing TIBCQuery is fixed
Bug with memory leak in TDALoader is fixed
Problem with receiving DateTime parameter for DBMonitor in Delphi 2009 and higher is fixed

4.0.2 10-Oct-11

Bug with compilation for Linux in Lazarus is fixed
Bug with processing parameters values of which are of the SqlTimestamp type is fixed
Bug with the QueryRecCount option queries containing ';' delimiter in query is fixed

4.0.1 15-Sep-11

Embarcadero RAD Studio XE2 is supported
Application development for 64-bit Windows is supported
FireMonkey application development platform is supported
Support of master/detail relationship for TVirtualTable is added
OnProgress event in TVirtualTable is added
TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string is added
TIBCDataSetOptions.SetDomainNames property to enable setting TIBCFieldDesc.DomainName for fields is added
TIBCLoader.RowsPerBatch property to specify the number of INSERT queries to load in a single batch is added
Bug with AV failure on fetching BLOB fields is fixed

3.60.0.24 19-Jul-11

Bug with assertion failure on using master/detail relationship with TClientDataset is fixed
Bug in TCustomDADataSet.PSGetKeyFields method when in dataset persistent fields was created is fixed
Bug with showing Unicode symbols in error message is fixed
Bug with processing calculated fields is fixed
Bug with calculating fields size for Unicode and Utf8 fields is fixed
Bug with memory leak on assign BLOB fields when UseUnicode is True is fixed

3.60.0.23 15-Jun-11

TIBCDataSetOptions.PrepareUpdateSQL property for preparing update queries automatically before execution is added
Possibility to load data in TVirtualTable without recreating persistent fields is added
Working in design time editor of the TVirtualTable component is improved
Loading files opened by other applications is improved
Bug with processing key fields on record posting is fixed
Several bugs with design-time editors for Lazarus are fixed
Bug with getting server version for InterBase 10.0 and higher is fixed
Bug with processing transactions on application closing is fixed

3.60.0.22 28-Apr-11

Lazarus 0.9.30 and FPC 2.4.2 is supported
TIBCLoader.InsertMode property to allow using "UPDATE OR INSERT INTO" syntax for loading data is added
Possibility to assign Handle to TIBCConnection is added
Bug in bookmark validity check is fixed
Bug with getting fields of primary key is fixed
Bug with processing Unicode in BLOB parameters is fixed
Bug with Source Edition installation is fixed

3.50.0.21 10-Mar-11

Delphi & C++Builder XE Starter Edition supported
Fixed registration procedure of Borland SQL Monitor when TIBCSQLMonitor is created at runtime
Fixed bug in TIBCScript with parsing script
Fixed bug with getting database info for 64-bit OS

3.50.0.20 26-Jan-11

Fixed bug with processing transaction when error arises in the Open method
Fixed bug with AV failure on processing string fields when UseUnicode is True and Charset is set to 'UTF8'
Fixed bug with AV failure on processing BLOB parameters

3.50.0.19 08-Dec-10

Added calling the BeforeExecute event for the Open and Refresh dataset operations
Added TGDSDatabaseInfo.IsEncrypted and TGDSDatabaseInfo.IsEUAActive properties
Changed behaviour when TCustomIBCDataSet.GeneratorMode = gmPost: now value from generator is not used if user inputs any value into key field
Now the UTF8 charset is used instead of UNICODE_FSS, when TIBCConnectionOptions.UseUnicode is True and Charset is set to 'UTF8'
Avoided bug of Firebird client library with freezing when fatal error is raised in TIBCAlerter
Fixed bug in the Refresh method when connection is lost
Fixed bug with refreshing record for Master-Detail datasets
Fixed bug with creating updating tables list for nested queries

3.50.0.18 04-Nov-10

Added checking that dataset is open on calling the TDataSet.Locate method
Added the ClientLibrary property to the TfrxIBDACDatabase class
Fixed bug with decoding data on loading XML
Fixed bug in Migration Wizard with adding unnecessary spaces
Fixed bug with TIBCRestoreService
Fixed bug with processing RETURNING keyword for InterBase
Fixed bug with calling the TIBCTransaction.OnError event
Fixed bug with AV failure in TIBCAlerter
Fixed bug with assigning parameters values to TfrxIBDACDatabase

3.50.0.17 13-Sep-10

Embarcadero RAD Studio XE suppored
Fixed bug with the LIKE keyword in the TDataSet.Filter property
Fixed bug with filling default expression for fields in the design mode for inactive dataset
Fixed bug in TIBCAlerter

3.10.0.16 13-Aug-10

Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
Added the OnBeforeExecute event
Fixed bug in Migration Wizard with converting units in the UTF8 and UTF16 encoding
Fixed bug with RefreshRecord and numbers with floating point
Fixed bug in Migration Wizard with converting TIBScript to TIBCScript

3.10.0.15 24-Jun-10

Added ability to lock records in the CachedUpdate mode
Added overloaded declaration of the ApplyUpdates method to choose update kind
Fixed bug with quote that first character inside quoted string for the Filter property
Fixed bug in TCRBatchMove with processing RecordCount
Fixed bug in TIBCLoader for Delphi 2010 with loading blob fields
Fixed bug in TIBCScript with parsing script

3.10.0.14 26-May-10

Fixed bug with keeping of field default value
Fixed bug with using stored procedure in SELECT statement
Fixed bug with treating integer fields as TBooleanField when the domain name contains "BOOLEAN"
Fixed bug with AV failure in TIBCAlerter

3.10.0.13 09-Apr-10

Fixed bug with comparing Date field values on optimistic locking
Fixed bug in the AddWhere, DeleteWhere, SetOrderBy, and GetOrderBy methods for Tables
Fixed bug with calculating RecNo in CachedUpdates mode
Fixed bug with getting Database Info
Fixed bug with "Insert into Table () values ()" when all fields are empty
Fixed bug with processing fields that have the Array of Decimal type with scale <> 0
Fixed bug with processing TIBCTable.OrderFields that contains keywords
Fixed bug with updating array fields when dbMonitor is used

3.10.0.12 04-Mar-10

Added ability to send call stack information to dbMonitor component
Fixed bug with refreshing record when using master/detail relationship
Fixed bug with LocalUpdate in the CachedUpdates mode
Fixed bug with DBMonitor for C++ Builder 6
Fixed bug with inserting/editing string fields when UseUnicode is True
Fixed bug with reading blobs when DeferredBlobRead and UseUnicode is True
Fixed bug with prcessing the SET TERM statement in TIBCScript
Fixed bug with the SizeInBytes parameter in TIBCBackupServices

3.10.0.11 26-Jan-10

Added OnStart, OnCommit, OnRollback events to TDATransaction
Added SQLTypeEx property
Problem with using TLargeintField in master/detail fixed
Bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmPessimistic fixed
Bug with writing large Unicode BLOBs fixed
Bug with Unicode BLOBs and DeferredBlobRead fixed
Bug with setting SQLDialect on CreateDatabase fixed
Memory overrun leak with ftString output parameters fixed

3.10.0.10 01-Dec-09

Added support for dbMonitor 3
Bug with updating table, that has field name, representing a valid hexadecimal number, fixed
Bug with updating field value with preceding spaces when TrimFixedChar or TrimVarChar = True fixed
Bug with executing large file in UTF-8 format fixed
Bug with ExecuteNext and BLOB parameters fixed

3.10.0.9 12-Nov-09

Added support for Trace and nBackup services of Firebird 2.5
Now setting the SetFieldsReadOnly option to False makes all fields not read-only (default changed to True)
Now Required flag is set for UpdatingTable fields only
Bug with detecting parameter size for MBCS strings fixed
Problem with detecting slash with text after it as a delimiter in TDAScript fixed
Bug with SetOrderBy and SetWhere when there is no space before ORDER or WHERE fixed
Bug with executing large file in Unicode format fixed
Access violation in TIBCAlerter when registering more than 15 events fixed

3.10.0.8 13-Oct-09

Added support for BATCH START and BATCH EXECUTE commands in TIBCScript
Now the AssignConnect method copies transaction state
Memory leak on reading array fields fixed
Bug with locating records using the LocateEx method and the lxNearest option fixed
Bug with AV failure in MemData fixed
Bug with SQL Generator in design-time fixed
Problem with help registration under RAD Studio 2010 fixed
Problem with loading DataSet Manager under RAD Studio 2010 fixed

3.10.0.7 10-Sep-09

Embarcadero RAD Studio 2010 suppored
Now the subdetail is refreshed before the AfterRefresh event of the detail is called

3.00.0.6 01-Sep-09

Added support for using different client libraries simultaneously
Added thread-safety to the Connections list
Now the value from the master dataset has priority over the DefaultExpression value
Bug with not unlocking record in the CachedUpdates mode if no fields were changed, fixed
Bug with parsing TDAScript.Statements fixed
Bug with TIBCAlerter registering only first event under Delphi 2009 fixed

3.00.0.4 24-Jun-09

Bug with local sorting in CachedUpdates mode fixed
Bug with raising exceptions on locating records when IndexFieldNames is set, fixed
Bug with calculating connection count in Disconnected mode fixed
Bug with calling the OnError event on connection failure when Pooling is enabled, fixed
Bug with macros in TDAScript fixed
Bug with database name containing multibyte characters fixed
Problem with default values with leading blanks fixed
Problem with QueryRecCount option and FROM keyword inside a field list fixed
Access violation on assigning value to TIBCTransaction.Active property fixed

3.00.0.3 27-May-09

Added the Disconnected property to TCustomDADataSet
Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
Bug with the GotoCurrent method fixed
Bug with LocalMasterDetail and Prepare method fixed
Bug with FullRefresh and macros fixed
Bug with UseUnicode and TrimFixedChar=False fixed
Added support for TQuery.DataSource property in BDE Migration Wizard

3.00.0.2 02-Apr-09

TIBCLoader component
serves for fast loading of data to the database. For Firebird 2.0 and higher it combines INSERT statements in one EXECUTE BLOCK statement to speed up loading.
InterBase services components
allow to backup and restore database, configure server parameters and security.
Added support for Free Pascal under Linux
Added NoPreconnect property to TIBCScript for executing CONNECT and CREATE DATABASE commands
Bug with DetailDelay and refreshing closed dataset fixed
Bug with detecting DBMonitor on 64-bit Windows fixed
Bug with not calling UnregisterClient for internal command of dataset fixed
Bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate fixed
Bug with TIBCStoredProc using incorrect transaction fixed
Bug with ftWideString parameters when UseUnicode=False fixed

2.70.0.45 26-Feb-09

Added RowsInserted, RowsUpdated, and RowsDeleted properties for using with statements like UPDATE OR INSERT
Bug with not working CachedUpdates in TVirtualTable fixed
Bug with suppressing errors in TVirtualTable.LoadFromFile fixed
Problem with restoring current row after refresh fixed
Bug when statements, executed on TClientDataSet.ApplyUpdates, were not shown in DBMonitor, fixed
Access violation on the TClientDataSet.ApplyUpdates call fixed
Bug in Delphi 2006 and above with the BcdCompare function avoided
Bug with decoding Unicode surrogate pairs fixed
Bug with field names starting with RET_ fixed

2.70.0.44 06-Jan-09

Fixed bug with treating some string elements as equal by CompareString

2.70.0.43 09-Dec-08

Added DEFAULT_VALUE and DESCRIPTION columns to TIBCMetaData
Bug with not using UpdateTransaction in EmptyTable and DeleteTable of TIBCTable fixed
Bug with setting the Required flag for NUMERIC fields fixed

2.70.0.42 19-Nov-08

Bug with field names containing '.' fixed
Bug with assertion failure on editing components in design time for Delphi 5 fixed
Several bugs in DataSet Manager fixed
Bug in Migration Wizard with converting binary forms in Delphi 2009 fixed
Added calling the TfrxReport.OnBeforeConnect event when TfrxDACDatabase is connecting
Bug with name compatibility with ReportBuilder fixed

2.70.0.41 23-Oct-08

Delphi 2009 and C++Builder 2009 supported
Extended Unicode support for Delphi 2007 added (special Unicode build)
Free Pascal 2.2 supported
Powerful design-time editors implemented in Lazarus
Completed with more comprehensive structured Help

2.50.0.39 22-Sep-08

Added DescribeParams option that provides automatic parameters describing when a statement is prepared
Improved working with master/detail relationship when LocalMasterDetail=True
Bug with access violation on getting OldValue for BLOB fields fixed
Bug with the IsNull property for output string parameters fixed
Bug with parsing RETURNING clause fixed

2.50.0.37 21-Aug-08

Bug with adding #0 to the end of Unicode BLOB values fixed
Bug with string output parameters fixed
Access violation on calling TClientDataSet.ApplyUpdates fixed

2.50.0.36 11-Jul-08

Added support of NOT LIKE keyword in the TDataSet.Filter property
Improved working with master/detail on inserting new records
Several bugs when working with inactive datasets fixed
Bug with filtering by TLargeIntField fixed
Bug with calling the OnError event when LocalFailover is set to True fixed
Bug with setting the Database property fixed
Bug with not using UpdateTransaction for TClientDataSet.ApplyUpdates fixed
Added ability to call Code Editor from component editors

2.50.0.35 11-Jun-08

Bug with the SetOrderBy method fixed
Bug with AV failure on assigning the OnFilterRecord event handler fixed
Bug with determining primary key fields fixed
Bug with generating update SQL with IS NULL in the WHERE clause at design-time fixed
Bug with ptUnknown parameter values loss after execute fixed

2.50.0.34 23-May-08

Added compatibility with UniDAC
Improved support of default field values
The new component for metadata receiving added
Improved work with master/detail
Bug with fetching strings from database with the NONE character set fixed
Bug with interpreting empty string parameters as NULL fixed

2.20.2.15 04-Apr-08

Bug with locating records using the LocateEx method and the lxNext option fixed
Access violation on local sorting fixed
Bug with executing scripts from files larger than 2GB fixed
Access violation on fetching strings with multibyte character set fixed

2.20.2.14 18-Feb-08

Enhanced local sorting with new options (DefaultSortType option, BIN sort type in IndexFieldNames)
Added support for SQLInsert, SQLUpdate, SQLDelete properties for updating with TDataSetProvider
Improved bookmarks comparison
Bug with corrupting BLOB fields on CancelUpdates method call fixed
Bug with KeepDesignConnected option when Connection is not set for a dataset fixed
Bug with accessing persistent BLOB fields in closed dataset fixed

2.20.1.13 09-Jan-08

Added EnableMemos option that enables creating TMemoField and TWideMemoField for text BLOBs
Added support for BLOBs with UTF8 character set
Bug in master/detail for shifting columns count in the detail dataset fixed
Several bugs with records location fixed
Bug with TCRBatchMove whose source dataset does not reflect actual record count in the RecordCount property fixed
Problem with querying key fields on opening dataset fixed
Problem with re-querying key and data fields after refresh in AutoClose mode fixed

2.20.0.12 14-Nov-07

Added support for TVariantField in VirtualTable
Added ability to upgrade IBDAC without uninstallation of previous IBDAC builds
Corrected behaviour DMLRefresh to refresh all fields
Bug with deletions of manually added macros on assigning their values fixed
Bug in TIBCTransaction.IsolationLevel design time editor fixed
Bug with incorrect execution of SET TERM by TIBCScript fixed
Now an exception is raised when uaFail is assigned to UpdateAction in OnUpdateRecord event handler
Bug with second script execution after the first execution failed with an exception fixed
Bug with parsing numbers followed by parameters whose names consist of digits fixed
Bug with locating variant values in TVirtualTable fixed

2.20.0.11 27-Sep-07

CodeGear RAD Studio 2007 supported
Added ability to treat integer fields as TBooleanField when the domain name contains "BOOLEAN"
Added ability to send the DataSetChange event after dataset open
Optimized memory utilization when loading XML files by the TVirtualTable.LoadFromFile method
Corrected behavior of RefreshRecord method to use an active update transaction
Bug with fetching Unicode fields fixed
Bug with updating unmodified BLOB fields using automatic SQL generation fixed
Bug with AV when using calculated fields fixed
Bug with commiting updates in CachedUpdates mode fixed
Bug with Disconnected Model and Pooling fixed
Bug with using the Filter property for FindFirst and similar methods when Filtered is False fixed
Bug with calling First after changing UpdateRecordTypes in Edit mode fixed
Bug with save/load data to/from XML fixed
Assert with TCRBatchMove and BLOB fields fixed
Improved color schema of syntax higlighting with SynEdit
Avoided design-time bug with UniSynEdit fixed

2.10.0.10 02-Aug-07

Bug with ARRAY fields modification fixed
Bug with invalid length of calculated string fields fixed
Bug with fixed calculated string fields fixed
Bug with comment statements in IBCScript fixed
Bug with Pooling and Local Failover fixed
Bug with "Invalid Variant Type" exception under Windows 2000 when TDataSet.Refresh is called fixed
Bug with performance penalty when processing lookup and calculated fields fixed
Bug with PSGetDefaultOrder method freezing for queries with complicated ORDER BY clauses fixed
Bug in TCRBatchMove with mapping fields by name when Fields count and FieldDefs count are not equal fixed
Bug with adding fields in TVirtualTable fixed
Bug with field names quotation in CRDBGrid fixed
Problem with DBMonitor integration under Windows Vista Ultimate fixed

2.10.0.9 12-Jun-07

C++Builder 2007 supported
DLL demo added
Bug with refreshing record in detail dataset fixed
Bug with raising exceptions when locating records on filtered recordsets fixed
Bug with the BaseSQL property set to an empty string after assigning macro values fixed
Bug with incorrect registry key used by connect dialog to save/load the Server value fixed
Added ability to customize information view about fields in DataSetManager
Performance of some operations in DataSet Manager improved
Minor bugs in DataSet Manager fixed

2.00.0.7 16-May-07

Added threads demo to the IBDAC demo project
Support for rmReconnectExecute failover action with SQL statements execution added
Ability to drag datasets between connections in group by connections mode in DataSet Manager added
Ability to assign DataSource and DataField properties of DevExpress DB-aware controls automatically in DataSet Manager added
Extended abilities of assigning default controls for datasets and fields in DataSet Manager
Bug with case-sensive field name quotation fixed
Bug with milliseconds truncation in TIME and TIMESTAMP values fixed
Bug with AV failure after second call to CommitUpdates when there are skipped records in cache fixed
Bug with complex fields modification in Disconnected Model with Pooling fixed
Bug with double quoting of field names in automatically generated SQL commands fixed
Bug with "DisposeBuf failed" exception on updating string fields in CachedUpdates mode fixed
Minor bugs with installation for C++Builder and Delphi 2007 fixed
Bug with displaying values of ftTime and ftDateTime parameters in debug window fixed
Bug with loading DataSet Manager package in a localized IDE fixed
Fixed bug in the IBCDataAdapter component with reading BLOB fields
Minor bugs in DataSet Manager fixed

2.00.0.6 20-Apr-07

FastScript v1.9 support added
Support for DevExpress controls in DataSet Manager added
Bug with parameters updating fixed
Bug with QuoteNames option in TIBCTable fixed
Bug with TIBConnection parameters assignment fixed
Access violation with deleting records in CachedUpdates mode fixed
Bug when detail DataSet is refreshed on switching master DataSet to Edit mode fixed
Bug in SQL Generator with generating REFRESH statements for detail DataSet fixed
Bug with setting RecNo property for filtered datasets fixed
Bug with PSGetTableName returning incorrect value after changing the SQL property fixed
Bug with calling TDataSet.Edit for master DataSet in CachedUpdates mode fixed
Bug with filter expression that contains several consecutive left brackets fixed
Access violation when loading DataSet Manager package under Delphi 2007 and Windows Vista fixed
Bug with DataSet Manager when IDE freezes on loading a form with a large quantity of datasets fixed
Bug with executing parametrized queries in Detail dataset from design-time editor fixed
Bug with displaying invalid object property type in object inspector fixed
Bug with loading files in TIBCScript editor fixed
Bug with calling design-time editors of TDADataSource descendants by double click fixed
Bug with SQL Generator in design time fixed
Bug with trimming SQL texts in design-time editors fixed
Bug with creating components from Developer Tools database explorer window fixed
Minor bugs in installation fixed

2.00.0.5 06-Apr-07

Support for context sensitive help in BDS added
Support for sending events in Firebird 2 with TIBCAlerter added
Bug with Locate on ordered data fixed
Bug with case-sensitive sorting fixed
Bug with empty default field expression fixed
Bug with setting RecNo property for filtered datasets fixed
Bug with overloading IBCConnection.ApplyUpadtes fixed
Bug with XmlTextReader.Eof property under C++Builder fixed
DataSet Manager stability improved
Minor bugs in installation fixed

2.00.0.4 22-Mar-07

New functionality:

Delphi 2007 for Win32 supported
Disconnected model for working offline and automatically connecting and disconnecting supported
Local failover for detecting connection loss and implicitly reexecuting some operations supported
Added DataSet Manager to control project datasets
New TCRBatchMove component for transferring data between all types of TDataSet descendants added
Data export and import to/from XML supported
WideMemo field type in Delphi 2006 supported
Support for sending messages to DBMonitor from any point of your program added

Support for more InterBase/Firebird server functionality:

RETURNING clause in the INSERT SQL statement (Firebird 2 server only) supported
EXECUTE BLOCK syntax (Firebird 2 server only) supported
Automatic updates by DB_Key unique field (Firebird 2 server only) supported
Default values in stored procedures supported

Extensions and improvements to existing functionality:

General performance improved
Master/detail functionality extensions:
- Local master/detail relationship support added
- Master/detail relationship in CachedUpdates mode support added
Connection pool functionality improvements:
- Efficiency significantly improved
- API for draining the connection pool added
TIBCScript component improvements:
- Support for executing individual statements in scripts added
- Support for executing huge scripts stored in files with dynamic loading added
- Ability to use standard ISQL tool syntax added
Greatly increased performance of applying updates in CachedUpdates mode
Working with calculated and lookup fields improvements:
- Local sorting and filtering added
- Record location speed increased
- Improved working with lookup fields
Ability to customize update commands by attaching external components to TOraUpdateSQL objects added
Ability to include all fields in automatically generated update SQLs added

Usability improvements:

Syntax highlighting in design-time editors added
Completely restructured and clearer demo projects

1.10.0.15 16-Feb-07

FastReport 4 support added
Editor for the MasterFields property of TCustomDADataset in C++Builder added
Bug with the IndexFieldNames property not working for detail dataset in master/detail link fixed
Bug with reading and writing Unicode CLOB through TBlobStream on computers with multibyte character set fixed
Bug with Unicode parameters fixed
Bug with UTF8 to UTF16 conversion fixed
Bug with CLR Unicode fetch fixed

1.10.0.14 12-Jan-07

Ability to make Master/Detail relationship by TBytesField added
Support for Array type in TIBCSQLMonitor added
Bug with Fast Query Builder support fixed
Bug with EOL conversion in output parameters fixed
Bug with ConvertEOL option fixed
Bug with updating InterBase Array by slices fixed
Bug with output streamed BLOB parameters fixed
Bug with BLOB parameters without live connection fixed
Bug in BDE Migration Wizard with replacing DatabaseName property fixed

1.10.0.13 05-Dec-06

Bug with memory leaks fixed
Bug with predefined InsertSQL and Firebird 2 generator values fixed
Bug with fetching Unicode strings fixed
Bug with transaction control commands in TIBCScript fixed
Bug with TraceFlags in DASQLMonitor fixed (D16224)
Bug with TDAParam.AsDate property fixed (D16213)
Bug with wrong value of the StatementTypes variable in the BeforeUpdateExecute event fixed
Bug with AV failure when modifying VirtualTable data in design time fixed

1.10.0.12 31-Oct-06

Bug with ParamType property not set for BLOB parameters fixed
Bug with automatic Lock statement generation fixed
Bug with automatic Refresh statement generation fixed
Bug with updating not-NULL empty string fields fixed
Bug with VARCHAR parameter's value trimming fixed
Bug with comparing Unicode strings fixed
Big with RefreshRecord in CachedUpdates mode fixed
Bug with BeforeDisconnect event lost in design time fixed
Bug with mouse wheeling in FilterBar and Search bar of CRDBGrid fixed (15675)
Bug with debug mode in design time fixed
Bug with SmartRefresh Help fixed

1.10.0.11 29-Sep-06

Support for ReportBuilder added
Support for InfoPower added
Bug with detecting TWideStringField modification fixed
Bug with connection pooling fixed
Bug with BDE, IBX Migration Wizard fixed

1.10.0.10 28-Aug-06

Support for Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ added
Support for macros names in which first symbol is digit added
Capability to use quoted field names in IndexFieldNames property added (D10091)
Bug with setting TCustomIBCDataSet.UpdatingTable fixed
Bug with automatic detail field value generation fixed (12886)
Bug with canceling edit on record with BLOB fields fixed
Bug with FindKey method when the primary key has field of type Int64 fixed (D12558)
Bug with filtering DateTime fields when filter expression format differs from one in local system fixed (D12823)
Bugs with parsing macros fixed
Bug with automatic LockSQL generation fixed (13494)
Bug with automatic UpdateSQL generation fixed
Bug with TrimVarChar fixed
Bug with WideString lookup fields size fixed
Bug with loading wide strings in TVirtualTable fixed
Bug with MIDAS demo fixed

1.00.1.9 06-Jul-06

Support for default field values improved
Midas demo project added
Performance of SaveToFile and LoadFromFile functions in TVirtualTable improved (12435)
Bug with memory leaks in IBDAC fixed
Bug with changing BLOB parameters type fixed (12416)
Bug with using calculated and lookup fields in Master/Detail relationship fixed
Bug with design time editor for Detail dataset in Master/Detail relationship fixed (12021, M11914)
Bug with AutoClose and DefaultValues options of TCustomIBCDataSet class fixed
Bug with TIBCScript.Transaction with DDL statements fixed
Bug with wrong line number in DAScript.EndLine property fixed(12015)
Bug with TIBCTable.OrderFields fixed
Bug with filtering empty strings fixed (S12329)
Bug with modifying FieldDefs in TVirtualTable fixed
Bug in TVirtualTable Editor fixed

1.00.1.8 31-May-06

Bug with DBSQLDialect with InterBase 5.6 fixed
Bug with memory leak in TCustomDADataSet fixed (11636)
Bug with TIBCConnectionOptions creation fixed
Bug with Master-Detail linked by parameters fixed
Bug with calling Parameter Editor from Object Inspector fixed (11671)

1.00.1.7 18-May-06

IBDAC is now compatible with ODAC, SDAC and MyDAC

1.00.0.6 12-May-06

InterBase Array type help improved
Bug with date and time fields on Kylix fixed
Bug with Kylix demos compatibility fixed

1.00.0.5 10-May-06

Initial release of IBDAC