Universal Data Access Components (UniDAC) 12.0.12026年6月15日
功能
PostgreSQL data provider
Replaced the UseSystemLocale Boolean connection option with the SystemLocale charset option.
NexusDB data provider
Added support for the DatabaseReadOnly option on both Remote and Embedded servers.
修正
Fixed a bug that caused the "Invalid package handle" error when closing the IDE on Windows on Arm.
Resolved an issue that could cause an AccessViolation when changing the provider in the Connection component with DisconnectedMode enabled.
Fixed a bug that caused incorrect query results in the VirtualQuery component when a BDE dataset was used as the data source.
Oracle data provider
Fixed an issue with time zone conversion for TIMESTAMP WITH TIME ZONE values.
SQLServer data provider
Fixed an issue with handling names that contain consecutive dots in Direct mode.
InterBase data provider
Fixed an issue with updating datasets that use composite primary keys containing identity columns.
MySQL data provider
Fixed a bug that caused the ReceiveHeader: Net packets out of order error when wait_timeout expired.
Fixed a bug in TMyScript script execution when the default delimiter (;) was used and the script contained the DELIMITER ;; statement.
PostgreSQL data provider
Fixed a bug that caused the "Incompatible types" error.
Resolved an issue related to parameter handling.
Fixed an issue with saving parameters in UniSQL.
Fixed an Access Violation that could occur when using connection pooling with master-detail UUID fields.
Resolved an issue that could cause an AccessViolation when using C++Builder Windows 64-bit (Modern) compilation.
SQLite data provider
Fixed an error that occurred when compiling the LiteStaticCall unit.
DB2 data provider
Resolved an issue with missing table fields on the SQL Generator tab of the Query Editor window.
Universal Data Access Components (UniDAC) 12.0.0主要版本2026年3月27日
功能
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.