InterBase Data Access Components

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

IBDAC release version