DevArt UniDAC v8.4.1 Pro for Delphi 2006/2007/XE/XE2/10.2 Tokyo
DevArt UniDAC v8.4.1 Pro for Delphi 2006/2007/XE/XE2/10.2 Tokyo
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.4.1 02-Mar-21
RAD Studio 10.4.2 Sydney is supported
macOS 11 Big Sur is supported
iOS 14 is supported
Android 11 is supported
Performance of batch operations is improved
Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
The UseUnicode option in the VirtualQuery component is added
Bug with setting the ReadOnly field property at runtime is fixed
Bug with editing a source dataset after opening TVirtualQuery is fixed
Bug with updting a dataset with fields which contain international characters is fixed
Bug with editing a dataset which acts as a data source for the VirtualQuery component is fixed
Bug with processing a WHERE clause is fixed
Oracle data provider
Oracle 21c is supported
The PrefetchRows option in the Direct mode is supported
Data fetch performance in the Direct mode is improved
LOB read/write performance is improved
Bug with connection to RAC servers in the Direct mode is fixed
Bug with calling a stored procedure using dblink is fixed
Bug with parsing a quoted schema name is fixed
SQLServer data provider
LOB read/write performance in the Direct mode is improved
Bug with 'Range check error' in the Direct mode is fixed
Bug with getting the list of server names is fixed
Bug with string data getting truncated in TUniLoader is fixed
Bug with "Session ID is not found" when starting a transaction in the Direct mode is fixed
Bug with "c0000091 FLOAT_OVERFLOW" when fetching records in SQL Server Compact Edition is fixed
Bug with describing date params in the Direct mode is fixed
Bug with rounding DATE values is fixed
MySQL data provider
Bug with the 'TableName cannot be empty' assertion when opening a query is fixed
Bug with dumping DOUBLE fields in the TUniDump component when UseUnicode set to True is fixed
Bug with processing data that includes international characters on Linux is fixed
Bug with AV failure when using OpenSSL 1.1 libraries is fixed
Bug with getting parameters for a procedure or function in MySQL 5.0.45 is fixed
PostgreSQL data provider
PostgreSQL 13 is supported
Work in a multi-threaded environment through a single connection is supported
The MultipleConnections option in the Connection component is added
Bug with AV failure when using OpenSSL 1.1 libraries is fixed
Bug with an incorrect value of the RowsAffected property when executing an INSERT ... RETURNING statement is fixed
Bug with the "Unexpected server response" error when executing a "SELECT FROM ..." statement is fixed
Bug with AV when executing a batch operation via the SQL component is fixed
Bug with incorrect encoding of error messages is fixed
Bug with reading BLOBs on mobile platforms using Protocol 2 is fixed
InterBase data provider
Over-the-Wire (OTW) encryption is supported
Automatic detection of computed fields when generating update statements is improved
Memory consumption in batch operations is reduced
Bug with "Unavailable database" when using Local protocol is fixed
Bug in TUniDump with backing up boolean fields in Firebird 3
Bugs with handling computed fields in editable view are fixed
Bug with TUniAlerter in 64-bit applications is fixed
SQLite data provider
The LockingMode specific option in the Connection component is added
The Synchronous specific option in the Connection component is added
The JournalMode specific option in the Connection component is added
Performance with default values of the new options is significantly improved
Bug with an outdated version of the SQLite engine on the Android 64-bit platform is fixed
ASE data provider
The TextSize specific option is added
Bug with getting the client's hostname is fixed
DBF data provider
The IgnoreIndexErrors specific option in the Connection component is added
Performance of reading and writing MEMO and BLOB values is improved
Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved
Bugs with handling fields of type MEMO, BLOB, BINARY and VARBINARY are fixed
Bug with invalid type of argument for the UPPER function is fixed
Bug with AV when an index expression is empty is fixed
Bug with duplicate values in a unique index is fixed
Bug with processing a WHERE clause is fixed
Bug with the TRANSFORM function is fixed
Bug with updating BLOB fields is fixed
Bug with the TTOC function is fixed
Bug with native indexes is fixed
MongoDB data provider
Bug with incorrect query results when using DATETIME fields in a WHERE clause is fixed
Bug with the DescribeAmount option is fixed
ODBC data provider
Data fetch performance is improved
LOB read/write performance is improved
RAD Studio 10.4.2 Sydney is supported
macOS 11 Big Sur is supported
iOS 14 is supported
Android 11 is supported
Performance of batch operations is improved
Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
The UseUnicode option in the VirtualQuery component is added
Bug with setting the ReadOnly field property at runtime is fixed
Bug with editing a source dataset after opening TVirtualQuery is fixed
Bug with updting a dataset with fields which contain international characters is fixed
Bug with editing a dataset which acts as a data source for the VirtualQuery component is fixed
Bug with processing a WHERE clause is fixed
Oracle data provider
Oracle 21c is supported
The PrefetchRows option in the Direct mode is supported
Data fetch performance in the Direct mode is improved
LOB read/write performance is improved
Bug with connection to RAC servers in the Direct mode is fixed
Bug with calling a stored procedure using dblink is fixed
Bug with parsing a quoted schema name is fixed
SQLServer data provider
LOB read/write performance in the Direct mode is improved
Bug with 'Range check error' in the Direct mode is fixed
Bug with getting the list of server names is fixed
Bug with string data getting truncated in TUniLoader is fixed
Bug with "Session ID is not found" when starting a transaction in the Direct mode is fixed
Bug with "c0000091 FLOAT_OVERFLOW" when fetching records in SQL Server Compact Edition is fixed
Bug with describing date params in the Direct mode is fixed
Bug with rounding DATE values is fixed
MySQL data provider
Bug with the 'TableName cannot be empty' assertion when opening a query is fixed
Bug with dumping DOUBLE fields in the TUniDump component when UseUnicode set to True is fixed
Bug with processing data that includes international characters on Linux is fixed
Bug with AV failure when using OpenSSL 1.1 libraries is fixed
Bug with getting parameters for a procedure or function in MySQL 5.0.45 is fixed
PostgreSQL data provider
PostgreSQL 13 is supported
Work in a multi-threaded environment through a single connection is supported
The MultipleConnections option in the Connection component is added
Bug with AV failure when using OpenSSL 1.1 libraries is fixed
Bug with an incorrect value of the RowsAffected property when executing an INSERT ... RETURNING statement is fixed
Bug with the "Unexpected server response" error when executing a "SELECT FROM ..." statement is fixed
Bug with AV when executing a batch operation via the SQL component is fixed
Bug with incorrect encoding of error messages is fixed
Bug with reading BLOBs on mobile platforms using Protocol 2 is fixed
InterBase data provider
Over-the-Wire (OTW) encryption is supported
Automatic detection of computed fields when generating update statements is improved
Memory consumption in batch operations is reduced
Bug with "Unavailable database" when using Local protocol is fixed
Bug in TUniDump with backing up boolean fields in Firebird 3
Bugs with handling computed fields in editable view are fixed
Bug with TUniAlerter in 64-bit applications is fixed
SQLite data provider
The LockingMode specific option in the Connection component is added
The Synchronous specific option in the Connection component is added
The JournalMode specific option in the Connection component is added
Performance with default values of the new options is significantly improved
Bug with an outdated version of the SQLite engine on the Android 64-bit platform is fixed
ASE data provider
The TextSize specific option is added
Bug with getting the client's hostname is fixed
DBF data provider
The IgnoreIndexErrors specific option in the Connection component is added
Performance of reading and writing MEMO and BLOB values is improved
Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved
Bugs with handling fields of type MEMO, BLOB, BINARY and VARBINARY are fixed
Bug with invalid type of argument for the UPPER function is fixed
Bug with AV when an index expression is empty is fixed
Bug with duplicate values in a unique index is fixed
Bug with processing a WHERE clause is fixed
Bug with the TRANSFORM function is fixed
Bug with updating BLOB fields is fixed
Bug with the TTOC function is fixed
Bug with native indexes is fixed
MongoDB data provider
Bug with incorrect query results when using DATETIME fields in a WHERE clause is fixed
Bug with the DescribeAmount option is fixed
ODBC data provider
Data fetch performance is improved
LOB read/write performance is improved