Released: Sep 12, 2022

9.3.0 中的更新

特性

• Added support for Embarcadero RAD Studio 11 Alexandria Release 2.
• Added support for Lazarus 2.2.2.
• Added support for Apple iOS 15.
• Added support for Android 12.
• Query and Table components add 'CloneCursor' method which allows you to share data between datasets.
• VirtualQuery component adds support for standard collations in SQL statements.
• Improved performance when exporting to XML.

Microsoft SQL Server data provider

• Added support for Microsoft OLE DB Driver in Microsoft SQL Server 9.
• Added support for Microsoft Azure Active Directory authentication support for the Microsoft OLE DB provider.
• Added support for 'Always On' availability group in Direct mode.
• Added support for connecting to Azure databases using the 'Redirect' connection policy in Direct mode.

PostgreSQL data provider

• Added support for PostGIS.
• Improved 'TimeZoneOffset' support for 'TPgTimeStamp'.
• Improved 'Truncate' method in 'TPgLargeObject' class.

InterBase data provider

• Added support for EXTENDED TIME/TIMESTAMP WITH TIME ZONE data types.
• Improved support for TIME/TIMESTAMP WITH TIME ZONE data types.
• Added support for working with time zone data types when clients don't have ICU library.
• Added support for the 'isc_dpb_session_time_zone', 'isc_dpb_set_bind', 'isc_dpb_decfloat_round' and 'isc_dpb_decfloat_traps' DPB.

SQLite data provider

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

DBF data provider

• Added support for VisualFoxPro CANDIDATE indexes.

NexusDB data provider

• Added support for NexusDB 4.60.01.
• Added the option to set Remote Thread Priority.

修补程序

• Fixed bug when a connection string parameter value contains a single quote.

SQLServer data provider

• Fixed bug with restricting the list of procedures using PROCEDURE_TYPE condition in Metadata component.
• Fixed bug with committing transaction on SQL Server 2000 in Direct mode.

MySQL data provider

• Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption.
• Fixed bug with truncation of milliseconds of DateTime fields in the Dump component.
• Fixed bug with posting calculated field.

PostgreSQL data provider

• Fixed bug with executing a SELECT statement via the Execute method of the Query component.
• Fixed bug with the Ping method of the Connection component when the MultipleConnections property is set to False.
• Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields.
• Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format.
• Fixed bug with international characters in error messages.

InterBase data provider

• Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using "UPDATE OR INSERT" batch operations.
• Fixed bug with using CAST in the SQL statement when UseUnicode set to True.
• Fixed bug with reading GUID data of stored procedure in using the AsGuid property.
• Fixed bug with processing GUID data in using in parameter.
• Fixed bug with working with the transaction when LockMode <> lmNone.
• Fixed bug with using the TUniAlerter component in WebBroker applications.
• Fixed bug with "Invalid variant type" error when the DMLRefresh property is set to True.

SQLite data provider

• Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type.
• Fixed bug with mapping table columns of integer types to string fields.

Microsoft Access data provider

• Fixed bug with processing UUID fields.