InterBase Data Access Components (IBDAC)

What's new in InterBase Data Access Components (IBDAC) V4.0.1?

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

What's new in InterBase Data Access Components (IBDAC) V3.60?

• Lazarus 0.9.30 and Free Pascal 2.4.2 support
• A TIBCLoader.InsertMode property which allows "UPDATE OR INSERT INTO" syntax for loading data has been added
• You can now assign a handle to TIBCConnection
• 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

What's new in InterBase Data Access Components (IBDAC) V3.50?

• Embarcadero RAD Studio XE now supported
• 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

What's new in InterBase Data Access Components (IBDAC) V3.10?

• Embarcadero RAD Studio 2010 now supported
• Now the subdetail is refreshed before the AfterRefresh event of the detail is called

What's new in InterBase Data Access Components (IBDAC) V3.00?

• 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

InterBase Data Access Components (IBDAC) features

General usability

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• Interface compatible with standard data access methods, such as BDE and ADO
• VCL, VCL for .NET, and CLX versions of library available
• Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
• Unicode and national charset support

Network and connectivity

• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations

Compatibility

• Full support of the latest versions of InterBase, Firebird and Yaffil database servers
• Support for all InterBase data types
• Compatible with all IDE versions starting with Delphi 5, C++Builder 5, and Kylix 2, except Delphi 8, and with Free Pascal [New]
• Includes provider for UniDAC Standard Edition [New]
• Wide reporting component support, including support for InfoPower, ReportBuilder, FastReport
• Support of all standard and third-party visual data-aware controls
• Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications

InterBase technology support

• InterBase event support
• Comprehensive array data type support
• Advanced BLOB support
• Streaming (non-caching) BLOB access support
• Advanced generator support
• Advanced support for the character set OCTETS
• Support for the Firebird 2 EXECUTE BLOCK syntax
• Support for the Firebird 2 RETURNING clause
• Advanced locking for Firebird 2
• Automatic updates by DB_KEY unique field for Firebird 2
• Default value support for stored procedures

Performance

• High overall performance
• Fast controlled fetch of large data blocks
• Optimized string data storing
• Advanced connection pooling
• High performance of applying cached updates with batches
• Caching of calculated and lookup fields
• Fast Locate in a sorted DataSet
• Preparing of user-defined update statements

Local data storage operations

• Database-independent data storage with TVirtualTable component
• CachedUpdates operation mode
• Local sorting and filtering, including by calculated and lookup fields
• Local master/detail relationship
• Master/detail relationship in CachedUpdates mode

Data access and data management automation

• Automatic data updating with TIBCQuery and TIBCTable components
• Automatic record refreshing and locking
• Automatic query preparing
• Support for ftWideMemo field type in Delphi 2006 and higher

Extended data access functionality

• Separate component for executing SQL statements
• Simplified access to table data with TIBCTable component
• Ability to retrieve metadata information with TIBCMetaData component [New]
• BLOB compression support
• Support for using macros in SQL
• Ability to customize update commands by attaching external components to TIBCUpdateSQL objects
• Deferred detail DataSet refresh in master/detail relationships
• MIDAS technology support
• IBCDataAdapter component for WinForms and ASP.NET applications

Data exchange

• Transferring data between all types of TDataSet descendants with TCRBatchMove component
• Data export and import to/from XML (ADO format)
• Ability to synchronize positions in different DataSets

Script execution

• Advanced script execution features with TIBCScript component
• Support for executing individual statements in scripts
• Support for executing huge scripts stored in files with dynamic loading
• Ability to use standard ISQL syntax in scripts

SQL execution monitoring

• Extended SQL tracing capabilities provided by TIBCSQLMonitor component and DBMonitor application
• Borland SQL Monitor support
• Ability to send messages to DBMonitor from any point in your program

Visual extensions

• Includes source code of enhanced TCRDBGrid data-aware grid control
• Customizable connection dialog

Design-time enhancements

• DataSet Manager tool to control DataSet instances in the project
• Advanced design-time component and property editors
• Automatic design-time component linking
• Easy migration from BDE and IBX with Migration Wizard
• More convenient data source setup with the TIBCDataSource component
• Syntax highlighting in design-time editors

Product clarity

• Complete documentation sets
• Printable documentation in PDF format
• A large amount of helpful demo projects

Standard Edition includes:

• Base Components - (TIBCConnection, TIBCTransaction, TIBCQuery, TIBCSQL, TIBCTable, TIBCStoredProc, TIBCUpdateSQL, TIBCDataSource, TIBCScript, TIBCSQLMonitor, TIBCConnectDialog, TVirtualTable, IBCDataAdapter, CRDBGrid)
• Design-time features, including component editors and property editors
• Migration Wizard

Professional Edition additionally includes:

• Additional Components (TIBCLoader, TIBCAlerter, TIBCMetaData, TIBCServerProperties, TIBCConfigService, TIBCLicensingService, TIBCLogService, TIBCStatisticalService, TIBCBackupService, TIBCRestoreService, TIBCValidationService, TIBCSecurityService,  TCRBatchMove)
• DataSet Manager
• FreePascal