Devart Forums

We are glad to announce the release of the UniDAC 11.1 with the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Fixed bug with executing batch operations with the VirtualQuery component
• Fixed bug with resetting param values when changing param values count
• Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

Oracle data provider

• Fixed bug with HTTPS tunneling in the Direct mode

SQLServer data provider

• Passing the "client_interface_name" parameter to the server in the Direct mode is added
• Fixed bug with adding a condition to the WHERE clause on calling the AddWhere method
• Fixed bug with a "Cannot modify a read-only dataset" on Delete where all fields are read-only
• Fixed bug with executing batch operations when constants in parameter
• Fixed bug with getting IndexColumns metadata in the Direct mode
• Fixed bug with removing persistent fields in Android
• Fixed bug with AV when encrypting a field

MySQL data provider

• Fixed bug with a "Refresh failed" on Post when RefreshOption = roAfterInsert and SQL contains the same PK more than once
• Fixed bug with an "Unknown column" when adding record containing calculated field when RefreshOption = roAfterInsert
• Fixed bug with fkInternalCalc field after calling the Refresh method

PostgreSQL data provider

• The SCRAM-SHA-256-PLUS authentication mechanism is supported
• "ON CONFLICT" in batch operations is supported
• Open connection performance is improved
• The AddDelete specific option for the Dump component is added
• Dumping of stores procedures via the Dump component is added
• Fixed bug with FieldDesc.IsAutoIncrement = False for fields created as "GENERATED ALWAYS AS IDENTITY"
• Fixed bug with saving JSON fields

InterBase data provider

• Fixed bug with the growing memory consumption
• Fixed bug with loading BLOB columns using the Loader component
• Fixed bug with including international characters in SELECT queries when UseUnicode set to True
• Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using update batch operations
• Fixed bug with an "Invalid class typecast" error when editing Blob in Trial Edition is fixed
• Fixed bug with an "Invalid pointer operation" error when using custom constraints

SQLite data provider

• Now the Direct mode is based on version 3.37.2 of the SQLite engine
• Fixed bug with an empty string field value when the database column stores data larger than the field size
• Fixed bug with incorrect DATETIME values handling when DateFormat and TimeFormat connection options are set to non-default values
• Fixed bug with handling DATETIME values that contains the "Z" suffix in milliseconds

MongoDB data provider

• Fixed bug with Access Violation when reading documents that contain a field of type object

ODBC data provider

• Fixed bug with the impossibility of editing a table whose name is specified in the query in a fully-qualified format

Devart Development Team

https://www.devart.com/unidac