Devart Forums

We're excited to announce support for the new RAD Studio 10.4.2 Sydney in UniDAC. Additionally, we supported macOS Big Sur, iOS 14, and Android 11.

What's new in this release:

• RAD Studio 10.4.2 Sydney is supported
• macOS 11 Big Sur is supported
• iOS 14 is supported
• Android 11 is supported
• Performance of batch operations is improved
• Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
• The UseUnicode option in the VirtualQuery component is added
• Bug with setting the ReadOnly field property at runtime is fixed
• Bug with editing a source dataset after opening TVirtualQuery is fixed
• Bug with updting a dataset with fields which contain international characters is fixed
• Bug with editing a dataset which acts as a data source for the VirtualQuery component is fixed
• Bug with processing a WHERE clause is fixed

Oracle data provider

• Oracle 21c is supported
• The PrefetchRows option in the Direct mode is supported
• Data fetch performance in the Direct mode is improved
• LOB read/write performance is improved
• Bug with connection to RAC servers in the Direct mode is fixed
• Bug with calling a stored procedure using dblink is fixed
• Bug with parsing a quoted schema name is fixed

SQLServer data provider

• LOB read/write performance in the Direct mode is improved
• Bug with 'Range check error' in the Direct mode is fixed
• Bug with getting the list of server names is fixed
• Bug with string data getting truncated in TUniLoader is fixed
• Bug with "Session ID is not found" when starting a transaction in the Direct mode is fixed
• Bug with "c0000091 FLOAT_OVERFLOW" when fetching records in SQL Server Compact Edition is fixed
• Bug with describing date params in the Direct mode is fixed
• Bug with rounding DATE values is fixed

MySQL data provider

• Bug with the 'TableName cannot be empty' assertion when opening a query is fixed
• Bug with dumping DOUBLE fields in the TUniDump component when UseUnicode set to True is fixed
• Bug with processing data that includes international characters on Linux is fixed
• Bug with AV failure when using OpenSSL 1.1 libraries is fixed
• Bug with getting parameters for a procedure or function in MySQL 5.0.45 is fixed

PostgreSQL data provider

• PostgreSQL 13 is supported
• Work in a multi-threaded environment through a single connection is supported
• The MultipleConnections option in the Connection component is added
• Bug with AV failure when using OpenSSL 1.1 libraries is fixed
• Bug with an incorrect value of the RowsAffected property when executing an INSERT ... RETURNING statement is fixed
• Bug with the "Unexpected server response" error when executing a "SELECT FROM ..." statement is fixed
• Bug with AV when executing a batch operation via the SQL component is fixed
• Bug with incorrect encoding of error messages is fixed
• Bug with reading BLOBs on mobile platforms using Protocol 2 is fixed

InterBase data provider

• Over-the-Wire (OTW) encryption is supported
• Automatic detection of computed fields when generating update statements is improved
• Memory consumption in batch operations is reduced
• Bug with "Unavailable database" when using Local protocol is fixed
• Bug in TUniDump with backing up boolean fields in Firebird 3
• Bugs with handling computed fields in editable view are fixed
• Bug with TUniAlerter in 64-bit applications is fixed

SQLite data provider

• The LockingMode specific option in the Connection component is added
• The Synchronous specific option in the Connection component is added
• The JournalMode specific option in the Connection component is added
• Performance with default values of the new options is significantly improved
• Bug with an outdated version of the SQLite engine on the Android 64-bit platform is fixed

ASE data provider

• The TextSize specific option is added
• Bug with getting the client's hostname is fixed

DBF data provider

• The IgnoreIndexErrors specific option in the Connection component is added
• Performance of reading and writing MEMO and BLOB values is improved
• Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved
• Bugs with handling fields of type MEMO, BLOB, BINARY and VARBINARY are fixed
• Bug with invalid type of argument for the UPPER function is fixed
• Bug with AV when an index expression is empty is fixed
• Bug with duplicate values in a unique index is fixed
• Bug with processing a WHERE clause is fixed
• Bug with the TRANSFORM function is fixed
• Bug with updating BLOB fields is fixed
• Bug with the TTOC function is fixed
• Bug with native indexes is fixed

MongoDB data provider

• Bug with incorrect query results when using DATETIME fields in a WHERE clause is fixed
• Bug with the DescribeAmount option is fixed

ODBC data provider

• Data fetch performance is improved
• LOB read/write performance is improved

Devart Development Team
https://www.devart.com/unidac/

UniDAC build 8.4.2 is available for download.

In this version:

• Lazarus 2.0.12 is supported
• Bug with the ConvertEOL connection option is fixed
• Bug with AV in applications using DBMonitor is fixed
• Bug with committing a transaction when LockMode = lmPessimistic is fixed
• Bug with getting values of calculated fields is fixed

Oracle data provider

• Bug with parameters that have Unknown data type on Prepare is fixed
• Bug with calling stored procedures when AutoCommit=False is fixed
• Bug with parameters for Oracle 19c in the Direct mode is fixed
• Bug with NUMBER fields when EnableFMTBCD=True is fixed

SQLServer data provider

• Bug with the data type mapping of varbinary fields is fixed

MySQL data provider

• Bug with the "Prepared statement contains too many placeholders" error in batch operations is fixed

PostgreSQL data provider

• Several bugs with the MultipleConnection option are fixed
• Several bugs with ProtocolVersion = pvAuto are fixed
• Bug with LockMode = lmPessimistic is fixed

InterBase data provider

• The default value of the BooleanDomainFields specific option reverted to True

NexusDB data provider

• NexusDB 4.50.26 is supported

UniDAC build 8.4.3 is available for download.

In this version:

• Demo compatibility with new a version of SecureBridge is fixed
• Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

Oracle data provider

• Bug with an Invalid pointer operation on Fetch is fixed

SQLServer data provider

• Bug a string parameter getting trimmed is fixed

PostgreSQL data provider

• Bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True is fixed
• Bug with reading server messages is fixed

• InterBase data provider

• Bug with loading BLOB columns as strings using the Loader component is fixed

SQLite data provider

• JournalMode = jmDefault specific option value for the Connection component is added
• Bug with mapping the liteNull database type to the ftBLOB field type is fixed

UniDAC build 8.4.4 is available for download.

In this version:

• Support for TFieldOptions is added
• Bug with applying both Encryption and Data Type Mapping on a BLOB column is fixed
• Bug with AV after adding the Lookup field to a prepared DataSet is fixed
• Bug with the Locate method on ftLongWord fields is fixed
• Bug with AV in the TVirtualTable.Assign method is fixed
• Bug with AV when executing a DELETE FROM statement using TVirtualQuery is fixed
• Bug with corrupted data of a GUID field in TVirtualDataSet is fixed
• Bug with universal quoting of identifiers is fixed

Oracle data provider

• Bug with refreshing a table that contains several key fields is fixed
• Bug with precision when converting Double to NUMBER in the Direct mode is fixed
• Bug with string parameters for Oracle 12.2 in the Direct mode is fixed
• Bug with CLOB when UnicodeEnvironment=True is fixed

SQLServer data provider

• Retrieving Indexes metadata for OLE DB providers is improved
• Bug with processing transactions in TUniLoader is fixed
• Bug with a Range check error when fetching more than 255 columns is fixed
• Bug with 'Unknown datatype (24)' when creating a dump is fixed

PostgreSQL data provider

• Bug with executing a stored procedure when ProtocolVersion = pvAuto is fixed
• Bug with executing a "SELECT FROM ..." statement is fixed
• Bug with a "Range check error" exception when executing a statement with parameters is fixed
• Bug with AV when executing a "SET ROLE ..." statement is fixed
• Bug with updating a table that has a Serial field is fixed
• Bug with handling statement parameters of the ftUnknown data type is fixed

InterBase data provider

• Bug with transaction handling when using a stored procedure is fixed
• Bug with processing VARCHAR fields with a size greater than 255 is fixed
• Bug with setting a TimeStamp field value as a string is fixed

DBF data provider

• The UseFileCodepage specific option in the Connection component is added