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
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
Only for V.I.P Warning! You are not allowed to view this text.