Devart UniDAC v8.2.5 Professional for Delphi 7/Berlin/Rio/Sydney
Devart UniDAC v8.2.5 Professional for Delphi 7/Berlin/Rio/Sydney
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.2.5 09-Jun-20
Oracle data provider
Bug with describing sorted procedure parameters is fixed
8.2.4 01-Jun-20
RAD Studio 10.4 Sydney is supported
Lazarus 2.0.8 is supported
macOS 64-bit in Lazarus is supported
Bug with data loss in the column of type ftLargeint in the VirtualTable component in Lazarus is fixed
Bug with locating a record by a fixed string column in the Chinese locale is fixed
Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed
Oracle data provider
Mapping the FLOAT Oracle data type to the ftNumber field is added
Bug with SELECT RowId using Database Link in Direct mode is fixed
Bug with retrieving implicit result sets after calling the Execute method is fixed
Bug with retrieving unchanged parameter values in the Direct mode is fixed
Bug with SQL statements containing a JAVA clause in TUniScript is fixed
Bug with Charset when Pooling is enabled is fixed
SQLServer data provider
Bug with setting a value for the TrustServerCertificate option is fixed
Bug with switching databases in Direct mode is fixed
MySQL data provider
Bug with an invalid refresh query for calculated fields if the roBeforeEdit option is set is fixed
PostgreSQL data provider
The Line geometric type is supported
Bug with the Dump component in PostgreSQL 12 is fixed
Bug with reading zero-valued geometric fields as nulls is fixed
InterBase data provider
Bug with an incorrect value in the DBSQLDialect property is fixed
Bug with using a case-sensitive Role name is fixed
DBF data provider
The AllFieldsAsNullable specific option is added
Bug with indexes containing date fields is fixed
Bug with VisualFoxPro indexes containing double fields is fixed
Bug with using tables whose fields match SQL keywords is fixed
Bug with JOIN on fields that have NULL values is fixed
Bug with table file locking after executing UPDATE with ConnectMode = cmUnsafe is fixed
Bug with an application hanging when trying to reopen a table with ConnectMode = cmExclusive is fixed
NexusDB data provider
Support for the Pipe protocol is added
Support for the Secure Pipe protocol is added
Support for the Secure TCP protocol is added
Now an #INMEM alias is created automatically when it is specified in the Database property
MongoDB data provider
Bug with connecting to a database that contains documents with a huge amount of fields is fixed
ODBC data provider
Bug with scale when reading a NUMERIC column as the ftFloat field is fixed
MS Access data provider
Bug with obtaining metadata in Delphi 7 is fixed
BigCommerce data provider
Bug with connection is fixed
Dynamics CRM data provider
Bug with connection is fixed
FreshBooks data provider
Bug with connection is fixed
Magento data provider
Bug with connection is fixed
MailChimp data provider
Bug with connection is fixed
NetSuite data provider
Bug with connection is fixed
QuickBooks data provider
Bug with connection is fixed
Salesforce data provider
Bug with connection is fixed
Salesforce MC data provider
Bug with connection is fixed
SugarCRM data provider
Bug with connection is fixed
Zoho CRM data provider
Bug with connection is fixed
Oracle data provider
Bug with describing sorted procedure parameters is fixed
8.2.4 01-Jun-20
RAD Studio 10.4 Sydney is supported
Lazarus 2.0.8 is supported
macOS 64-bit in Lazarus is supported
Bug with data loss in the column of type ftLargeint in the VirtualTable component in Lazarus is fixed
Bug with locating a record by a fixed string column in the Chinese locale is fixed
Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed
Oracle data provider
Mapping the FLOAT Oracle data type to the ftNumber field is added
Bug with SELECT RowId using Database Link in Direct mode is fixed
Bug with retrieving implicit result sets after calling the Execute method is fixed
Bug with retrieving unchanged parameter values in the Direct mode is fixed
Bug with SQL statements containing a JAVA clause in TUniScript is fixed
Bug with Charset when Pooling is enabled is fixed
SQLServer data provider
Bug with setting a value for the TrustServerCertificate option is fixed
Bug with switching databases in Direct mode is fixed
MySQL data provider
Bug with an invalid refresh query for calculated fields if the roBeforeEdit option is set is fixed
PostgreSQL data provider
The Line geometric type is supported
Bug with the Dump component in PostgreSQL 12 is fixed
Bug with reading zero-valued geometric fields as nulls is fixed
InterBase data provider
Bug with an incorrect value in the DBSQLDialect property is fixed
Bug with using a case-sensitive Role name is fixed
DBF data provider
The AllFieldsAsNullable specific option is added
Bug with indexes containing date fields is fixed
Bug with VisualFoxPro indexes containing double fields is fixed
Bug with using tables whose fields match SQL keywords is fixed
Bug with JOIN on fields that have NULL values is fixed
Bug with table file locking after executing UPDATE with ConnectMode = cmUnsafe is fixed
Bug with an application hanging when trying to reopen a table with ConnectMode = cmExclusive is fixed
NexusDB data provider
Support for the Pipe protocol is added
Support for the Secure Pipe protocol is added
Support for the Secure TCP protocol is added
Now an #INMEM alias is created automatically when it is specified in the Database property
MongoDB data provider
Bug with connecting to a database that contains documents with a huge amount of fields is fixed
ODBC data provider
Bug with scale when reading a NUMERIC column as the ftFloat field is fixed
MS Access data provider
Bug with obtaining metadata in Delphi 7 is fixed
BigCommerce data provider
Bug with connection is fixed
Dynamics CRM data provider
Bug with connection is fixed
FreshBooks data provider
Bug with connection is fixed
Magento data provider
Bug with connection is fixed
MailChimp data provider
Bug with connection is fixed
NetSuite data provider
Bug with connection is fixed
QuickBooks data provider
Bug with connection is fixed
Salesforce data provider
Bug with connection is fixed
Salesforce MC data provider
Bug with connection is fixed
SugarCRM data provider
Bug with connection is fixed
Zoho CRM data provider
Bug with connection is fixed
Only for V.I.P Warning! You are not allowed to view this text.