New version of UniDAC 7.2 is already released!

[Devart]

Dear users,

Our team is glad to present you UniDAC 7.2 version, which includes the following improvements and features:

• Lazarus 1.8 and FPC 3.0.4 are supported
• Support for custom constraints is added
• The UseBlankValues property for the Loader component is added
• Bug with script parsing in TDAScript is fixed
• Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
• Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
• Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
• Bug with assertion failure when using the OnFilterRecord event handler is fixed
• Bug with AutoInc fields in TVirtualTable is fixed
• Bug with AV in TVirtualDataSet when editing Blob is fixed
• Bug with a WHERE clause with a string field in TVirtualQuery is fixed
• Bug with using a query with JOIN as a source dataset for TVirtualQuery is fixed
• Bug with multiple LIKE in a WHERE clause for TVirtualQuery is fixed
• Bug with re-execution of DML statements in TVirtualQuery is fixed
• Bug with querying MS SQL Server source datasets is fixed

Redshift data provider

• Amazon Redshift provider is added

Oracle data provider

• Bug with TIMESTAMP(0) format is fixed
• Bug with LOB prefetch when UseUnicode=True is fixed
• Bug with fields order in TClientDataSet when using TOraProvider is fixed
• Bug when key fields are not reset in TUniTable is fixed

SQLServer data provider

• Windows authentication in the Direct mode is supported
• Bug with memory leak in the Direct mode when UniDirectional is True is fixed
• Bug with AV failure on processing widestring parameter of large size is fixed

MySQL data provider

• Support for backup/restore of triggers and stored procedures is added
• Bug with filling default values when TDADataSetOptions.DefaultValues = True for MariaDB 10.2.7 and higher is fixed
• Bug with parsing SQL that contains a table name with spaces after the point is fixed

InterBase data provider

• Loading of the default client library for 64-bit applications is improved
• Bug with memory leak when using BLOB data type in batch operations is fixed
• Bug with resetting a previously set parameter value when using DescribeParams is fixed
• Bug with backup/restore a database containing national characters in a database path in Firebird 3 is fixed

PostgreSQL data provider

• Bug with the FieldDefs.Update method of a dataset when using the protocol version 3.0 is fixed
• Bug with mapping jsonb fields is fixed
• Bug with reading GUID data on mobile platforms is fixed
• Bug with the Locate method work for the TGuidField class is fixed

SQLite data provider

• Direct Mode in Lazarus is supported
• BIT type is supported
• The UnknownAsString dataset specific option that allows mapping fields of unknown type as ftString instead of ftMemo is addeded

DBF data provider

• Direct Mode in Lazarus is supported
• The IndexOnReading connection specific option that allows using local indexes on reading data is added
• Bug with Access Violation when opening a database from multiple applications is fixed
• Bug with CREATE INDEX statement is fixed

DB2 data provider

• Compatibility with DB2 version 11 is improved

Devart Development Team
http://devart.com/unidac/