Released: Nov 15, 2023

10.0.0 での更新項目

機能

• Added support for Embarcadero RAD Studio 12 Athens.
• Added support for Apple macOS Sonoma.
• Added support for Apple iOS 17.
• Added support for Android 13.
• Added support for nested macros in SQL queries.
• Added Display Format for Aggregate fields.
• Added support for SHA-2 (SHA-256, SHA-512) in hash encryption algorithms.
• Added support for 'DBMonitor' to the 'VirtualQuery' component.
• Added support for storing 'AutoInc' fields when saving 'TVirtualTable' to XML.

Oracle data provider

• Added support for Oracle 23c.
• Improved 'UnicodeEnvironment' support for non-Unicode Embarcadero Delphi versions.

SQLServer data provider

• Added support for Microsoft SQL Server 2022.
• Added support for 'LastInsertID'.
• Added 'DisableConstraints' option to the Dump component.
• Added 'AddDateTimeFormat' option to the Dump component.

MySQL data provider

• Added support for MariaDB 11.
• Added support for the 'mysql_clear_password' authentication mechanism.

PostgreSQL data provider

• Added support for PostgreSQL 16.
• Added support for PREPARE/EXECUTE commands.
• Added several specific options to the Dump component.

InterBase data provider

• Added support for iOS Simulator ARM 64-bit target platforms.

SQLite data provider

• Direct mode is now based on version 3.42.0 of the SQLite engine.

DBF data provider

• Improves performance of DML operations.
• Added support for CREATE TABLE IF NOT EXISTS and DROP TABLE IF EXISTS statements.
• Added support for the CREATE TABLE AS SELECT statement.

NexusDB data provider

• Added support for NexusDB 4.75.01.

MongoDB data provider

• Added support for MongoDB 7.
• Added support for MongoDB 6.
• Added support for empty database name when establishing connection.
• Improved compatibility with Linked Server in Microsoft SQL Server Management Studio (SSMS).

ODBC data provider

• Information from 'SQLGetInfo' has been added to 'ODBCMetaData'.

不具合の修正

• Fixed bug moving the cursor when using Aggregate fields.
• Fixed bug deleting a record when using Aggregated fields.
• Fixed bug storing empty Aggregates collection in DFM.
• Fixed bug with AV when installing a package in the IDE.
• Fixed bug with AV in the dataset CloneCursor method.
• Fixed bug using Aggregated and InternalCalc fields together.
• Fixed bug with duplicate resource IDs in CBuilder.
• Fixed bug using "NOT Field LIKE" construction in Filter property.
• Fixed bug "Assertion failure" when using TVirtualDataSet.
• Fixed bug reading MySQL fields of type "bigint" to TVirtualQuery.
• Fixed bug with incorrect results in the TVirtualQuery when COLLATE NOCASE is used.
• Fixed memory leak on closing an application after using TVirtualQuery.
• Fixed bug saving/loading fields with Unicode names in the VirtualTable component.
• Fixed bug assigning a VirtualTable component that has persistent fields.
• Fixed bug editing a source dataset after reopening TVirtualQuery.
• Fixed bug inserting BLOBs using TVirtualQuery.

Oracle data provider

• Fixed bug with "Range check error" error on describing FLOAT parameters in Stored Procedure.

SQLServer data provider

• Fixed bug with a zero-valued LastInsertID result.
• Fixed bug connecting to default instance.
• Fixed bug with "Wrong amount of parameters N in TableName" when the TableName contains spaces.
• Fixed bug detecting parameter names.

MySQL data provider

• Fixed bug writing BLOB when using the SJIS charset.
• Fixed bug connecting to MySQL 8 by a user with an empty password using mysql_native_password authentication mechanism.

PostgreSQL data provider

• Fixed bug with an "SSL function is not linked" exception.
• Fixed bug working with schemas in the connection pool.
• Fixed bug adding a condition to the WHERE clause on calling RefreshRecord.
• Fixed bug with SCARM-SHA-256 certificates.

InterBase data provider

• Fixed bug cutting value for VARCHAR columns with length greater than 255 when LongStrings = False and UseUnicode = True.
• Fixed bug with the 'GetDatabaseParameters' assertion when connecting to the server.
• Fixed bug loading Unicode strings by TUniLoader when EnableMemos is True.
• Fixed bug memory leaks in TUniLoader when using BLOB fields.
• Fixed bug with internal transaction handling when executing the Commit method returns an error.
• Fixed bug with insert\update ARRAY fields data.

SQLite data provider

• Fixed bug with incorrect execution of a SQL statement that contains a comment at the end.
• Fixed bug with the ambiguity of "size_t" declaration when compiling in CBuilder.

DBF data provider

• Fixed bug with "DBFData seek error" when reading more than 2147483647 bytes.
• Fixed bug with incorrect results of a SELECT statement with JOIN of a table to itself.
• Fixed bug with incorrect results of a SELECT statement with WHERE on a character field.
• Fixed bug with data conversion when using YEAR, MONTH, and DAY functions.

MongoDB data provider

• Fixed bug with document fields whose name contains quote characters.