Devart UniDAC 8.1.3 Professional for Delphi 10.3.3 Rio

Devart UniDAC 8.1.3 Professional for Delphi 10.3.3 Rio
Devart UniDAC 8.1.3 Professional for Delphi 10.3.3 Rio

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.

8.1.3 10-Mar-20

Bug with installing different editions of two or more DAC's in a single system is fixed
Bug with SQL statements that contain fields with the same name from different tables is fixed
Bug with executing SQL statements that contain comments using the Script component is fixed
Bug with resetting the value of the parameter after adding a new TDACondition is fixed
Bug with reading a field value using the AsBytes method in Lazarus is fixed
Bug with using constraints after calling the Refresh method is fixed

Oracle data provider

Bug with fetching data in the NonBlocking mode is fixed

SQLServer data provider

The UuidWithBraces specific option is added
Performance of loading data with TUniLoader in Direct mode is improved
Bug with reconnecting to the server is fixed
Bug with connecting after a server connection failure is fixed
Bug with performing a TLS 1.2 handshake during connection attempt to the server is fixed
Bug with getting the value of the RETURN_VALUE parameter from SP is fixed
Bug with the "Function is not linked" error when connecting to the server on iOS is fixed

MySQL data provider

Bug with TMyDump when the TMyDump.Options.FieldsAsString = True is fixed
Bug with an empty error message when invoking the TMyQuery.Prepare method is fixed
Bug with handling comments in a SQL statement is fixed

PostgreSQL data provider

Bug with an incorrect value of the RowsAffected property when executing an INSERT ... RETURNING statement is fixed
Bug with AV on closing an application that uses the Alerter component is fixed
Bug with executing a query which has a param of type date is fixed

InterBase data provider

Bug with the incorrect default value of the TField.Required property for columns of type DOUBLE PRECISION is fixed
Bug with assertion failure when changing BLOB fields with the CacheBlobs property set to False is fixed
Bug with using ftFMTBCD datatype params in batch operations is fixed
Bug with loading Memo fields in TUniLoader is fixed

SQLite data provider

Bug with opening a query containing aggregate fields with the SmartFetch property set to True is fixed

DBF data provider

Bug with using the CHRTRAN and DELETED functions in index expressions is fixed
Bug with executing an ALTER TABLE statement is fixed
Bug with executing an UPDATE statement is fixed
Bug with deleting a record is fixed

ASE data provider

Performance of loading data with TUniLoader in Direct mode is improved

Redshift data provider

Bug with reading a newly inserted record within the explicitly started transaction is fixed

Users of Guests are not allowed to comment this publication.