Devart Forums

Dear users,

Devart team is proud to introduce the new version of Universal Data Access Components for Delphi including such significant features as:

• RAD Studio 10.2 Tokyo is supported
• Linux in RAD Studio 10.2 Tokyo is supported
• Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
• Bug with AV failure in TUniProvider in multi-threading application is fixed
• Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
• Bug with detecting parameters by name in ExecSQLEx is fixed
• Bug with reading Memo as WideMemo is fixed
• Bug with field name quoting in a filter expression is fixed
• Bug with handling parameter values of BLOB type in batch operations is fixed
• Bug with memory leak in TVirtualDataSet is fixed
• Bug with processing LEFT JOIN on text fields in TVirtualQuery is fixed
• Bug with updating records with text primary key in TVirtualQuery is fixed

Oracle data provider

• Oracle Encryption in the Direct mode is supported
• Oracle Data Integrity in the Direct mode is supported
• Oracle Cloud (DBaaS) in the Direct mode is supported
• Oracle 12c authentication in the Direct mode is supported
• SECUREFILE in the Direct mode is supported
• Prefetch LOBs for Oracle 11 and higher is supported
• EDITIONABLE and NONEDITIONABLE clause is supported
• The PrefetchLobSize option is added
• Field size detecting for servers with multi-byte charset when UseUnicode=False is improved
• Now NUMBER data type without fixed scale has precision=39 and scale=39 instead of 38
• Bug with special symbols in password in the Direct mode is fixed
• Bug with write BLOB to SECUREFILE for Oracle XE in the Direct mode is fixed
• Bug with single quote inside double quotes in SQL is fixed
• Bug with resizing DML parameters array is fixed

SQLServer data provider

• Bug with setting IsolationLevel on connection establishing in the Direct mode is fixed
• Bug with detection of field aliases for query with the JOIN statement is fixed

InterBase data provider

• Possibility to manage batch operations using a transaction is added
• Possibility to obtain active transaction number using DBMonitor is added
• Bug with handling the "Database shutdown" error is fixed
• Bug with handling parameters of the Currency type is fixed
• Bug with AV when the number of values of a batch parameter is too large is fixed
• Bug with using batch parameters of Bytes type is fixed
• Bug with setting parameters of a custom transaction in Lazarus is fixed
• Bug with reading BLOBs when the CacheBlobs property is set to False is fixed

PostgreSQL data provider

• Bug with the RefreshRecord method is fixed
• Bug with escaping BLOB data when protocol version 2 is used is fixed
• Bug with executing a stored procedure via the Query component with FetchAll = False is fixed
• Bug with executing a batch operation after changing SQL is fixed
• Bug with international characters in error messages is fixed

SQLite data provider

• Now the Direct mode is based on the SQLite engine version 3.17.0
• Bug with VACUUM command in Direct Mode is fixed
• Bug with query parameters binding is fixed

NexusDB data provider

• Support for using ConnectionString is added
• Support for using the TfmtBCD fields is added
• Support for the SmartFetch mode is improved
• Bug with using DATE, TIME, and TIMESTAMP literals is fixed

MongoDB data provider

• New MongoDB provider is added

DBF data provider

• Direct mode is supported

And many other features are added, you can find their description on the product pages.


You can try the new version here:
UniDAC 7.0 [ Download] [ History]

Devart development team
http://www.devart.com/unidac