Devart Universal Data Access Components (UniDAC) v9.2.1 Professional for Rad Studio 11.1
Devart Universal Data Access Components (UniDAC) v9.2.1 Professional for Rad Studio 11.1
Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Lazarus (Free Pascal). We have combined the experience of long-term successful development into one product, which provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).
UniDAC offers unified approach to the database-related applications development process. That means you can switch easily between different databases in your projects without going deep into their specifics.
Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC gives outstanding flexibility and independence to your projects.
Server-Aware Providers
UniDAC chooses the best way specific to the server to perform most operations. Every UniDAC data provider uses server-specific native connectivity. All operations with data are performed by providers automatically considering the selected database server peculiarities.
Cross-Platform Solution for Delphi, C++Builder, and Lazarus
UniDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both x86 and x64 platforms. UniDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.
Server-Independent SQL
When developing database applications that allow working with several databases, one of the key points is writing of server-independent SQL. In UniDAC, the server-independent SQL support is implemented by means of the powerful macros engine, that produces dynamic SQL by replacing parts of the query statements with user-defined code.
9.2.1 12-Apr-22
RAD Studio 11.1 Alexandria is supported
Lazarus 2.2.0 is supported
Windows 11 is supported
macOS Monterey is supported
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
RAD Studio 11.1 Alexandria is supported
Lazarus 2.2.0 is supported
Windows 11 is supported
macOS Monterey is supported
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
Only for V.I.P Warning! You are not allowed to view this text.