Released: Sep 29, 2017

7.1.4 での更新項目

機能

• 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.

不具合の修正

• 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.