Universal Data Access Components (UniDAC) 12.0.0

Released: Mar 27, 2026

12.0.0 中的更新

特性

  • Added support for RAD Studio 13.1 Florence.
  • Added support for the Arm64EC target platform.
  • Added support for Lazarus 4.6.
  • 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.
  • Added support for cloning a structure of the VirtualTable component with the Fields.Assign method.
  • Improved performance of the VirtualQuery component when using a TDataSet as a source.
  • Oracle data provider
    • Added support for Oracle 26ai.
    • Added support for the JSON data type in Oracle 21c and later.
    • Improved performance of Oracle homes list detecting.
  • SQL Server data provider
    • Added the DescribeFields option to control the call to the sp_describe_first_result_set procedure.
    • Added the CommandTimeout option to TUniConnection specific options.
  • InterBase data provider
    • 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 the FloatAsSingle specific option for the Connection component.
    • Added the UseReadConsistency specific option for the Connection component.
    • Added the ConnectionConfigOverrides specific option for the Connection component.
    • Added support for "GENERATED BY DEFAULT AS IDENTITY" fields.
    • Improved working with DPB, TPB and SPB.
  • MySQL data provider
    • Added support for MySQL 9.6.
    • Added the SetFieldsReadOnly option to the TUniDump component to allow adding read-only fields in INSERT statements during backup.
    • Added the Delimiter option to the TUniDump component to set a custom delimiter for stored procedure and trigger backup.
  • PostgreSQL data provider
    • Added support for PostgreSQL 18.
    • Added support for protocol 3.2.
    • Added support for virtual generated columns.
    • Added support for OAUTHBEARER authentication.
    • Added the CurrentTimeZone specific connection option.
    • Added the UseSystemLocale specific connection option.
  • SQLite data provider
    • Added support for vector fields via the sqlite-vec and sqlite-vector extensions.
    • Added the LimitLength specific option to set the SQLITE_LIMIT_LENGTH runtime limit.
    • Added the LimitExprDepth specific option to set the SQLITE_LIMIT_EXPR_DEPTH runtime limit.
  • ASE data provider
    • Added the DescribeParams specific option for TUniTable, TUniQuery, and TUniSQL components.
  • NexusDB data provider
    • Added the SkipSetIndexServerCursor option to avoid setting indexes when ServerCursorUsed is used.
  • DBF data provider
    • Added the ReadOnly connection option.
  • Access data provider
    • Added SharedMode and SharedTimeout connection options to enable the concurrent use of the same database from multiple applications.
      • Excel data provider
      • Added support for the CREATE RANGE statement to refer to a range of cells as a database object.
      • Added the ExactFieldLength connection option to set the length of a string field to an exact value depending on the data.
  • BigQuery data provider
    • Added support for Service Account Authentication using JSON.

修補程式

  • Fixed an issue with installing the Professional Edition with Source Code in Lazarus.
  • Fixed an issue that caused incorrect record sorting in a dataset when both ORDER BY and IndexFieldNames are used.
  • Fixed an issue with the ConnectString property in the Connection component when its value contained a sequence of SQL comment characters.
  • Fixed an issue in tunnel.php that required establishing a tunnel connection in a browser first.
  • Fixed an issue with freeing BLOB values when updating a record in the VirtualQuery component .
  • Oracle data provider
    • Fixed an issue that caused a compilation error when ODAC and UniDAC Express were installed simultaneously .
  • SQL Server data provider
    • Fixed an issue where parameter values were lost during Insert operations .
  • InterBase data provider
    • Fixed an issue with an Invalid pointer operation on destroying a dataset.
    • Fixed an issue that caused the "Block Option isc_tpb_rec_version is not valid if isc_tpb_read_consistency was used previously in TPB" error for Firebird 4 and later.
    • Fixed an issue with compiling InterBaseUniProvider for Android 32-bit in RAD Studio 13 Florence and RAD Studio 12 Athens Release 3
  • MySQL data provider
    • Fixed an issue with executing SHOW COLUMNS for MySQL 4.11.x when UseUnicode = True.
  • SQLite data provider
    • Fixed an issue that caused the "Incorrect parameter" exception when executing a query with parameters.
  • ASE data provider
    • Fixed an issue with detecting the server character set.
  • DBF data provider
    • Fixed an issue with incorrect index data update when inserting a record.
  • Access data provider
    • Fixed an issue that caused the "BCD overflow" exception when reading Decimal fields.
  • Excel data provider
    • Fixed several issues with reading tables and named ranges when opening XLSX and XLSM workbooks.
    • Fixed several issues with opening an XLS workbook.