- 首頁 /
- 構件 /
- ... /
- 資料層 /
- 資料庫存取 /
- Universal Data Access Components (UniDAC)
Universal Data Access Components (UniDAC) 10.3.2
Released: Jan 20, 2025
10.3.2 中的更新
特性
- Added the CloneCursor method to the VirtualTable component.
- Moved the CRFunctions.CRTimeZoneInformation global variable to the interface section.
SQL Server data provider
- Added the TrustSelfSignedCertificate connection option for the Direct mode.
- Added the HostNameInCertificate connection option for the prMSOLEDB provider.
- Added the ServerCertificate connection option for the prMSOLEDB provider.
Access data provider
- Added support for retrieving the last generated value of an AutoNumber column via the LastInsertId property in Direct mode.
修補程式
- Fixed an issue with the SaveToXML method of the TMemDataSet class and its descendants, which occurred when saving UUID fields.
- Fixed a bug that occurred when calling the RefreshRecord method with FullRefresh set to True.
- Fixed an issue with processing the Filter property of a dataset that occurred when it included the NOT operation.
- Fixed an issue with using subfunctions in a filter.
- Fixed a bug with the UniStoredProc component handling parameters when the UniConnection component contains defined macros (Common).
- Fixed an issue with migrating from IBX to UniDAC using the Migration Wizard.
- Fixed an issue in the TVirtualQuery component that caused inaccurate results for aggregate functions when applied to floating-point columns.
- Fixed an issue with opening TVirtualQuery with a specific FetchRows value.
- Fixed a bug in the TVirtualQuery component that occurred when executing a query containing an ORDER BY clause.
- Resolved a memory leak issue in the TVirtualDataSet component that occurred when Filtered was set to True.
Oracle data provider
- Fixed a bug that caused the last LF to be incorrectly converted to a CRLF line break in CLOB values.
- Fixed a bug that occurred during DML batch operations when all parameter values were cleared.
- Fixed an issue with supporting self-signed certificates for the SSL protocol in Direct mode.
- Fixed an issue with reading UTF-16 surrogate pairs in Lazarus when using Direct mode.
SQL Server data provider
- Resolved an issue with quoting parameter names.
- Fixed a bug with processing string fields that occurred when the UTF-8 code page was used.
- Fixed a bug causing string truncation when using TMSLoader.
- Fixed a bug with handling special characters in parameter names.
- Fixed an issue with binding ftFMTBCD parameters by OLE DB providers.
- Fixed an issue where an "Unspecified error" exception occurred upon connection loss in the prMSOLEDB provider.
MySQL data provider
- Fixed a bug causing an assertion failure when using the TCRSSHIOHandler component with FetchAll set to False.
- Fixed an issue with handling stored procedures when SELECT privileges were not granted.
PostgreSQL data provider
- Fixed a bug with parsing parameters in anonymous blocks.
- Fixed a bug with parsing dollar-quoted blocks.
- Fixed an issue with the '.' time separator.
- Fixed an issue with the AutoCommit behavior that occurred when using Execute for batch operations.
- Fixed a bug related to the use of multiple schemas.
- Fixed an issue with ENUM data types in dumps.
- Fixed an issue with the CHAR data type.
- Fixed an issue with array data types in dumps.
InterBase data provider
- Fixed an issue where changes to BLOB fields were not rolled back after canceling modifications to the dataset.
- Fixed a bug causing a "List index(1) out of bounds" error during the processing of SQL queries with the RETURNING clause.
- Fixed a bug causing an "Invalid cursor reference. Cursor is not open" error during the processing of SQL queries with the RETURNING clause.
- Fixed an issue where Rollback was executed incorrectly when AutoCommit was set to False.
MongoDB data provider
- Fixed an issue with inserting documents with duplicate _id values.
- Fixed a bug causing an Access Violation error when the database name contained underscores.
Access data provider
- Resolved an Access Violation error that occurred when data type mapping rules were configured for the Connection component.
- Fixed a bug causing an Access Violation error when inserting a record into a table with foreign keys.
- Fixed a bug that occurred when opening a database containing saved queries.
- Fixed a bug that occurred when updating a table with Long Text columns.
Excel data provider
- Resolved an issue with reading empty cells formatted with a date style.
- Fixed a bug that occurred when reading cells with complex text formatting.