Universal Data Access Components (UniDAC) 9.4.0

Released: Mar 17, 2023

9.4.0 での更新項目

機能

  • Added support for Embarcadero RAD Studio 11 Alexandria Release 3.
  • Added support for Apple iOS Simulator target platform.
  • Added support for Lazarus 2.2.6.
  • Added support for YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter.
  • Added support for mathematical operations in TDADataSet.Filter.
  • Added support for Aggregate Fields and InternalCalc Fields.
  • Added the ability to restore from file with TEncoding via the Dump component.
  • Improved the execution of statements that have either IS NULL or IS NOT NULL in the WHERE clause with TVirtualQuery.
  • The SetRange will now function according to the case sensitivity of keywords in IndexFieldNames.

Oracle data provider

  • Improved detection of home directories in recent versions of Oracle.
  • A valid exception will now be raised instead of AV when memory can't be allocated for the large row count.

Microsoft SQL Server data provider

  • Improved compatibility with Linked Server in Microsoft SQL Server Management Studio (SSMS).
  • Improved the GetOrderBy method behavior.

PostgreSQL data provider

  • Added support for PostgreSQL 15.
  • Improved process of getting extended fields info.

InterBase data provider

  • Improved working with aliases.

SQLite data provider

  • Added support for GUID fields stored in binary format.
  • Improved reading fields of the BLOB family.

DBF data provider

  • Improved ROUND() function.

NexusDB data provider

  • Added support for NexusDB 4.70.01.
  • Added support for working with tables protected by a password.

ODBC data provider

  • Added the UuidWithBraces specific option for the Connection component.

MongoDB data provider

  • Added support for MongoDB Atlas.
  • Added support for DNS Seed List connection format.

不具合の修正

  • Fixed bug with AV on using master/detail relationship with VirtualTable.
  • Fixed bug with loading data that already has persistent fields into VirtualTable.

Oracle data provider

  • Fixed bug with LOBs reading in the Direct mode.
  • Fixed bug with reading BFLOAT and BDOUBLE values from ANYDATA.
  • Fixed bug with querying record count if SQL statement contains PIVOT.

SQL Server data provider

  • Fixed bug with Unicode (UTF-8) in the Direct mode for Windows.
  • Fixed bug with an assertion failure in the CachedUpdate mode.
  • Fixed bug with connecting to default instance by prSQL(SQLOLEDB.1) provider.
  • Fixed bug with fetching datetimeoffset fields in the Direct mode.
  • Fixed bug with fetching sql_variant fields in the Direct mode.
  • Fixed bug with preparing a stored procedure in the Direct mode.

MySQL data provider

  • Fixed bug with BLOBs for MySQL version below 4.1.
  • Fixed bug with BIGINT UNSIGNED key fields in version 4.1 or higher.
  • Fixed bug with BIT field default values.

PostgreSQL data provider

  • Fixed bug with extra connections in GetType methods.
  • Fixed bug with TIMESTAMPTZ fields.
  • Fixed bug with reading fields of type REAL using the Auto protocol.
  • Fixed bug with writing Bytea type in Batch operations.
  • Fixed bug with using "ON CONFLICT RETURNING" in batch operations.
  • Fixed problem with handling fields of type REAL.
  • Fixed bug with the "Range Check Error" exception when reading BLOB data.

InterBase data provider

  • Fixed bug with "The SQL statement is not allowable for a bulk operation" when using SP in batch operations.
  • Fixed bug with "Validation error" when using the Loader component.

DBF data provider

  • Fixed bug with a field name case when creating a table.

Microsoft Access data provider

  • Fixed bug with "Cannot modify a read-only dataset".

MongoDB data provider

  • Fixed bug with reading international characters when UseUnicode option is set.