Universal Data Access Components (UniDAC) Versioni

DevartStrumenti di accesso ai datiComponente VCL
Versione 12.1.0 (29 set 2026)(10)

Scopri le novità in ogni release, con dettagli su funzionalità, miglioramenti e problemi risolti.

gen
feb
mar
apr
mag
giu
lug
ago
set
ott
nov
dic
Universal Data Access Components (UniDAC) 12.1.029 set 2026
Funzionalità
  • Added support for RAD Studio 13 Florence Release 2.
  • Improved support for the Arm64EC target platform.
  • Added support for Lazarus 4.8.
  • Added the voAssignReadOnly and voAssignRequired options to the VirtualTable component to control field attributes when calling Assign().
  • Improved handling of the UpdatingTable property when a query contains multiple references to the same table.
  • Removed the deprecated AutoCommit property from the Script component.
  • Removed the insecure MD5 hashing algorithm from the tunnel.php script.

Oracle data provider

  • Added the AutoCommit specific option to the SQL, Table, Query, StoredProc, and Script components.

SQL Server data provider

  • Added support for Microsoft SQL Server 2025.
  • Added support for Always Encrypted.

InterBase data provider

  • Added the AutoCommit specific option to the Script component.
  • Improved generation of INSERT and UPDATE statements when DMLRefresh is enabled.
  • Added support for the TrustedAuthentication specific option in TUniConnection.
  • Added support for Wait mode and Lock timeout in the transaction component.

MySQL data provider

  • Added support for MySQL 9.7.x.
  • Added support for generated columns.
  • Added support for handling the new ER_CLIENT_INTERACTION_TIMEOUT error packet.
  • Added support for the authentication_ldap_sasl authentication plugin with the GSSAPI mechanism.
  • Improved support for the GSSAPI authentication plugin.

PostgreSQL data provider

  • Added the AutoCommit specific option to the SQL, Table, Query, StoredProc, Script, and Dump components.
  • Added the ReadOnly connection option.
  • Added the SNI SSL option to the Connection component.
  • Added the ClientCharset option to the Connection component.
  • Added support for the pv32 protocol in the Connection component.
  • Added the Matview table metadata kind to the TUniMetaData component.

NexusDB data provider

  • Added support for NexusDB 4.75.20.
  • Added support for read-only transactions.
  • Improved data loading performance with TUniLoader.

DBF data provider

  • Improved compatibility with the Codebase format.
  • Improved the AllFieldsAsNullable specific option when working with Visual FoxPro.

Access data provider

  • Improved compatibility with the Access 97 (Microsoft Jet 3) format.

Salesforce data provider

  • Added support for server-to-server authentication.
Correzioni
  • Fixed an issue with incorrect field ordering when using CloneCursor().

Oracle data provider

  • Fixed an issue that caused TOraAlerter to hang when the connection was lost.

InterBase data provider

  • Fixed an issue with the ExtendedFieldsInfo option when working with InterBase.
  • Fixed an issue that caused the "arithmetic exception, numeric overflow, expected length x, actual y" error when opening tables with computed fields.

MySQL data provider

  • Fixed an issue with incorrect INSERT statement generation when a SELECT statement included fields from multiple tables.
  • Fixed an issue that caused the "Record was changed by another user" error when calling the TMyTable.Lock() method.
  • Fixed an issue that occurred when both FlatBuffers and UseUnicode were set to True.

PostgreSQL data provider

  • Fixed an issue where the Script component always ran with AutoCommit set to True, regardless of the specified AutoCommit value.
  • Fixed an issue with using functions when FetchAll is set to False and CursorWithHold is set to True.
  • Fixed an issue with using parameters and AsFloat for BIGINT fields.
  • Fixed an issue that caused prepared statements to accumulate on the server.

SQLite data provider

  • Fixed an issue that caused incorrect results when opening a parameterized dataset with AutoPrepare and AdvancedTypeDetection enabled.

MongoDB data provider

  • Fixed several issues with Decimal128 data type handling.

DBF data provider

  • Fixed an issue with updating LOGICAL fields.
  • Fixed an issue that caused an assertion failure when updating a record.

Excel data provider

  • Fixed an issue that caused the "vtable constructor failed" exception when opening a workbook.
Universal Data Access Components (UniDAC) 12.0.115 giu 2026
Funzionalità
  • 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.
Correzioni
  • 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.0Versione principale27 mar 2026
Funzionalità
  • 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.
Correzioni
  • 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.