Devart UniDAC Pro 7.2.5 for D7-D10.2 Tokyo
Devart UniDAC Pro 7.2.5 for D7-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.2.5 18-Jan-18
Lazarus 1.8 and FPC 3.0.4 are supported
Support for custom constraints is added
The UseBlankValues property for the Loader component is added
Bug with script parsing in TDAScript is fixed
Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
Bug with assertion failure when using the OnFilterRecord event handler is fixed
Bug with AutoInc fields in TVirtualTable is fixed
Bug with AV in TVirtualDataSet when editing Blob is fixed
Bug with a WHERE clause with a string field in TVirtualQuery is fixed
Bug with using a query with JOIN as a source dataset for TVirtualQuery is fixed
Bug with multiple LIKE in a WHERE clause for TVirtualQuery is fixed
Bug with re-execution of DML statements in TVirtualQuery is fixed
Bug with querying MS SQL Server source datasets is fixed
Redshift data provider
Amazon Redshift provider is added
Oracle data provider
Bug with TIMESTAMP(0) format is fixed
Bug with LOB prefetch when UseUnicode=True is fixed
Bug with fields order in TClientDataSet when using TOraProvider is fixed
Bug when key fields are not reset in TUniTable is fixed
SQLServer data provider
Windows authentication in the Direct mode is supported
Bug with memory leak in the Direct mode when UniDirectional is True is fixed
Bug with AV failure on processing widestring parameter of large size is fixed
MySQL data provider
Support for backup/restore of triggers and stored procedures is added
Bug with filling default values when TDADataSetOptions.DefaultValues = True for MariaDB 10.2.7 and higher is fixed
Bug with parsing SQL that contains a table name with spaces after the point is fixed
InterBase data provider
Loading of the default client library for 64-bit applications is improved
Bug with memory leak when using BLOB data type in batch operations is fixed
Bug with resetting a previously set parameter value when using DescribeParams is fixed
Bug with backup/restore a database containing national characters in a database path in Firebird 3 is fixed
PostgreSQL data provider
Bug with the FieldDefs.Update method of a dataset when using the protocol version 3.0 is fixed
Bug with mapping jsonb fields is fixed
Bug with reading GUID data on mobile platforms is fixed
Bug with the Locate method work for the TGuidField class is fixed
SQLite data provider
Direct Mode in Lazarus is supported
BIT type is supported
The UnknownAsString dataset specific option that allows mapping fields of unknown type as ftString instead of ftMemo is added
DBF data provider
Direct Mode in Lazarus is supported
The IndexOnReading connection specific option that allows using local indexes on reading data is added
Bug with Access Violation when opening a database from multiple applications is fixed
Bug with CREATE INDEX statement is fixed
DB2 data provider
Compatibility with DB2 version 11 is improved
Lazarus 1.8 and FPC 3.0.4 are supported
Support for custom constraints is added
The UseBlankValues property for the Loader component is added
Bug with script parsing in TDAScript is fixed
Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
Bug with assertion failure when using the OnFilterRecord event handler is fixed
Bug with AutoInc fields in TVirtualTable is fixed
Bug with AV in TVirtualDataSet when editing Blob is fixed
Bug with a WHERE clause with a string field in TVirtualQuery is fixed
Bug with using a query with JOIN as a source dataset for TVirtualQuery is fixed
Bug with multiple LIKE in a WHERE clause for TVirtualQuery is fixed
Bug with re-execution of DML statements in TVirtualQuery is fixed
Bug with querying MS SQL Server source datasets is fixed
Redshift data provider
Amazon Redshift provider is added
Oracle data provider
Bug with TIMESTAMP(0) format is fixed
Bug with LOB prefetch when UseUnicode=True is fixed
Bug with fields order in TClientDataSet when using TOraProvider is fixed
Bug when key fields are not reset in TUniTable is fixed
SQLServer data provider
Windows authentication in the Direct mode is supported
Bug with memory leak in the Direct mode when UniDirectional is True is fixed
Bug with AV failure on processing widestring parameter of large size is fixed
MySQL data provider
Support for backup/restore of triggers and stored procedures is added
Bug with filling default values when TDADataSetOptions.DefaultValues = True for MariaDB 10.2.7 and higher is fixed
Bug with parsing SQL that contains a table name with spaces after the point is fixed
InterBase data provider
Loading of the default client library for 64-bit applications is improved
Bug with memory leak when using BLOB data type in batch operations is fixed
Bug with resetting a previously set parameter value when using DescribeParams is fixed
Bug with backup/restore a database containing national characters in a database path in Firebird 3 is fixed
PostgreSQL data provider
Bug with the FieldDefs.Update method of a dataset when using the protocol version 3.0 is fixed
Bug with mapping jsonb fields is fixed
Bug with reading GUID data on mobile platforms is fixed
Bug with the Locate method work for the TGuidField class is fixed
SQLite data provider
Direct Mode in Lazarus is supported
BIT type is supported
The UnknownAsString dataset specific option that allows mapping fields of unknown type as ftString instead of ftMemo is added
DBF data provider
Direct Mode in Lazarus is supported
The IndexOnReading connection specific option that allows using local indexes on reading data is added
Bug with Access Violation when opening a database from multiple applications is fixed
Bug with CREATE INDEX statement is fixed
DB2 data provider
Compatibility with DB2 version 11 is improved
Only for V.I.P Warning! You are not allowed to view this text.