Devart UniDAC Standard 7.3.10 for D10.2 Tokyo
Devart UniDAC Standard 7.3.10 for D10.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.
7.3.10 17-Sep-18
Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
Support for SpecificOptions in FastReport components is added
Now the SetRange method supports Null values
The enumerated property FieldOrigins is added
The Boolean property FieldsOrigin is deprecated
Bug with AV when using custom constraints is fixed
Bug with using FilterSQL in the SmartFetch mode is fixed
Bug with editing data in TVirtualQuery having TVirtualTable as a source is fixed
Bug with mapping an error when a query contains functions like SUM is fixed
Bug with freezing an application when a query contains UNION ALL is fixed
Bug with updating data in TVirtualQuery is fixed
Bug with editing data in TVirtualQuery when the SELECT statement contains the ROWID column is fixed
Several bugs with handling BLOBs in TVirtualQuery are fixed
Oracle data provider
Bug with reading LOB data in Oracle 12 is fixed
Bug with the RawAsString option in the Direct mode is fixed
Bug with the MERGE statement in the Direct mode is fixed
Bug with memory leak when SQL statement contains trailing ";" is fixed
SQLServer data provider
Support for Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is added
Support for connecting to SQL Server using a server alias in Direct mode is added
Bug with Runtime error 231 when getting a lot of database errors in one statement under Windows x64 is fixed
Bug with getting a list of key fields for SQL Server Compact Edition is fixed
Bug with "Windows Authentication is not supported under non Windows environment" when connecting to a database on Android is fixed
Bug with application freezing when using NonBlocking in the Direct mode is fixed
MySQL data provider
Bug with filling default values in MariaDB 10.2.7 and higher for Delphi 7 and older is fixed
InterBase data provider
Bug with assertion failure when using BLOB data type in batch operations is fixed
PostgreSQL data provider
Bug with reading large double values from NUMERIC fields is fixed
SQLite data provider
Bug with reading DATETIME field values that have milliseconds is fixed
ASE data provider
Bug with locking a record is fixed
DBF data provider
Possibility to explicitly specify a database file format is added
Bug with reading fields having a space (null) as a value is fixed
Bug with opening tables having field names equal to SQL keywords is fixed
Bug with using the DTOC function in index expressions is fixed
Bug with using fields that have null values in conditional expressions is fixed
Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
Support for SpecificOptions in FastReport components is added
Now the SetRange method supports Null values
The enumerated property FieldOrigins is added
The Boolean property FieldsOrigin is deprecated
Bug with AV when using custom constraints is fixed
Bug with using FilterSQL in the SmartFetch mode is fixed
Bug with editing data in TVirtualQuery having TVirtualTable as a source is fixed
Bug with mapping an error when a query contains functions like SUM is fixed
Bug with freezing an application when a query contains UNION ALL is fixed
Bug with updating data in TVirtualQuery is fixed
Bug with editing data in TVirtualQuery when the SELECT statement contains the ROWID column is fixed
Several bugs with handling BLOBs in TVirtualQuery are fixed
Oracle data provider
Bug with reading LOB data in Oracle 12 is fixed
Bug with the RawAsString option in the Direct mode is fixed
Bug with the MERGE statement in the Direct mode is fixed
Bug with memory leak when SQL statement contains trailing ";" is fixed
SQLServer data provider
Support for Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is added
Support for connecting to SQL Server using a server alias in Direct mode is added
Bug with Runtime error 231 when getting a lot of database errors in one statement under Windows x64 is fixed
Bug with getting a list of key fields for SQL Server Compact Edition is fixed
Bug with "Windows Authentication is not supported under non Windows environment" when connecting to a database on Android is fixed
Bug with application freezing when using NonBlocking in the Direct mode is fixed
MySQL data provider
Bug with filling default values in MariaDB 10.2.7 and higher for Delphi 7 and older is fixed
InterBase data provider
Bug with assertion failure when using BLOB data type in batch operations is fixed
PostgreSQL data provider
Bug with reading large double values from NUMERIC fields is fixed
SQLite data provider
Bug with reading DATETIME field values that have milliseconds is fixed
ASE data provider
Bug with locking a record is fixed
DBF data provider
Possibility to explicitly specify a database file format is added
Bug with reading fields having a space (null) as a value is fixed
Bug with opening tables having field names equal to SQL keywords is fixed
Bug with using the DTOC function in index expressions is fixed
Bug with using fields that have null values in conditional expressions is fixed
Only for V.I.P Warning! You are not allowed to view this text.