IBDAC What's New

New Features in IBDAC 11.0

• Added support for RAD Studio 13.1 Florence
• Added support for the Arm64EC target platform
• Added support for Lazarus 4.6
• Added support for Firebird 3 functions
• Added support for the wait_time and read_consistency parameters for TPB
• Added support for the isc_dpb_connect_timeout, isc_dpb_dummy_packet_interval, and isc_dpb_garbage_collect parameters for DPB
• Added support for the isc_dpb_config parameter for DPB
• Added support for the isc_spb_config parameter for SPB
• Added support for "GENERATED BY DEFAULT AS IDENTITY" fields
• Added the FloatAsSingle option for the Connection component
• Added the UseReadConsistency option for the Connection component
• Added the ConnectionConfigOverrides option for the Connection component
• Added the TCustomIBCService.WireCompression option
• Added the TCustomIBCService.ConnectionConfigOverrides option
• Added the "For the current user/For all users" option during installation
• Added masking of the Password property in the Connection component to prevent it from being stored in memory as plain text
• Added the GetWhere method to the TCustomDADataSet component
• Added the DeleteOrderBy method to the TCustomDADataSet component
• Added the RangeFieldCount property to TCustomDADataSet to specify the number of indexed fields used for range setting
• Added the AutoClose option to TCustomDADataSet to control automatic closing of a dataset when its associated ClientDataSet is closed
• Improved work with DPB
• Improved work with TPB
• Improved work with SPB

New Features in IBDAC 10.0

• Added support for RAD Studio 13 Florence
• Added support for Lazarus 4.2
• Added the boNoTriggers and boZip options to the TIBCBackupService component
• Added support for user-defined security databases to the TIBCSecurityService component for Firebird
• Added the TIBCError.SQLState property to store the SQLSTATE completion code
• Added the Pooled function to the TCustomDAConnection component
• Added support for ReportBuilder 23 in the demo project
• Improved the format of the DEFAULT_VALUE column in TIBCMetaData (when MetaKind = Column) to return values in a clear-text representation

New Features in IBDAC 9.4

• Added support for RAD Studio 12 Athens Release 3
• Added support for the RAD Studio 64-bit IDE
• Added support for Lazarus 3.8
• Added support for parameters in the Script component
• Added support for the TurboPack SynEdit package in component editors
• Added support for syntax highlighting in component editors in Lazarus on the Windows platform
• Added the IndentFormat argument to the SaveToXML method of the dataset to decrease file size
• Added the SaveToJSON method for serializing a dataset to the JSON format
• Added the ability to use readonly fields in the SQL Generator at design-time
• Improved work with design-time editors in the High DPI mode

New Features in IBDAC 9.3

• 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.6

New Features in IBDAC 9.2

• Added support for RAD Studio 12 Athens Release 1
• Added support for Lazarus 3.2
• Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required

New Features in IBDAC 9.1

• Lazarus 3.0 is supported
• 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

New Features in IBDAC 9.0

• Added support for RAD Studio 12
• Added support for macOS Sonoma
• Added support for iOS 17
• Added support for Android 13
• 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

New Features in IBDAC 8.3

• 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

New Features in IBDAC 8.2

• 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 is 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 is set to False and the UseUnicode property is set to True
• Fixed bug when a connection string parameter value contains a single quote

New Features in IBDAC 8.1

• RAD Studio 11 Alexandria Release 1 is supported
• Lazarus 2.2.0 is supported
• Windows 11 is supported
• macOS Monterey is supported

New Features in IBDAC 8.0

• 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

New Features in IBDAC 7.4

• 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

New Features in IBDAC 7.3

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

New Features in IBDAC 7.2

• RAD Studio 10.4 Sydney is supported
• Lazarus 2.0.8 is supported
• macOS 64-bit in Lazarus is supported

New Features in IBDAC 7.1

• 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

New Features in IBDAC 7.0

• 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

New Features in IBDAC 6.4

• 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

New Features in IBDAC 6.3

• 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

New Features in IBDAC 6.2

• 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

New Features in IBDAC 6.1

• 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

New Features in IBDAC 6.0

• 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

New Features in IBDAC 5.7

• 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
• Data Type Mapping performance is improved
• Performance of TDALoader on loading data from TDataSet is improved

New Features in IBDAC 5.6

• RAD Studio 10 Seattle is supported
• INSERT, UPDATE and DELETE batch operations are supported
• Now Trial for Win64 is a fully functional Professional Edition

New Features in IBDAC 5.5

• 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

New Features in IBDAC 5.4

• 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 ConstraintColumns metadata kind for the TDAMetadata component is added

New Features in IBDAC 5.3

• 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

New Features in IBDAC 5.2

• 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

New Features in IBDAC 5.1

• 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
• The possibility to use conditions 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

New Features in IBDAC 5.0

• Rad Studio XE4 is supported
• NEXTGEN compiler is supported
• Application development for iOS 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
• InterBase XE3 ToGo Edition support for iOS device is added
• Additional database shutdown options for TIBCConfigService.ShutdownDatabase are added

New Features in IBDAC 4.6

• 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

New Features in IBDAC 4.5

• Rad Studio XE3 is supported
• Windows 8 is supported

New Features in IBDAC 4.1

• Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
• Mac OS X and iOS 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

New Features in InterBase Data Access Components 4.00

• 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

New Features in InterBase Data Access Components 3.60

• Lazarus 0.9.30 and FPC 2.4.2 is supported
• TIBCLoader.InsertMode property allowing the use of "UPDATE OR INSERT INTO" syntax for loading data is added
• Possibility to assign Handle to TIBCConnection is added

New Features in InterBase Data Access Components 3.50

• Embarcadero RAD Studio XE suppored

New Features in InterBase Data Access Components 3.10

• Embarcadero RAD Studio 2010 supported

New Features in InterBase Data Access Components 3.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.
• Free Pascal under Linux supported
• Added NoPreconnect property to TIBCScript for executing CONNECT and CREATE DATABASE commands

New Features in InterBase Data Access Components 2.70

• 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

New Features in InterBase Data Access Components 2.50

• Added compatibility with UniDAC
• Improved support of default field values
• The new component for metadata receiving added

New Features in InterBase Data Access Components 2.20

• CodeGear RAD Studio 2007 supported
• Added ability to treat integer fields as TBooleanField when the domain name contains "BOOLEAN"

New Features in InterBase Data Access Components 2.10

• C++Builder 2007 supported

New Features in InterBase Data Access Components 2.00

New functionality:

• Delphi 2007 for Win32 support
• Implemented Disconnected Model for working offline and automatically connecting and disconnecting
• Implemented Local Failover for detecting connection loss and implicitly re-executing some operations
• WideMemo field type in Delphi 2006 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
• Support for sending messages to DBMonitor from any point in 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
  • Support for master/detail relationships in CachedUpdates mode added
• Connection pool functionality improvements:
  • Efficiency significantly improved
  • New 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 TIBCUpdateSQL 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

New Features in InterBase Data Access Components 1.10

• Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ supported