What's new

• What's new in IBDAC

Supported target platforms

• Windows 32-bit and 64-bit
• macOS 64-bit
• Mac ARM
• iOS 64-bit
• Android 32-bit and 64-bit
• Linux 32-bit and 64-bit

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, LCL and FMX 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
• Support for InterBase OTW encryption

Compatibility

• Support for the latest versions of InterBase and Firebird database servers
• Support for InterBase ToGo Edition
• Support for all InterBase and Firebird data types
• Support for Delphi 6, C++ Builder 6, and later versions up to RAD Studio 12 Athens
• Support for Lazarus 3.0 and Free Pascal 3.2.2
• Includes provider for UniDAC Express Edition
• Support for reporting components, including InfoPower, ReportBuilder, FastReport
• Support for all standard and third-party visual data-aware controls
• Support for Professional Edition of Delphi and C++Builder for developing client/server applications

InterBase technology support

• Support for fast record insertion with the TIBCLoader component
• 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
• InterBase services components for configuring server parameters and security
• Support for the Firebird 3 BOOLEAN datatype
• Support for the Firebird 2.1 trusted authentication

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
• Deferred BLOB and array fields reading

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
• 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, IBX and FibPlus components with Migration Wizard
• More convenient data source setup with the TIBCDataSource component
• Syntax highlighting in design-time editors

Resources

• Code documentation and guides in the CHM, PDF, and HXS formats
• Many helpful demo projects

Licensing and support

• Included annual IBDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site