data storage - Universal Data Access Components (UniDAC)

Release Notes: Added support for Lazarus 3.0. Oracle data provider Added support for connecting to servers with enabled Security Banners in the Direct mode. Improved error message about a non-existent database ... object in another schema. PostgreSQL data provider Improved working with column default values. Improved working with RefreshRecord queries. Improved working with arrays in queries. InterBase data provider ... Added support for Firebird 5. Added support for multiple rows being returned by DML with the RETURNING clause. Improved compatibility with Apple macOS Sonoma. SQLite data provider The RealAsDouble option ...

Release Notes: component. Added support for storing 'AutoInc' fields when saving 'TVirtualTable' to XML. Oracle data provider Added support for Oracle 23c. Improved 'UnicodeEnvironment' support ... for non-Unicode Embarcadero Delphi versions. SQLServer data provider Added support for Microsoft SQL Server 2022. Added support for 'LastInsertID'. Added 'DisableConstraints' option to the Dump ... component. Added 'AddDateTimeFormat' option to the Dump component. MySQL data provider Added support for MariaDB 11. Added support for the 'mysql_clear_password' authentication mechanism. ...

Release Notes: 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 ...

Release Notes: 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 ... using the 'Redirect' connection policy in Direct mode. PostgreSQL data provider Added support for PostGIS. Improved 'TimeZoneOffset' support for 'TPgTimeStamp'. Improved ...

Description: A library of components that provides direct access to multiple databases from Delphi and C++Builder. Universal Data Access Components (UniDAC) is a library of components that provides direct access ... to multiple databases from Delphi and C++Builder, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. Universal Data Access Components (UniDAC) ... to perform operations on the server. Server-Aware Providers- UniDAC chooses the best way specific to the server to perform most operations. Every UniDAC data provider uses server-specific native connectivity. ...

Release Notes: Adds support for Embarcadero RAD Studio 11.1 Alexandria and Lazarus 2.2.0. Added support for Embarcadero RAD Studio 11.1 Alexandria. Added support for Lazarus 2.2.0. Added support for Microsoft Windows 11. Added support for Apple macOS Monterey. Fixed bug with executing batch operations with the ...

Release Notes: Adds PoolId connection option along with support for PostgreSQL 14. Added PoolId connection option. PostgreSQL data provider Added support for PostgreSQL 14. Added stored procedure OUT parameters ... in PostgreSQL 14. InterBase data provider Added CutOffParams global variable. Added WireCompression option to the Connection component. Fields of type dtFloat are now created for system types INT128, DECFLOAT, ... and large NUMERIC by default. NexusDB data provider Block fetch is now supported. Improved fetch performance. DBF data provider FSIZE SQL function is now supported. Autoinc data type for dfVisualFoxPro tables ...

Release Notes: with duplicate records when navigating through TVirtualDataSet for which a filter is set. Fixed bug with persistent fields when saving and then reading data from file to TVirtualTable. Fixed bug with setting ... a DateTime value before the year 1800 to TTimeField. Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component. Fixed bug with memory leak on Locate by field with data type ...

Release Notes: Adds support for TFieldOptions. Added support for TFieldOptions. Fixed bug with applying both Encryption and Data Type Mapping on a BLOB column. Fixed bug with AV after adding the Lookup field ... Fixed bug with corrupted data of a GUID field in TVirtualDataSet. Fixed bug with universal quoting of identifiers. ...

Release Notes: SQLite data provider JournalMode- Added jmDefault option value for the Connection component. Demo compatibility with new a version of SecureBridge has been fixed. Fixed bug with assigning a BLOB ... parameter when the source data is loaded via the TParam.LoadFromStream method. Oracle data provider Fixed bug with an Invalid pointer operation on Fetch. SQLServer data provider Fixed bug a string parameter ... getting trimmed. PostgreSQL data provider Fixed bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True. Fixed bug with reading server messages. InterBase data ...

Release Notes: Adds support for Lazarus 2.0.12. Added support for Lazarus 2.0.12. Fixed a bug with the ConvertEOL connection option. Fixed a bug with AV in applications using DBMonitor. Fixed a bug with committing a transaction when LockMode = lmPessimistic. Fixed a bug with getting values of calculated fields. ...

Release Notes: for Android 11. Improved batch operation performance. Improved performance of the FindFirst, FindNext, FindLast and FindPrior methods. Added UseUnicode option to the VirtualQuery component. Oracle data provider ... Added support for Oracle 21c. Added support for the PrefetchRows option in Direct mode. Improved data fetch performance in Direct mode. Improved LOB read/write performance. SQL Server data provider ... Improved LOB read/write performance in Direct mode. PostgreSQL data provider Added support for PostgreSQL 13. Added support for working in a multi-threaded environment through a single connection. Added ...

Release Notes: Release 1 is now required for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney and C++Builder 10.4 Sydney. Fixed the incompatibility of DatasetManager with RAD Studio 10.4 Release 1. SQLServer data ... provider Fixed a bug with the "Wrong amount of parameters 4 in TableName" error when retrieving data from a linked server. Fixed a bug with an assertion failure when manually creating parameters. ... MySQL data provider Fixed a bug with values getting cut off after calling the SHOW CREATE FUNCTION statement for MySQL 5.0.x. (MySQL provider) ...

Release Notes: Update and Delete operations. Oracle data provider Added support for Oracle 20c. Added support for connection via SSL protocol. Added support for connection via SSH protocol. Added support for connection ... via HTTP tunnel. SQL Server data provider Added support for Microsoft SQL Server 2019. DBF data provider Added support for native dBase functions in a SQL statement. ODBC data provider Improved ... the retrieval of error messages from the SQL Anywhere ODBC driver. Fixed a bug with using special characters in a username or password. Fixed a bug with the "Out of memory" error when retrieving data ...

Specification: Android   Data Access Components       Base components Script Executing Transactions managing Fast data loading into the server   Database Specific Components       Messaging between sessions ... connection dialog Data encryption and decryption Data storing in memory table Dataset that wraps arbitrary non-tabular data Advanced DBGrid with extended functionality Records transferring between datasets   ...

Release Notes: Oracle data provider- Fixed bug describing sorted procedure parameters. ...

Licensing Fact Sheet:   ...

Release Notes: Adds support for RAD Studio 10.4 Sydney. Added support for RAD Studio 10.4 Sydney. Added support for Lazarus 2.0.8. Added support for macOS 64-bit in Lazarus. ...

Customer Review: 5 Korea, Republic Of ...

Release Notes: Improves performance of TMSLoader when loading data in Direct mode. Microsoft SQL Server data provider Added UuidWithBraces option. Improved performance of TMSLoader when loading data in Direct ... mode. ASE data provider Improved performance of TMSLoader when loading data in Direct mode. Fixed bug installing different editions of two or more DACs in a single system. Fixed bug with SQL statements ... a new TDACondition. Fixed bug reading a field value using the AsBytes method in Lazarus. Fixed bug using constraints after calling the Refresh method. Oracle data provider Fixed bug fetching data ...