data conversion - Universal Data Access Components (UniDAC)

Notes de publication : to itself. Fixed bug with incorrect results of a SELECT statement with WHERE on a character field. Fixed bug with data conversion when using YEAR, MONTH, and DAY functions. MongoDB data provider Fixed bug ... 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 ...

Notes de publication : 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 ...

Description : Une bibliothèque de composants qui offre un accès direct à plusieurs bases de données Delphi et 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 ... ensures the best way 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 ...

Notes de publication : 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 ...

Spécifications : Android   Data Access Components       Base components Script Executing Transactions managing Fast data loading into the server   Database Specific Components       Messaging between sessions and ... 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   ...

Licensing Fact Sheet:   ...

Notes de publication : 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. ...

Notes de publication : 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 ...

Notes de publication : 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 ...

Notes de publication : 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 ...

Notes de publication : 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. ...

Notes de publication : 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 ...

Notes de publication : 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. ...

Notes de publication : 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 ...

Compatibilité : Supported Target Platforms Windows, 32-bit and 64-bit macOS, 32-bit and 64-bit (Professional Edition only) iOS, 32-bit and 64-bit (Professional Edition only) Android, 32-bit and 64-bit (Professional Edition only) Linux, 32-bit (only in Lazarus and Free Pascal) and 64-bit (Professional Edition only) ...

Notes de publication : 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) ...

Notes de publication : 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 ...

Prix : Universal Data Access Components (UniDAC) V10.1.x- New Perpetual Licenses- Standard All new licenses include a free subscription that includes support and access to any product upgrades and releases ... Data Access Components (UniDAC) V10.1.x- New Perpetual Licenses- Professional All new licenses include a free subscription that includes support and access to any product upgrades and releases 1 ... Developer License- with 1 Year Subscription Réf. Editeur: 300254965 Notre numéro de Référence: 518408-1479837 1 Developer License Upgrade from Standard- Retains Existing Subscription Expiry Date Réf. Editeur: ...

License : ...