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

fixed, UniDAC, provider, Server, database, using, Delphi, server, applications, added, values, Microsoft, statement, contains, reading, Oracle, databases, access, Sybase, Access, fixed, UniDAC, provider, database, Server, using, Delphi, server, added, applications, values, Microsoft, statement, contains, Access, Oracle, databases, access, Sybase, Direct