Devart Universal Data Access Components (UniDAC) v9.3.0 Full Source Code
Devart Universal Data Access Components (UniDAC) v9.3.0 Full Source Code
Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Lazarus (Free Pascal). We have combined the experience of long-term successful development into one product, which provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).
UniDAC offers unified approach to the database-related applications development process. That means you can switch easily between different databases in your projects without going deep into their specifics.
Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC gives outstanding flexibility and independence to your projects.
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. All operations with data are performed by providers automatically considering the selected database server peculiarities.
Cross-Platform Solution for Delphi, C++Builder, and Lazarus
UniDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both x86 and x64 platforms. UniDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.
Server-Independent SQL
When developing database applications that allow working with several databases, one of the key points is writing of server-independent SQL. In UniDAC, the server-independent SQL support is implemented by means of the powerful macros engine, that produces dynamic SQL by replacing parts of the query statements with user-defined code.
9.3.0 12-Sep-22
•Added support for RAD Studio 11 Alexandria Release 2
•Added support for Lazarus 2.2.2
•Added support for iOS 15
•Added support for Android 12
•Added the CloneCursor method for Query and Table components that allows sharing data between datasets
•Added support of standard collations in a SQL statement in the VirtualQuery component
•Improved the performance of exporting to XML
•Fixed bug when a connection string parameter value contains a single quote
SQLServer data provider
•Added support for Microsoft OLE DB Driver for SQL Server 9
•Added support for Azure AD authentication support for the Microsoft OLE DB provider
•Added support for Always On availability group in the Direct mode
•Added support for connection to the Azure database by using the "Redirect" connection policy in the Direct mode
•Fixed bug with restricting the list of procedures using PROCEDURE_TYPE condition in Metadata component
•Fixed bug with committing transaction on SQL Server 2000 in Direct mode
MySQL data provider
•Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption
•Fixed bug with truncation of milliseconds of DateTime fields in the Dump component
•Fixed bug with posting calculated field
PostgreSQL data provider
•Added support for PostGIS
•Improved TimeZoneOffset support for TPgTimeStamp
•Improved the Truncate method of the TPgLargeObject class is improved
•Fixed bug with executing a SELECT statement via the Execute method of the Query component
•Fixed bug with the Ping method of the Connection component when the MultipleConnections specific option is set to False
•Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields
•Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format
•Fixed bug with international characters in error messages
InterBase data provider
•Improved support for TIME/TIMESTAMP WITH TIME ZONE data types
•Added support for EXTENDED TIME/TIMESTAMP WITH TIME ZONE data types
•Added support for working with time zone data types when clients don't have the ICU library
•Added support for The isc_dpb_session_time_zone, isc_dpb_set_bind, isc_dpb_decfloat_round, and isc_dpb_decfloat_traps DPB
•Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using "UPDATE OR INSERT" batch operations
•Fixed bug with using CAST in the SQL statement when UseUnicode set to True
•Fixed bug with reading GUID data of stored procedure in using the AsGuid property
•Fixed bug with processing GUID data in using in parameter
•Fixed bug with working with the transaction when LockMode <> lmNone
•Fixed bug with using the TUniAlerter component in WebBroker applications
•Fixed bug with "Invalid variant type" error when the DMLRefresh property is set to True
SQLite data provider
•Now the Direct mode is based on version 3.39.2 of the SQLite engine
•Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type
•Fixed bug with mapping table columns of integer types to string fields
DBF data provider
•Added support for VisualFoxPro CANDIDATE indexes
NexusDB data provider
•Added support for NexusDB 4.60.01
•Added option to set Remote Thread Priority
MS Access data provider
•Fixed bug with processing UUID fields
•Added support for RAD Studio 11 Alexandria Release 2
•Added support for Lazarus 2.2.2
•Added support for iOS 15
•Added support for Android 12
•Added the CloneCursor method for Query and Table components that allows sharing data between datasets
•Added support of standard collations in a SQL statement in the VirtualQuery component
•Improved the performance of exporting to XML
•Fixed bug when a connection string parameter value contains a single quote
SQLServer data provider
•Added support for Microsoft OLE DB Driver for SQL Server 9
•Added support for Azure AD authentication support for the Microsoft OLE DB provider
•Added support for Always On availability group in the Direct mode
•Added support for connection to the Azure database by using the "Redirect" connection policy in the Direct mode
•Fixed bug with restricting the list of procedures using PROCEDURE_TYPE condition in Metadata component
•Fixed bug with committing transaction on SQL Server 2000 in Direct mode
MySQL data provider
•Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption
•Fixed bug with truncation of milliseconds of DateTime fields in the Dump component
•Fixed bug with posting calculated field
PostgreSQL data provider
•Added support for PostGIS
•Improved TimeZoneOffset support for TPgTimeStamp
•Improved the Truncate method of the TPgLargeObject class is improved
•Fixed bug with executing a SELECT statement via the Execute method of the Query component
•Fixed bug with the Ping method of the Connection component when the MultipleConnections specific option is set to False
•Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields
•Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format
•Fixed bug with international characters in error messages
InterBase data provider
•Improved support for TIME/TIMESTAMP WITH TIME ZONE data types
•Added support for EXTENDED TIME/TIMESTAMP WITH TIME ZONE data types
•Added support for working with time zone data types when clients don't have the ICU library
•Added support for The isc_dpb_session_time_zone, isc_dpb_set_bind, isc_dpb_decfloat_round, and isc_dpb_decfloat_traps DPB
•Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using "UPDATE OR INSERT" batch operations
•Fixed bug with using CAST in the SQL statement when UseUnicode set to True
•Fixed bug with reading GUID data of stored procedure in using the AsGuid property
•Fixed bug with processing GUID data in using in parameter
•Fixed bug with working with the transaction when LockMode <> lmNone
•Fixed bug with using the TUniAlerter component in WebBroker applications
•Fixed bug with "Invalid variant type" error when the DMLRefresh property is set to True
SQLite data provider
•Now the Direct mode is based on version 3.39.2 of the SQLite engine
•Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type
•Fixed bug with mapping table columns of integer types to string fields
DBF data provider
•Added support for VisualFoxPro CANDIDATE indexes
NexusDB data provider
•Added support for NexusDB 4.60.01
•Added option to set Remote Thread Priority
MS Access data provider
•Fixed bug with processing UUID fields
Only for V.I.P
Warning! You are not allowed to view this text.