Universal Data Access Components (UniDAC) V7.1.4

New Cloud providers allow you to work with data stored in popular Cloud services.
October 10, 2017
New Version

Features

  • Significantly improved performance of TVirtualQuery.
  • Added support for application-defined functions and collations in TVirtualQuery.
  • Support AutoInc fields in TVirtualTable.
  • New Cloud data providers: BigCommerce, Dynamics, FreshBooks, Magento, MailChimp, NetSuite, QuickBooks, Salesforce, Salesforce Marketing Cloud, SugarCRM and Zoho CRM.

Oracle data provider

  • Added support for Oracle 12c connection modes (SYSBACKUP, SYSDG, SYSKM) in Direct mode.
  • Added support for OS authentication in Direct mode.
  • NChar literal replacement is supported
  • improved CLOB parameters behavior when UnicodeEnvironment=True.

MySQL data provider

  • Added support for Azure Database for MySQL
  • Added support for JSON data type.

InterBase data provider

  • Added support for Firebird on Android.
  • Added support for Firebird 3 packages
  • Added support for alias handling in the RETURNING clause.
  • Added support for WireCompression connection parameter for Firebird 3.

PostgreSQL data provider

  • Added support for SSPI authentication.
  • Improved processing of GUID data types in the TGuidField class.

SQLite data provider

  • Direct mode is now based on SQLite engine version 3.20.0.
  • Added support for custom SQL aggregate functions.

DBF data provider

  • Added CodePage specific options.
  • Added ConnectMode specific options.

DB2 data provider

  • Added support for DECFLOAT data type.

Fixes

  • Fixed "Input parameter mismatch" error.
  • Fixed bug with transactions when working with Firebird 2.5.
  • Fixed bug with assertion failure when updating a record in TVirtualQuery.
  • Fixed bug with compatibility with TkbmMemTable in TVirtualQuery.
  • Fixed bug in complex WHERE clauses that have several string fields in TVirtualQuery.
  • Fixed bug selecting from a dataset with a single record in TVirtualQuery.
  • Fixed bug generating SQL for batch updates.
  • Fixed bug with Locate method for non-Windows platforms in Lazarus.
  • Fixed bug with FindFirst, FindLast, FindNext, FindPrior methods in Lazarus.
  • Fixed bug accessing product help from the IDE menu.
  • Fixed bug recreating fields when calling Open after Prepare.
  • Fixed bug with an incorrect error message when using the Connect dialog component on mobile platforms.
  • Fixed bug with AV failure when using calculated fields in TClientDataset.
  • Fixed a key violation error when executing batch operations.
  • Fixed bug with Assert when calling the Locate method in SmartFetch mode.
  • Fixed bug using DAC components in DataModule for Linux.
Universal Data Access Components (UniDAC) V7.1.4
Universal Data Access Components (UniDAC)

Universal Data Access Components (UniDAC)

A library of components that provides direct access to multiple databases from Delphi and C++Builder.

Get Quote Buy Now

Got a Question?

Live Chat with our Devart licensing specialists now.