New version of UniDAC 9.2 is available!

[Devart]

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