VI

Delphi

Devart UniDAC v10.2.0 Professional for Delphi 7 - 12 Athens

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...

Description

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.

10.2.0 24-Apr-24

Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Added voResetAutoInc in the VirtualTable component that allows to reset AutoInc values on Clear
Fixed bug in VirtualQuery with querying source datasets that contain NULL column values

Oracle data provider

Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
Fixed bug with string value truncation when ConvertEOL=True for Oracle 11 or lower
Fixed bug with Connection Pooling in the Direct mode

SQLServer data provider

Microsoft Entra Service Principal authentication (auADServicePrincipal) in the prMSOLEDB provider is supported
Fixed bug with Microsoft Entra identity authentication (auADInteractive) in the prMSOLEDB provider
Fixed bug with updating datetime fields by OLEDB providers
Fixed bug with a zero-valued LastInsertID result

MySQL data provider

Fixed bug with incorrect executing of internal Rollback

PostgreSQL data provider

Improved work with generated fields
Fixed bug with processing identity field

Redshift data provider

Fixed bug with reading real fields

InterBase data provider

Fixed bug with incorrect results when using the RETURNING clause
Fixed bug with an error message about bad timezone ID

NexusDB data provider

Improved the Locate and FindKey methods' execution when using ServerCursor
Fixed bug with Access Violation when using Server Cursor and IndexFieldNames

SQLite data provider

Now the Direct mode is based on version 3.45.2 of the SQLite engine
Added support for automatic detection of transaction state when the transaction is controlled by an SQL statement
Fixed bug with using the SQLCiper library

DBF data provider

Fixed a bug with adding a blank record to the resultset
Fixed bug with opening tables whose field names contain characters after the line terminator

Access data provider

Fixed bug with sequential connection to a database
Fixed bug with the "Range check error" exception when querying a table
Fixed bug with incorrect RecordCount property value when FetchAll is set to True

BigCommerce data provider

Added metadata cache

Dynamics data provider

Added metadata cache

HubSpot data provider

Added metadata cache

Magento data provider

Added metadata cache

NetSuite data provider

Added metadata cache

NetSuite data provider

Added metadata cache

Salesforce data provider

Added metadata cache

Salesforce Salesforce Marcketing Cloud data provider

Added metadata cache

SugarCRM data provider

Added metadata cache

ZohoCRM data provider

Added metadata cache

Additional Information