Universal Data Access Components

3.00.0.7 04-Mar-10

Ability to use Access system database added
Added DetectFieldsOnPrepare parameter for NexusDB ODBC driver
Added ability to send call stack information to the dbMonitor component
Fixed bug with refreshing record when using master/detail relationship
Fixed bug with LocalUpdate in the CachedUpdates mode
Fixed bug with displaying nvarchar2 fields when UseUnicode is true
Fixed bug with getting IndexFieldNames list in design time
Fixed several bugs with getting information about SQLite database using the TUniMetadata component
Fixed bug with processing TableInfo for SQLite
Fixed bug with DBMonitor for C++ Builder 6

3.00.0.6 26-Jan-10

Added OnStart, OnCommit, OnRollback events to TDATransaction
Fixed problem with using TLargeintField in master/detail
Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmPessimistic
Fixed bug with setting labels caption of TUniConnectDialog when LabelSet = lsCustom
Fixed bug with setting EOF when FetchAll=False in the PostgreSQL provider
Fixed bug with processing TIME fields for SQL Server 2008

3.00.0.5 01-Dec-09

Added TUniAlerter component
Added support for dbMonitor 3
Fixed bug with updating table, that has field name, representing a valid hexadecimal number
Fixed bug with updating field value with preceding spaces when TrimFixedChar or TrimVarChar = True
Fixed bug with executing large file in UTF-8 format
Fixed bug with AssignConnect in the ODBC-based providers

3.00.0.4 12-Nov-09

Now Required flag is set for UpdatingTable fields only
Fixed bug with detecting parameter size for MBCS strings
Fixed problem with detecting slash with text after it as a delimiter in TDAScript
Fixed bug with SetOrderBy and SetWhere when there is no space before ORDER or WHERE
Fixed bug with executing large file in Unicode format
Added support for XML data type in the SQL Server provider
Fixed bug with fetching fields that come after BLOB fields in the ODBC-based providers
Fixed bug with parsing table name in the ASE provider

3.00.0.3 13-Oct-09

Now setting the SetFieldsReadOnly option to False makes all fields not readonly
Now the AssignConnect method copies transaction state
Fixed bug with locating records using the LocateEx method and the lxNearest option
Fixed bug with AV failure in MemData
Fixed bug with SQL Generator in design-time
Fixed problem with help registration under RAD Studio 2010
Fixed problem with loading DataSet Manager under RAD Studio 2010
Fixed problem with providers registration under RAD Studio 2010
Added support for GUID data type in the ODBC-based providers
Added support for autoincrement fields in the Access, Advantage, and DB2 providers
Added the ServerTypes specific option for the Advantage provider
Added support for *.accdb databases in the Access provider
Fixed error on connect under Windows Vista / 7 in the Access provider

3.00.0.2 10-Sep-09

Embarcadero RAD Studio 2010 suppored
DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and other databases (using ODBC provider) support added
Now the subdetail is refreshed before the AfterRefresh event of the detail is called
ConnectionTimeout is now used when resolving the host name

2.70.0.11 01-Sep-09

Added support for Unified SQL in the FilterSQL property of TCustomUniDataSet
Now the value from the master dataset has priority over the DefaultExpression value
Fixed bug with not unlocking record in the CachedUpdates mode if no fields were changed
Fixed bug with parsing TDAScript.Statements
Fixed bug with RefreshQuick for query with fields that have similar names in several tables
Fixed bug with parsing literal ':' as parameter in the Oracle provider
Fixed bug with converting EOL for LONG RAW fields in the Oracle provider
Added support for using different client libraries simultaneously in the InterBase provider
Added DescribeParams specific option for the InterBase provider
Added support for automatic starting a transaction when FetchAll=False in the PostgreSQL provider
Fixed bug with FetchAll=False and inline comment at the end of SQL in the PostgreSQL
Added the EmbeddedParams connection option for the MySQL provider
Fixed bug with UseUnicode ignored for TEXT fields in the SQLite provider

2.70.0.9 24-Jun-09

Fixed bug with local sorting in CachedUpdates mode
Fixed bug with raising exceptions on locating records when IndexFieldNames is set
Fixed bug with calculating connection count in Disconnected mode
Fixed bug with calling the OnError event on connection failure when Pooling is enabled
Fixed bug with macros in TDAScript
Fixed bug with database name containing multibyte characters in the InterBase provider
Fixed problem with default values with leading blanks in the InterBase provider
Fixed problem with QueryRecCount option and FROM keyword inside a field list in the InterBase provider
Fixed incorrect authentification and disconnect messages in the PostgreSQL provider
Fixed bug with restoring after the error on operations with large object in the PostgreSQL provider

2.70.0.8 27-May-09

SQLite support added
Added the Disconnected property to TCustomDADataSet
Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
Fixed bug with the GotoCurrent method
Fixed bug with LocalMasterDetail and Prepare method
Fixed bug with FullRefresh and macros
Fixed bug with PSInTransaction returning True when no transaction is explicitly started (InterBase provider)
Fixed bug with TUniStoredProc not alowing data editing for the SQL Server provider
Fixed bug with Unified SQL and stored procedure call for the SQL Server provider
Added the UseParamTypes specific option for the PostgreSQL provider
Fixed bug with not closing portal for prepared statements in the PostgreSQL provider
Added support for TQuery.DataSource property in BDE Migration Wizard

2.50.0.6 02-Apr-09

Unified SQL support
Unified SQL allows to write truly database-independent SQL code. Unified SQL includes:

Macros - in Unified SQL macros can evaluate to a different value depending on the provider used by the TUniConnection component.

If - for the purpose of extra flexibility Unified SQL supports conditional inclusion of SQL code into resulting statements. This allows to set different SQL for different DBMS.

Functions - introduce standard for calling common SQL functions. In run time function is transformed either to the corresponding native function, or to an equivalent expression.

Literal - provides universal syntax for date, time, and timestamp literals.
TUniLoader component
serves for fast loading of data to the database. For each type of database server TUniLoader uses its specific interfaces for loading with maximum speed. For example, Oracle Direct Path Load interface is used for Oracle.
TUniDump component
serves to store data from tables or editable views as a script and to restore data from a received script.
TUniConnection.AssignConnect method
shares physical connection between several TUniConnection components
Added support for Free Pascal under Linux
Added NoPreconnect property to TUniScript for executing CONNECT and CREATE DATABASE commands
Added DMLRefresh support in the PostgreSQL provider
Fixed bug with DetailDelay and refreshing closed dataset
Fixed bug with detecting DBMonitor on 64-bit Windows
Fixed bug with not calling UnregisterClient for internal command of dataset
Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate
Fixed bug with executing ApplyUpdates when LockMode=lmOptimistic in the CachedUpdates mode for the SQL Server and MySQL providers

2.00.0.4 26-Feb-09

Fixed bug with not working CachedUpdates in TVirtualTable
Fixed bug with suppressing errors in TVirtualTable.LoadFromFile
Fixed problem with restoring current row after refresh
Fixed bug when statements, executed on TClientDataSet.ApplyUpdates, were not shown in DBMonitor
Fixed access violation on the TClientDataSet.ApplyUpdates call
Avoided bug in Delphi 2006 and above with the BcdCompare function
Added Unicode support for NVARCHAR fields in the Direct mode of the Oracle provider
Fixed bug with character set used for SQL statements in the Direct mode of the Oracle provider
Fixed bug with decoding Unicode surrogate pairs in the InterBase provider
Fixed bug with field names starting with RET_ in the InterBase provider
Fixed bug with not executing prepared statement for the second time in the PostgreSQL provider
Fixed memory leak in the UniDirectional mode in the PostgreSQL provider
Fixed bug with detecting read-only fields when ExtendedFieldsInfo=False in the PostgreSQL provider
Fixed bug with reading large objects with size more than 64 Kb in the PostgreSQL provider

2.00.0.3 06-Jan-09

Fixed bug with treating some string elements as equal by CompareString
Fixed several bugs in the PostgreSQL provider

2.00.0.2 09-Dec-08

PostgreSQL support added
Added UseWideMemos specific option of TUniConnection to the SQL Server provider
Fixed bug with changing values of ptUnknown parameters on Execute
Fixed bug for Delphi 2009 with updating varchar fields which contain Unicode symbols
Fixed bug with ftSmallint fields in the Direct mode of the Oracle provider

1.20.0.13 19-Nov-08

Fixed bug with field names containing '.'
Fixed bug with assertion failure on editing components in design time for Delphi 5
Fixed several bugs in DataSet Manager
Fixed bug in Migration Wizard with converting binary forms in Delphi 2009
Added calling the TfrxReport.OnBeforeConnect event when TfrxDACDatabase is connecting
Fixed bug with name compatibility with ReportBuilder

1.20.0.12 23-Oct-08

Delphi 2009 and C++Builder 2009 supported
Extended Unicode support for Delphi 2007 added (special Unicode build)
Free Pascal 2.2 supported
Powerful design-time editors implemented in Lazarus
Completed with more comprehensive structured Help

1.00.0.10 22-Sep-08

Improved working with master/detail relationship when LocalMasterDetail=True
Fixed bug with access violation on getting OldValue for BLOB fields
Fixed bug with ConvertEOL option for string parameters
Fixed bug with mapping empty strings to NULL in string fields
Fixed bug with default character set used in the Direct mode for Chinese in the Oracle provider
Fixed bug with the IsNull property for output string parameters in the InterBase provider
Fixed bug with parsing RETURNING clause in the InterBase provider

1.00.0.8 21-Aug-08

Added support for CREATE DATABASE, DROP DATABASE, CONNECT, SET statements in TUniScript for the InterBase provider
Access violation on calling TClientDataSet.ApplyUpdates fixed
Fixed memory leak with TIMESTAMP fields in the Oracle provider
Fixed bug with the DeferredLobRead option in the Unicode mode in the Oracle provider
Fixed bug with adding #0 to the end of Unicode BLOB values in the InterBase provider
Fixed bug with Unicode string output parameters in the InterBase provider

1.00.0.7 11-Jul-08

Added support of NOT LIKE keyword in the TDataSet.Filter property
Added ability to recognize unquoted True/False values in DefaultExpression
Improved working with master/detail on inserting new records
Fixed bug with autocommit after deleting records
Fixed several bugs when working with inactive datasets
Fixed bug with filtering by TLargeIntField
Fixed bug with calling the OnError event when LocalFailover is set to True
Fixed bug with exception class in the TUniConnection.OnError event
Fixed bug with the Prepare method and string parameters in Oracle provider
Fixed bug with not using UpdateTransaction for TClientDataSet.ApplyUpdates in InterBase provider
Added ability to call Code Editor from component editors

1.00.0.6 11-Jun-08

Fixed bug with the SetOrderBy method
Fixed bug with AV failure on assigning the OnFilterRecord event handler
Fixed bug with determining primary key fields
Fixed bug with generating update SQL with IS NULL in the WHERE clause at design-time
Fixed bug with IsQuery property not reseting on SQL changing in Oracle provider
Fixed bug with calculated ftDate and ftTime fields in Oracle provider
Fixed bug with size of ftWideString parameters in Oracle provider
Fixed bug with ptUnknown parameter values loss after execute in InterBase provider

1.00.0.5 23-May-08

Added ability to get LastInsertId for MySQL
Added BooleanDomainFields specific option for InterBase
Improved work with master/detail
Fixed bug with not freeing parameter objects on disconnect
Fixed bug with updating data in TClientDataSet
Fixed bug with parsing specific option values containing points
Fixed bug with interpreting empty string parameters as NULL by InterBase provider
Fixed bug with the QueryRecCount option and inline comment at the end of SQL statement in Oracle provider

1.00.0.4 23-Apr-08

The first release of UniDAC