Devart UniDAC 9.0.1 Professional for RAD Studio 10.4 Sydney, 11 Alexandria

Devart UniDAC 9.0.1 Professional for RAD Studio 10.4 Sydney, 11 Alexandria
Devart UniDAC 9.0.1 Professional for RAD Studio 10.4 Sydney, 11 Alexandria


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.0.1 13-Sep-21

RAD Studio 11 Alexandria is supported
macOS ARM is supported
Added demo project for FastReport FMX
Fixed bug with duplicate records when navigating through TVirtualDataSet for which a filter is set
Fixed bug with persistent fields when saving and then reading data from file to TVirtualTable
Fixed bug with setting a DateTime value before the year 1800 to TTimeField
Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
Fixed bug with memory leak on Locate by field with data type mapping
Fixed bug with escaping wildcards in the Filter property of the DataSet component

Oracle data provider​

Fixed bug with string OUT parameters in Oracle 12.1

SQLServer data provider​

Fixed bug with using the NonBlocking mode from threads
Fixed bug with Varchar(max), NVarchar(max), Text and NText OUT parameters
Fixed bug with the AV failure when reading the BLOB fields data in Lazarus

MySQL data provider​

Fixed bug with an "Unknown column" error on Post when RefreshOption = roAfterInsert

PostgreSQL data provider​

Fixed bug with processing UUID fields
Fixed bug with processing large OID values
Fixed bug with the incorrect encoding of error messages
Fixed bug with the incorrect RowsAffected result of the WITH ... statement
Fixed bug with error when setting the "0" value for a currency field
Fixed bug with automatic conversion of null values from SQL subqueries to default values
Fixed bug with processing IDENTITY fields in the PgDump component
Fixed bug with CanModify = False in the Table component when opening a temporary table
Fixed bug with using the Dump component with PostgreSQL version 8.1 and earlier
Fixed bug with executing stored procedures in PostgreSQL version 8.1 and earlier
Fixed bug with using batch inserts in PostgreSQL version 8.2 and earlier

InterBase data provider​

Firebird 4 is supported
Fixed bug with executing stored procedures when UseUnicode = True

SQLite data provider​

Added the IntegerAsLargeInt connection specific option
Fixed bug with mapping VARCHAR columns with length greater than 65,535 to fields of type ftString

NexusDB data provider​

NexusDB 4.50.27 is supported

ODBC data provider​

Fixed bug with re-opening a query which has a parameter of type ftWideString
Fixed bug with updating boolean columns in MS Access

ASE data provider​

Fixed bug with passing the ApplicationName and ClientHostName parameters to the server

BigQuery data provider​

Added the BigQuery provider

HubSpot data provider​

Added the HubSpot provider



Information
Users of Guests are not allowed to comment this publication.