- 首页 /
- 组件 /
- ... /
- 数据层 /
- 数据库连接 /
- Universal Data Access Components (UniDAC)
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.