Universal Data Access Components (UniDAC) 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.