Devart UniDAC v9.1.1 Professional Full Source for D7/CB6 - RS11 Alexandria
Devart UniDAC v9.1.1 Professional Full Source for D7/CB6 - RS11 Alexandria
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.1.1 09-Dec-21
The PoolId connection pool option is added
Fixed bug with freezing multiply connection pools in threads
Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
Fixed bug with using the AsDate property when working with fields of the ftDate type
Fixed bug with updating the state of records at applying cached updates
Fixed bug with resetting the specific params
Oracle data provider
Fixed bug with LONG parameters in Oracle 11 and earlier
Fixed bug with UnicodeEnvironment in pooling
SQLServer data provider
Fixed bug with setting the port number to the Server property in Direct mode
Fixed bug with Varchar(max) and Text OUT parameters in Direct mode
Fixed bug with describing string params in the Direct mode
MySQL data provider
Fixed bug with an "Unknown column" error when adding record when RefreshOption = roAfterInsert
PostgreSQL data provider
PostgreSQL 14 is supported
OUT parameters in stored procedures for PostgreSQL 14 are supported
Fixed bug with Access Violation on RefreshRecord after connection switching
Fixed bug with application name when connection pooling is used
Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations
Fixed bug with processing large OID values
InterBase data provider
The CutOffParams global variable is added
The WireCompression option for the Connection component is added
Now, fields of type dtFloat are created for system types INT128, DECFLOAT, and large NUMERIC by default
Fixed bug with insertion of a string and binary values when UseUnicode set to True
Fixed bug with an incorrect encoding of table alias names
Fixed bug with using the AutoDDL property for TUniScript
Fixed bug with value exceeds the range for valid timestamps when using AsDateTime property
Fixed bug with Access Violation when DescribeParams is True and using the AsBytes property
Fixed bug with setting the value of type UInt64 using the Value parameter property
Fixed bug with inserting a Byte value using the Value parameter property
Fixed bug with setting the numeric value of the parameter via AsString for TUniStoredProc
Fixed bug with setting the Connection String
SQLite data provider
Fixed bug with memory leak when using the julianday() SQL-function in Direct mode
NexusDB data provider
Block fetch is supported
Fetch performance is improved
DBF data provider
FSIZE SQL function is supported
Autoinc data type for dfVisualFoxPro tables is supported
Fixed bug with reading logical fields which contains "Y"/"N" values
Fixed bug with "Invalid field data" when setting a value that exceeds the character field size
ODBC data provider
Fixed bug with "Range check error" when the field size is greater than MaxInt
Fixed bug with "Invalid precision value" for dtMemo fields
Fixed bug with processing UUID fields
The PoolId connection pool option is added
Fixed bug with freezing multiply connection pools in threads
Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
Fixed bug with using the AsDate property when working with fields of the ftDate type
Fixed bug with updating the state of records at applying cached updates
Fixed bug with resetting the specific params
Oracle data provider
Fixed bug with LONG parameters in Oracle 11 and earlier
Fixed bug with UnicodeEnvironment in pooling
SQLServer data provider
Fixed bug with setting the port number to the Server property in Direct mode
Fixed bug with Varchar(max) and Text OUT parameters in Direct mode
Fixed bug with describing string params in the Direct mode
MySQL data provider
Fixed bug with an "Unknown column" error when adding record when RefreshOption = roAfterInsert
PostgreSQL data provider
PostgreSQL 14 is supported
OUT parameters in stored procedures for PostgreSQL 14 are supported
Fixed bug with Access Violation on RefreshRecord after connection switching
Fixed bug with application name when connection pooling is used
Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations
Fixed bug with processing large OID values
InterBase data provider
The CutOffParams global variable is added
The WireCompression option for the Connection component is added
Now, fields of type dtFloat are created for system types INT128, DECFLOAT, and large NUMERIC by default
Fixed bug with insertion of a string and binary values when UseUnicode set to True
Fixed bug with an incorrect encoding of table alias names
Fixed bug with using the AutoDDL property for TUniScript
Fixed bug with value exceeds the range for valid timestamps when using AsDateTime property
Fixed bug with Access Violation when DescribeParams is True and using the AsBytes property
Fixed bug with setting the value of type UInt64 using the Value parameter property
Fixed bug with inserting a Byte value using the Value parameter property
Fixed bug with setting the numeric value of the parameter via AsString for TUniStoredProc
Fixed bug with setting the Connection String
SQLite data provider
Fixed bug with memory leak when using the julianday() SQL-function in Direct mode
NexusDB data provider
Block fetch is supported
Fetch performance is improved
DBF data provider
FSIZE SQL function is supported
Autoinc data type for dfVisualFoxPro tables is supported
Fixed bug with reading logical fields which contains "Y"/"N" values
Fixed bug with "Invalid field data" when setting a value that exceeds the character field size
ODBC data provider
Fixed bug with "Range check error" when the field size is greater than MaxInt
Fixed bug with "Invalid precision value" for dtMemo fields
Fixed bug with processing UUID fields