What's new in Universal Data Access Components 10.2.1
May 2, 2024
- Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
- Fixed internal bug with TSharedObject
New in Universal Data Access Components 10.2.0 (Apr 25, 2024)
- Added support for RAD Studio 12 Athens Release 1
- Added support for Lazarus 3.2
- Added voResetAutoInc in the VirtualTable component that allows to reset AutoInc values on Clear
- Fixed bug in VirtualQuery with querying source datasets that contain NULL column values
- Oracle data provider:
- Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
- Fixed bug with string value truncation when ConvertEOL=True for Oracle 11 or lower
- Fixed bug with Connection Pooling in the Direct mode
- SQLServer data provider:
- Microsoft Entra Service Principal authentication (auADServicePrincipal) in the prMSOLEDB provider is supported
- Fixed bug with Microsoft Entra identity authentication (auADInteractive) in the prMSOLEDB provider
- Fixed bug with updating datetime fields by OLEDB providers
- Fixed bug with a zero-valued LastInsertID result
- MySQL data provider:
- Fixed bug with incorrect executing of internal Rollback
- PostgreSQL data provider:
- Improved work with generated fields
- Fixed bug with processing identity field
- Redshift data provider:
- Fixed bug with reading real fields
- InterBase data provider:
- Fixed bug with incorrect results when using the RETURNING clause
- Fixed bug with an error message about bad timezone ID
- NexusDB data provider:
- Improved the Locate and FindKey methods' execution when using ServerCursor
- Fixed bug with Access Violation when using Server Cursor and IndexFieldNames
- SQLite data provider:
- Now the Direct mode is based on version 3.45.2 of the SQLite engine
- Added support for automatic detection of transaction state when the transaction is controlled by an SQL statement
- Fixed bug with using the SQLCiper library
- DBF data provider:
- Fixed a bug with adding a blank record to the resultset
- Fixed bug with opening tables whose field names contain characters after the line terminator
- Access data provider:
- Fixed bug with sequential connection to a database
- Fixed bug with the "Range check error" exception when querying a table
- Fixed bug with incorrect RecordCount property value when FetchAll is set to True
- BigCommerce data provider:
- Added metadata cache
- Dynamics data provider:
- Added metadata cache
- HubSpot data provider:
- Added metadata cache
- Magento data provider:
- Added metadata cache
- NetSuite data provider:
- Added metadata cache
- NetSuite data provider:
- Added metadata cache
- Salesforce data provider:
- Added metadata cache
- Salesforce Salesforce Marcketing Cloud data provider:
- Added metadata cache
- SugarCRM data provider:
- Added metadata cache
- ZohoCRM data provider:
- Added metadata cache
New in Universal Data Access Components 10.1.0 (Feb 19, 2024)
- Lazarus 3.0 is supported
- Fixed bug with empty field values when insert via the VirtualQuery component
New in Universal Data Access Components 10.0.0 (Nov 15, 2023)
- Added support for RAD Studio 12
- Added support for macOS Sonoma
- Added support for iOS 17
- Added support for Android 13
- Added support for nested Macros in SQL queries
- Added support Display Format for Aggregate fields
- Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
- Added support for DBMonitor in the VirtualQuery component
- Added support for storing AutoInc fields when saving TVirtualTable to XML
- Fixed bug with moving the cursor when using Aggregate fields
- Fixed bug with deleting a record when using Aggregated fields
- Fixed bug with storing empty Aggregates collection in DFM
- Fixed bug with AV when installing a package in the IDE
- Fixed bug with AV in the CloneCursor method of the dataset
- Fixed bug with using Aggregated and InternalCalc fields together
- Fixed bug with duplicate resource IDs in CBuilder
- Fixed bug with using "NOT Field LIKE" construction in Filter property
- Fixed bug "Assertion failure" when using TVirtualDataSet
- Fixed bug with reading MySQL fields of type "bigint" to TVirtualQuery
- Fixed bug with incorrect results in the TVirtualQuery when COLLATE NOCASE is used
- Fixed bug with a memory leak on closing an application after using TVirtualQuery
- Fixed bug with saving/loading fields with Unicode names in the VirtualTable component
- Fixed bug with assigning a VirtualTable component that has persistent fields
- Fixed bug with editing a source dataset after reopening TVirtualQuery
- Fixed bug with inserting BLOBs using TVirtualQuery
New in Universal Data Access Components 9.4.0 (Mar 20, 2023)
- Added support for RAD Studio 11 Alexandria Release 3
- Added support for iOS Simulator target platform
- Added support for Lazarus 2.2.6
- Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
- Added support for the mathematical operations in TDADataSet.Filter
- Added support for Aggregate Fields and InternalCalc Fields
- Added ability to restore from file with TEncoding via the Dump component
- Improved the execution of statement that have either IS NULL or IS NOT NULL in the WHERE clause with TVirtualQuery
- Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
- Fixed bug with AV on using master/detail relationship with VirtualTable
- Fixed bug with loading data that already has persistent fields into VirtualTable
- Oracle data provider:
- Improved detection of home directories in recent versions of Oracle
- Now valid exception will be raised instead of AV when memory can't be allocated for the large row count
- Fixed bug with LOBs reading in the Direct mode
- Fixed bug with reading BFLOAT and BDOUBLE values from ANYDATA
- Fixed bug with querying record count if SQL statement contains PIVOT
- SQLServer data provider:
- Improved compatibility with Linked Server in MSSMS
- Improved the GetOrderBy method behavior
- Fixed bug with Unicode (UTF-8) in the Direct mode for Windows
- Fixed bug with an assertion failure in the CachedUpdate mode
- Fixed bug with connecting to default instance by prSQL(SQLOLEDB.1) provider
- Fixed bug with fetching datetimeoffset fields in the Direct mode
- Fixed bug with fetching sql_variant fields in the Direct mode
- Fixed bug with preparing a stored procedure in the Direct mode
- MySQL data provider:
- Fixed bug with BLOBs for MySQL version below 4.1
- Fixed bug with BIGINT UNSIGNED key fields in version 4.1 or higher
- Fixed bug with BIT field default values
- PostgreSQL data provider:
- Added support for PostgreSQL 15
- Improved process of getting extended fields info
- Fixed bug with extra connections in GetType methods
- Fixed bug with TIMESTAMPTZ fields
- Fixed bug with reading fields of type REAL using the Auto protocol
- Fixed bug with writing Bytea type in Batch operations
- Fixed bug with using "ON CONFLICT RETURNING" in batch operations
- Fixed problem with handling fields of type REAL
- Fixed bug with the "Range Check Error" exception when reading BLOB data
- InterBase data provider:
- Improved work with alias
- Fixed bug with "The SQL statement is not allowable for a bulk operation" when using SP in batch operations
- Fixed bug with "Validation error" when using the Loader component
- SQLite data provider:
- Added support for GUID fields stored in binary format
- Improved reading fields of the BLOB family
- DBF data provider:
- Improved ROUND() function
- Fixed bug with a field name case when creating a table
- NexusDB data provider:
- Added support for NexusDB 4.70.01
- Added support for working with tables protected by a password
- ODBC data provider:
- Added the UuidWithBraces specific option for the Connection component
- MS Access data provider:
- Fixed bug with "Cannot modify a read-only dataset"
- MongoDB data provider:
- Added support for MongoDB Atlas
- Added support for DNS Seed List connection format
- Fixed bug with reading international characters when UseUnicode option is set
New in Universal Data Access Components 9.3.0 (Sep 13, 2022)
- 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
New in Universal Data Access Components 9.2.1 (Apr 12, 2022)
- RAD Studio 11.1 Alexandria is supported
- Lazarus 2.2.0 is supported
- Windows 11 is supported
- Fixed bug with executing batch operations with the VirtualQuery component
- Fixed bug with resetting param values when changing param values count
- Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection
- Oracle data provider:
- Fixed bug with HTTPS tunneling in the Direct mode
New in Universal Data Access Components 9.1.1 (Dec 9, 2021)
- 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
New in Universal Data Access Components 9.0.1 (Sep 14, 2021)
- RAD Studio 11 Alexandria is supported
- MacOS ARM is supported
- Added demo project for FastReport FMX
- Fixed bug 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 mapping
- Fixed bug with escaping wildcards in the Filter property of the DataSet component
- Oracle data provider:
- Fixed bug with string OUT parameters in Oracle 12.1
- SQLServer data provider:
- Fixed bug with using the NonBlocking mode from threads
- Fixed bug with Varchar(max), NVarchar(max), Text and NText OUT parameters
- Fixed bug with the AV failure when reading the BLOB fields data in Lazarus
- MySQL data provider:
- Fixed bug with an "Unknown column" error on Post when RefreshOption = roAfterInsert
- PostgreSQL data provider
- Fixed bug with processing UUID fields
- Fixed bug with processing large OID values
- Fixed bug with the incorrect encoding of error messages
- Fixed bug with the incorrect RowsAffected result of the WITH ... statement
- Fixed bug with error when setting the "0" value for a currency field
- Fixed bug with automatic conversion of null values from SQL subqueries to default values
- Fixed bug with processing IDENTITY fields in the PgDump component
- Fixed bug with CanModify = False in the Table component when opening a temporary table
- Fixed bug with using the Dump component with PostgreSQL version 8.1 and earlier
- Fixed bug with executing stored procedures in PostgreSQL version 8.1 and earlier
- Fixed bug with using batch inserts in PostgreSQL version 8.2 and earlier
- InterBase data provider:
- Firebird 4 is supported
- Fixed bug with executing stored procedures when UseUnicode = True
- SQLite data provider:
- Added the IntegerAsLargeInt connection specific option
- Fixed bug with mapping VARCHAR columns with length greater than 65,535 to fields of type ftString
- NexusDB data provider:
- NexusDB 4.50.27 is supported
- ODBC data provider:
- Fixed bug with re-opening a query which has a parameter of type ftWideString
- Fixed bug with updating boolean columns in MS Access
- ASE data provider:
- Fixed bug with passing the ApplicationName and ClientHostName parameters to the server
- BigQuery data provider:
- Added the BigQuery provider
- HubSpot data provider:
- Added the HubSpot provider
New in Universal Data Access Components 8.4.4 (Jul 15, 2021)
- Support for TFieldOptions is added
- Bug with applying both Encryption and Data Type Mapping on a BLOB column is fixed
- Bug with AV after adding the Lookup field to a prepared DataSet is fixed
- Bug with the Locate method on ftLongWord fields is fixed
- Bug with AV in the TVirtualTable.Assign method is fixed
- Bug with AV when executing a DELETE FROM statement using TVirtualQuery is fixed
- Bug with corrupted data of a GUID field in TVirtualDataSet is fixed
- Bug with universal quoting of identifiers is fixed
New in Universal Data Access Components 8.4.3 (Apr 7, 2021)
- Demo compatibility with new a version of SecureBridge is fixed
- Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed
- Oracle data provider
- Bug with an Invalid pointer operation on Fetch is fixed
- SQLServer data provider
- Bug a string parameter getting trimmed is fixed
- PostgreSQL data provider
- Bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True is fixed
- Bug with reading server messages is fixed
- InterBase data provider
- Bug with loading BLOB columns as strings using the Loader component is fixed
- SQLite data provider
- JournalMode = jmDefault specific option value for the Connection component is added
- Bug with mapping the liteNull database type to the ftBLOB field type is fixed
New in Universal Data Access Components 8.4.2 (Mar 26, 2021)
- Lazarus 2.0.12 is supported
- Bug with the ConvertEOL connection option is fixed
- Bug with AV in applications using DBMonitor is fixed
- Bug with committing a transaction when LockMode = lmPessimistic is fixed
- Bug with getting values of calculated fields is fixed
- Oracle data provider:
- Bug with parameters that have Unknown data type on Prepare is fixed
- Bug with calling stored procedures when AutoCommit=False is fixed
- Bug with parameters for Oracle 19c in the Direct mode is fixed
- Bug with NUMBER fields when EnableFMTBCD=True is fixed
- SQLServer data provider:
- Bug with the data type mapping of varbinary fields is fixed
- MySQL data provider:
- Bug with the "Prepared statement contains too many placeholders" error in batch operations is fixed
- PostgreSQL data provider:
- Several bugs with the MultipleConnection option are fixed
- Several bugs with ProtocolVersion = pvAuto are fixed
- Bug with LockMode = lmPessimistic is fixed
- InterBase data provider:
- The default value of the BooleanDomainFields specific option reverted to True
- NexusDB data provider:
- NexusDB 4.50.26 is supported
New in Universal Data Access Components 8.4.1 (Mar 17, 2021)
- Support RAD Studio 10.4.2 Sydney.
- Compatible with macOS Big Sur, iOS 14, and Android 11.
- The performance of batch processing of SQL statements is significantly improved.
New in Universal Data Access Components 8.3.2 (Sep 14, 2020)
- Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
- Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed
- SQLServer data provider:
- Bug with the "Wrong amount of parameters 4 in TableName" error when retrieving data from a linked server is fixed
- Bug with an assertion failure when manually creating parameters is fixed
- MySQL data provider:
- Bug with values getting cut off after calling the SHOW CREATE FUNCTION statement for MySQL 5.0.x is fixed (MySQL provider)
New in Universal Data Access Components 8.3.1 (Aug 27, 2020)
- Lazarus 2.0.10 and FPC 3.2.0 are supported
- Performance of Batch Insert, Update, and Delete operations is improved
- Oracle data provider:
- Oracle 20c is supported
- Connection via SSL protocol is supported
- Connection via SSH protocol is supported
- Connection via HTTP tunnel is supported
- SQLServer data provider:
- SQL Server 2019 is supported
- Failure to connect in the Direct mode with different credentials after unsu�cessful initial connection attempt is fixed
- SQLite data provider:
- Bug with Data Type Mapping to the ftLargeint field type is fixed
- DBF data provider:
- Native dBase functions in a SQL statement are supported
- MongoDB data provider:
- Bug with using special characters in a username or password is fixed
- Bug with the "Out of memory" error when retrieving data from huge collections is fixed
- ODBC data provider:
- Error message retrieving from SQL Anywhere ODBC driver is improved
New in Universal Data Access Components 8.2.5 (Jun 9, 2020)
- Oracle data provider:
- Bug with describing sorted procedure parameters is fixed
New in Universal Data Access Components 8.2.4 (Jun 4, 2020)
- RAD Studio 10.4 Sydney is supported
- Lazarus 2.0.8 is supported
- macOS 64-bit in Lazarus is supported
- Bug with data loss in the column of type ftLargeint in the VirtualTable component in Lazarus is fixed
- Bug with locating a record by a fixed string column in the Chinese locale is fixed
- Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed
- Oracle data provider:
- Mapping the FLOAT Oracle data type to the ftNumber field is added
- Bug with SELECT RowId using Database Link in Direct mode is fixed
- Bug with retrieving implicit result sets after calling the Execute method is fixed
- Bug with retrieving unchanged parameter values in the Direct mode is fixed
- Bug with SQL statements containing a JAVA clause in TUniScript is fixed
- Bug with Charset when Pooling is enabled is fixed
- SQLServer data provider:
- Bug with setting a value for the TrustServerCertificate option is fixed
- Bug with switching databases in Direct mode is fixed
- MySQL data provider:
- Bug with an invalid refresh query for calculated fields if the roBeforeEdit option is set is fixed
- PostgreSQL data provider:
- The Line geometric type is supported
- Bug with the Dump component in PostgreSQL 12 is fixed
- Bug with reading zero-valued geometric fields as nulls is fixed
- InterBase data provider:
- Bug with an incorrect value in the DBSQLDialect property is fixed
- Bug with using a case-sensitive Role name is fixed
- DBF data provider:
- The AllFieldsAsNullable specific option is added
- Bug with indexes containing date fields is fixed
- Bug with VisualFoxPro indexes containing double fields is fixed
- Bug with using tables whose fields match SQL keywords is fixed
- Bug with JOIN on fields that have NULL values is fixed
- Bug with table file locking after executing UPDATE with ConnectMode = cmUnsafe is fixed
- Bug with an application hanging when trying to reopen a table with ConnectMode = cmExclusive is fixed
- NexusDB data provider:
- Support for the Pipe protocol is added
- Support for the Secure Pipe protocol is added
- Support for the Secure TCP protocol is added
- Now an #INMEM alias is created automatically when it is specified in the Database property
- MongoDB data provider:
- Bug with connecting to a database that contains documents with a huge amount of fields is fixed
- ODBC data provider:
- Bug with scale when reading a NUMERIC column as the ftFloat field is fixed
- MS Access data provider:
- Bug with obtaining metadata in Delphi 7 is fixed
- BigCommerce data provider:
- Bug with connection is fixed
- Dynamics CRM data provider:
- Bug with connection is fixed
- FreshBooks data provider:
- Bug with connection is fixed
- Magento data provider:
- Bug with connection is fixed
- MailChimp data provider:
- Bug with connection is fixed
- NetSuite data provider:
- Bug with connection is fixed
- QuickBooks data provider:
- Bug with connection is fixed
- Salesforce data provider:
- Bug with connection is fixed
- Salesforce MC data provider:
- Bug with connection is fixed
- SugarCRM data provider:
- Bug with connection is fixed
- Zoho CRM data provider:
- Bug with connection is fixed
New in Universal Data Access Components 8.1.3 (Mar 11, 2020)
- Bug with installing different editions of two or more DAC's in a single system is fixed
- Bug with SQL statements that contain fields with the same name from different tables is fixed
- Bug with executing SQL statements that contain comments using the Script component is fixed
- Bug with resetting the value of the parameter after adding a new TDACondition is fixed
- Bug with reading a field value using the AsBytes method in Lazarus is fixed
- Bug with using constraints after calling the Refresh method is fixed
New in Universal Data Access Components 8.1.2 (Nov 26, 2019)
- Android 64-bit is supported
- Lazarus 2.0.6 is supported
- Now Trial edition for macOS and Linux is fully functional
- Bug with mapping a MEMO field to a floating-point field type in the TVirtualQuery is fixed
- Bug with the Loader component when UniDirectional set to True for source dataset is fixed
- Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
- Bug with mapping to BCD fields when TClientDataSet is used is fixed
- Bug with resetting the range values when executing the Refresh method is fixed
- Bug with AV failure when using encryption is fixed
- Bug with using the FieldOrigins property is fixed
- Several bugs that occurred when using DataSet Manager are fixed
- Oracle data provider:
- Oracle 19c is supported
- Long database object names is supported
- Bug with UTF-8 encoding for Oracle 9 in the Direct mode is fixed
- Bug with memory leak on session connect in the Direct mode is fixed
- Bug with init session timezone in the Direct mode is fixed
- Bug with rounding float values in the Direct mode is fixed
- SQLServer data provider:
- TLS 1.2 support in the Direct mode is added
- The connection option MultiSubnetFailover for the MSOLEDB provider is added
- Updating data after invoking the Refresh method is fixed
- Bug with connecting to SQL Server 2000 in the Direct mode is fixed
- Use of the Server property that contains Port in the Direct mode is added
- Bug with the NativeClientVersion connection option being set from ConnectionString is fixed
- MySQL data provider:
- OpenSSL 1.1 library is supported
- Bug with freezing of the TUniConnection design-time editor for MySQL versions older than 4.1 is fixed
- Bug with international characters in error messages when UseUnocode = True is fixed
- PostgreSQL data provider:
- PostgreSQL 12 is supported
- OpenSSL 1.1 library is supported
- InterBase data provider:
- Interbase 2020 is supported
- Improved performance when using pooling
- Bug with using the array data type in a table with quoted name is fixed
- Bug with executing the CREATE DATABASE statement when Pooling is enabled is fixed
- Bug with the UniLoader component when BooleanDomainFields set to True is fixed
- Bug with the "segment buffer length shorter than expected" error is fixed
- SQLite data provider:
- Bug with AV when executing the INSERT operation is fixed
- Bug with a wrong default value of a DATETIME field when inserting a record is fixed
- Bug with mapping a MEMO field to a floating-point field type is fixed
- NexusDB data provider:
- Bug with executing batch operations is fixed
- MongoDB data provider:
- The LowerCaseObjectId specific option for the Connection component is added
- Bug with reading documents containing array values is fixed
- DBF data provider:
- The IdentifierCase specific option is added
- The cmUnsafe value for the ConnectMode specific option is added
- Bug with refreshing a dataset after adding records via another connection is fixed
- Bug with inserting records with empty field values is fixed
- Bug with adding a field of type MEMO to a table is fixed
- Bug with updating date fields is fixed
- Bug with using native indexes when executing SQL queries is fixed
- Bug with mapping a MEMO field to a floating-point field type is fixed
- Bug with upditing records in a table, which has a compound index, is fixed
- Bug with detecting dBaseIV file format is fixed
- Bug with using character fields in a WHERE clause is fixed
- Bug with opening tables, which table path contains a dot, is fixed
- Bug with using date fields in a WHERE clause on Linux is fixed
New in Universal Data Access Components 8.0.1 (Jul 23, 2019)
- Update 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
- Bug with using the AsMemo method in batch operations is fixed
- Bug with AV failure on TUniDump.RestoreFromStream is fixed
- Oracle data provider:
- Bug with re-executing some prepared SQL statements in the Direct mode is fixed
- SQLServer data provider:
- Bug with the "StoredProc has too many arguments specified" error when executing SP is fixed
- InterBase data provider:
- Bug with memory leak when using connection pooling is fixed
- SQLite data provider:
- Bug with applying aggregate functions on fields with null values is fixed
- Bug with AV when using user-defined functions is fixed
- Bug with using both UniDAC Express and LiteDAC Professional is fixed
- Bug with possible data corruption when encrypting a database which contains open datasets is fixed
- DBF data provider:
- Bug with opening tables that use SQL keywords as field names
New in Universal Data Access Components 7.5.13 (Jun 24, 2019)
- Lazarus 2.0.2 is supported
- The DefaultSortType property for TVirtualTable is added
- Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
- Bug with the AV failure when executing the Refresh method is fixed
- Bug with calculating percentage in the OnRestoreProgress event in the TDADump class is fixed
- Bug with the StackOverflow exception when using batch operations in CBuilder is fixed
- Bug with using the SetRange method is fixed
- Bug with handling BLOB fields in TVirtualTable on the Linux platform is fixed
- Bug with attempting to save data to read-only fields when modifying a dataset is fixed
- Bug with AV in applications built with C++ Builder for Windows 64-bit when the server connection fails is fixed
- Oracle data provider:
- Support for using the ChangePassword method is added
- Bug with the UTF-8 character set for Oracle 9 in the Direct mode is fixed
- SQLServer data provider:
- Working with multiple threads sharing a single connection is supported
- Support for using the ChangePassword method is added
- Bug with the 'OnError' event generation is fixed
- Bug with setting the connection options for the MSOLEDB provider is fixed
- Bug with an assertion failure when saving a datetime value is fixed
- Bug with using the FieldOrigins property is fixed
- MySQL data provider:
- Performance of TMyDump for data dumping from a query is improved
- Performance of describing stored procedures is improved
- Bug with processing data that include international characters when using the EUC-KR character set is fixed
- Bug with a memory leak when using an SSL connection is fixed
- Bug with updating a dataset containing a composite primary key is fixed
- Bug with using the STATUS literal in a query is fixed
- PostgreSQL data provider:
- The pmAuto value for the ProtocolVersion specific option is added
- Now ProtocolVersion is set to pmAuto by default, which significantly improved performance
- The mVerifyCA and smVerifyFull options for the SSLMode specific option of the TUniConnection component are added
- Possibility to use function calls in batch operations is added
- Bug in TPgDump with backing up sequences in PostgreSQL 10 or later is fixed
- InterBase data provider:
- Local connection is supported
- The URL-style connection string format is supported
- The IPVersion specific option for the InterBase data provider is added
- Improved performance when inserting data into a table with BLOB fields using the Loader component
- Bug with QueryRecCount when using the GROUP BY clause is fixed
- Bug with the "Cannot perform operation on connected connection" error when using pooling is fixed
- Bug with changing BLOB fields when the CacheBlobs property set to False is fixed
- SQLite data provider:
- Now the Direct mode is based on the version 3.27.2 of the SQLite engine
- Bug with using the LIKE clause in a query is fixed
- ASE data provider:
- Working with multiple threads sharing a single connection is supported
- The MultipleConnections connection option is added
- The OpenNext method for opening a next result set is added
- DBF data provider:
- Compatibility with BDE and ADO is improved
- The IgnoreDataErrors specific option is added
- The IgnoreMetadataErrors specific option is added
- The CodePage specific option is improved
- Bug with inserting records with empty fields is fixed
- Bug with executing a CREATE TABLE statement is fixed
- Bug with executing a CREATE INDEX statement is fixed
- Bug with updating an index when modifying table data is fixed
- Bug with reading floating-point values is fixed
- Bug with reading MEMO field values is fixed
- Bug with updating MEMO fields is fixed
- Bug with using tables whose names match SQL keywords is fixed
- Bug with using an index containing fully qualified field names is fixed
- Bug with a wrong default value of the AUTOINC field is fixed
- MongoDB data provider:
- The SQLEngine specific option is added
- Bug with querying documents by ObjectId is fixed
- ODBC data provider:
- The OpenNext method for opening the next result set is added (ODBC provider)
- Bug with handling BLOB fields in TVirtualTable on the Linux platform is fixed (VirtualDAC)
- Bug with using BLOB parameters in Informix ODBC Driver is fixed (ODBC provider)
New in Universal Data Access Components 7.4.12 (Jan 21, 2019)
- Bug with using the datetime literals in SQL statements in TVirtualQuery is fixed
- Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed
- Oracle data provider
- Bug with authentication of old users in Oracle 12c is fixed
- Bug with the DML arrays that contain the TIMESTAMP values is fixed
- Bug with describe of SYNONYM for stored procedures in the Direct mode is fixed
- Bug with fetch data when the FieldsAsString option is set to True in the Direct mode is fixed
- Bug with open REFCURSOR is fixed
- SQLServer data provider
- Bug with the "Cannot modify a read-only dataset" error in Android is fixed
- MySQL data provider
- Bug with setting the data type of the parameter to BOOLEAN for all TINYINT system data types in the functions is fixed
- PostgreSQL data provider
- Bug with reading and writing of the floating point values is fixed
- InterBase data provider
- Bug with using the AsBytes property is fixed
- Bug with the AV failure when using the BLOB data type in Lazarus is fixed
- SQLite data provider
- Now the Direct mode is based on the SQLite engine version 3.26.0
- DBF data provider
- Bug with wrong selection of deleted records is fixed
- Bug with storing numeric values is fixed
- Bug with using the CTOD, DTOC, DTOS, TTOC, TTOD and EMPTY functions in index expressions is fixed
- Bug with using a field named RECNO in the index expressions is fixed
- MongoDB data provider
- Bug with reading string values in the BSON format is fixed
- NexusDB data provider
- Bug with missing files for NexusDB for RAD Studio Rio (10.3) is fixed
- ODBC data provider
- The UnknownAsSring specific option is added
New in Universal Data Access Components 7.4.11 (Nov 27, 2018)
- RAD Studio 10.3 Rio is supported
- Support of UPPER and LOWER functions for Unified SQL is added
- Bug with using the FieldOrigins property is fixed
- Bug with using the TrimFixedChar property is fixed
- Bug with saving a dataset that contains BLOB fields to XML is fixed
- Bug with the Refresh method of TVirualQuery is fixed
- Bug with handling BCD fields in TVirtualQuery is fixed
- Bug with updating fields which have data type mapping in TVirtualQuery is fixed
New in Universal Data Access Components 7.3.10 (Sep 18, 2018)
- Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
- Support for SpecificOptions in FastReport components is added
- Now the SetRange method supports Null values
- The enumerated property FieldOrigins is added
- The Boolean property FieldsOrigin is deprecated
- Bug with AV when using custom constraints is fixed
- Bug with using FilterSQL in the SmartFetch mode is fixed
- Bug with editing data in TVirtualQuery having TVirtualTable as a source is fixed
- Bug with mapping an error when a query contains functions like SUM is fixed
- Bug with freezing an application when a query contains UNION ALL is fixed
- Bug with updating data in TVirtualQuery is fixed
- Bug with editing data in TVirtualQuery when the SELECT statement contains the ROWID column is fixed
- Several bugs with handling BLOBs in TVirtualQuery are fixed
New in Universal Data Access Components 7.3.9 (Jul 16, 2018)
- Bug with detection of field data types in DBF, SQLite and VirtualQuery is fixed
New in Universal Data Access Components 7.3.8 (Jul 9, 2018)
- Lazarus 1.8.4 is supported
- Performance of batch operations is improved
- Demo projects for IntraWeb 14 are added
- The LocalUpdate property for TVirtualQuery is added
- The AutoOpenSources option for TVirtualQuery is added
- Memory leak in NEXTGEN is fixed
- Bug with updating a record when using the OnFilterRecord event handler is fixed
- Bug with using encryption and CacheCalcFields option is fixed
- Bug with using a backslash in the Filter property is fixed
- Bug with using First method in the Master-Detail relationship is fixed
- Bug with reading BLOB fields data on mobile platforms in TVirtualTable is fixed
- Oracle data provider:
- Now non-compiled stored procedures can be described in the Direct mode
- Performance of data fetching in the Direct mode is improved
- Performance of describing stored procedures in the Direct mode is improved
- Support for TIMESTAMP WITH TIMEZONE in the Direct mode is improved
- Bug with AV on destroying Query that executed batch DML with LOB parameters after connection was closed is fixed
- Bug with writing trash in the BLOB fields on executing batch DML operations in the Direct mode is fixed
- SQLServer data provider:
- MARS in TDS is supported
- NonBlocking mode in TDS is supported
- Query notifications in TDS are supported
- Bug with processing parameters with ftUnknown data type is fixed
- Bug with processing transaction descriptors is fixed
- MySQL data provider:
- MySQL 8 is supported
- Support for sha2_password, caching_sha2_password authentications is added
- Bug with application freezing when using stored procedure is fixed
- Bug with using the LongStrings option is fixed
- InterBase data provider:
- Now the "Data type is not supported" exception is not raised by the Query component when the DescribeParams property is set to True
- Bug with loading GUID values using the Loader component is fixed
- Bug with loading VARCHAR values using the Loader component is fixed
- Bug with the BreakExec method is fixed
- Bug with the "Stream read error" error is fixed
- Bug with the "Incomplete multibyte char" error for non-Windows platforms is fixed
- PostgreSQL data provider:
- Support for HTTP/HTTPS tunnel is added
- Bug with retrieving the result recordset when using an INSERT ... RETURNING statement in batch operations is fixed
- Bug with a connection error using SSL on some servers is fixed
- SQLite data provider:
- WAL in the Direct Mode for non-Windows platforms is supported
- Bug with retrieving data in a Detail dataset having SmartFetch enabled is fixed
- Bug with AV on macOS High Sierra is fixed
- ASE data provider:
- Retrieving the OUTPUT parameters is improved
- MongoDB data provider:
- The Decimal128 data type is supported
- Precompiled MongoDB client libraries are included in the Professional Edition
- Performance of fetching large documents is improved
- DBF data provider:
- Support for Clipper/Harbour is added
- Support for native indexes based on complex expressions is added
- Compatibility with Codebase is improved
- Bug with opening some dBaseIII/dBaseIV tables is fixed
- Bug with creating a table having the hyphen in the name is fixed
- ExactTarget data provider:
- App center client authentication is supported
- FreshBooks data provider:
- FreshBooks new version is supported
- Magento data provider:
- Magento version 2.x is supported
- NetSuite data provider:
- Sandbox is supported
- ZohoCRM data provider:
- Domain is supported
New in Universal Data Access Components 7.2.7 (Apr 11, 2018)
- InterBase data provider:
- Bug with the "Attempt to reopen open cursor" error when trying to execute the Refresh method is fixed
- SQLite data provider:
- Bug with missing libs for static linking in Lazarus is fixed
New in Universal Data Access Components 7.2.6 (Apr 2, 2018)
- Lazarus 1.8.2 is supported
- Now Detail dataset is not refreshed when Master dataset editing is started
- Bug with executing batch operations with iteration = 1 and offset = 0 is fixed
- Bug with re-opening a filtered dataset is fixed
- Bug with data decryption in SmartFetch mode is fixed
- Bug with data truncation while decrypting is fixed
- Bug with using field aliases in the SELECT of a source dataset of TVirtualQuery is fixed
- Bug with AV failure when ftVariant fields are used in TVirtualDataSet is fixed
- Bug with using OR in the WHERE of a source dataset of TVirtualQuery is fixed
- Bug with a WHERE clause with a boolean field in TVirtualQuery is fixed
New in Universal Data Access Components 7.2.5 (Jan 18, 2018)
- 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 added
- 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
New in Universal Data Access Components 7.1.4 (Oct 2, 2017)
- InterBase data provider:
- Bug with the "Input parameter mismatch" error for procedure is fixed
- Bug with transactions when working with Firebird 2.5 is fixed
New in Universal Data Access Components 7.1.3 (Sep 19, 2017)
- The performance of TVirtualQuery is significantly improved
- Application-defined functions in TVirtualQuery are supported
- Application-defined collations in TVirtualQuery are supported
- AutoInc fields in TVirtualTable are supported
- Bug with assertion failure when updating a record in TVirtualQuery is fixed
- Bug with compatibility with TkbmMemTable in TVirtualQuery is fixed
- Bug with complex WHERE clauses that have several string fields in TVirtualQuery is fixed
- Bug with selecting from a dataset with a single record in TVirtualQuery is fixed
- Bug with generating SQL for batch updates is fixed
- Bug with the Locate method for non-Windows platforms in Lazarus is fixed
- Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed
- Bug with accessing a product help from the IDE menu is fixed
- Bug with recreating fields when calling Open after Prepare is fixed
- Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed
- Bug with AV failure when using calculated fields in TClientDataset is fixed
- Bug with a key violation error when executing batch operations is fixed
- Bug with Assert when calling the Locate method in the SmartFetch mode is fixed
- Bug with using DAC components in DataModule for Linux is fixed
- Cloud data providers:
- BigCommerce provider is added
- Dynamics CRM provider is added
- FreshBooks provider is added
- Magento provider is added
- MailChimp provider is added
- NetSuite provider is added
- QuickBooks provider is added
- Salesforce provider is added
- Salesforce Marketing Cloud provider is added
- SugarCRM provider is added
- Zoho CRM provider is added
- Oracle data provider:
- Oracle 12c connection modes (SYSBACKUP, SYSDG, SYSKM) in the Direct mode are supported
- OS authentication in the Direct mode is supported
- NChar literal replacement is supported
- CLOB parameters behavior when UnicodeEnvironment=True is improved
- Bug with lost chars in a parameter value when ConvertEOL=True is fixed
- SQLServer data provider:
- Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed
- Bug with processing a field with alias for query with the JOIN statement is fixed
- Bug with date and time fractional seconds precision when DescribeParams = True is fixed
- MySQL data provider:
- Azure Database for MySQL is supported
- JSON data type is supported
- InterBase data provider:
- Support for Firebird on Android platform is added
- Support for Firebird 3 packages is added
- Aliases handling in the RETURNING clause is supported
- The WireCompression connection parameter for Firebird 3 is supported
- Bug with using BLOB data type in batch operations is fixed
- Bug with the OnBackupProgress event handler in TUniDADump is fixed
- Bug with using batch parameters of the Bytes type is fixed
- Bug with closing a connection that has an active transaction for Firebird 3 is fixed
- Bug with recreating a connection on Linux and mobile platforms is fixed
- PostgreSQL data provider:
- SSPI authentication is supported
- Processing GUID data type for the TGuidField class is improved
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.20.0
- Custom SQL aggregate functions are supported
- Bug with opening an existing database on iOS 64 is fixed
- Bug with detecting field types is fixed
- Bug with international symbols in non-Unicode Delphi versions is fixed
- Bug with low performance of the LoadFromDataSet method of the Loader component is fixed
- Bug with index backup using the Dump component when the TableNames property is set is fixed
- DBF data provider:
- The CodePage specific options are added
- The ConnectMode specific options are added
- Bug with using CDX indexes is fixed
- DB2 data provider:
- The DECFLOAT data type is supported
New in Universal Data Access Components 7.0.2 (May 15, 2017)
- Bug with using TVirtualQuery with TVirtualTable is fixed
- Bug with processing NULL values in the Loader component is fixed
- Bug with executing a query after executing a batch command is fixed
- Bug with executing a batch operation inside an explicitly started transaction is fixed
- Bug with using the AsGuid property is fixed
- Oracle data provider
- Bug with authentication in the Direct mode is fixed
- MySQL data provider
- Bug with processing DATETIME fields is fixed
- SQLServer data provider
- Bug with the "Invalid column name" error when editing a query with the JOIN statement is fixed
- InterBase data provider
- Bug with memory leak when using the SQLMonitor component is fixed
- PostgreSQL data provider
- Bug with AV failure after executing the Ping method is fixed
- SQLite data provider
- Bug with creating a database in the Direct Mode on Android is fixed
New in Universal Data Access Components 7.0.1 (Apr 6, 2017)
- RAD Studio 10.2 Tokyo is supported
- Linux in RAD Studio 10.2 Tokyo is supported
- Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
- Bug with AV failure in TUniProvider in multi-threading application is fixed
- Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
- Bug with detecting parameters by name in ExecSQLEx is fixed
- Bug with reading Memo as WideMemo is fixed
- Bug with field name quoting in a filter expression is fixed
- Bug with handling parameter values of BLOB type in batch operations is fixed
- Bug with memory leak in TVirtualDataSet is fixed
- Bug with processing LEFT JOIN on text fields in TVirtualQuery is fixed
- Bug with updating records with text primary key in TVirtualQuery is fixed
- Oracle data provider:
- Oracle Encryption in the Direct mode is supported
- Oracle Data Integrity in the Direct mode is supported
- Oracle Cloud (DBaaS) in the Direct mode is supported
- Oracle 12c authentication in the Direct mode is supported
- SECUREFILE in the Direct mode is supported
- Prefetch LOBs for Oracle 11 and higher is supported
- EDITIONABLE and NONEDITIONABLE clause is supported
- The PrefetchLobSize option is added
- Field size detecting for servers with multi-byte charset when UseUnicode=False is improved
- Now NUMBER data type without fixed scale has precision=39 and scale=39 instead of 38
- Bug with special symbols in password in the Direct mode is fixed
- Bug with write BLOB to SECUREFILE for Oracle XE in the Direct mode is fixed
- Bug with single quote inside double quotes in SQL is fixed
- Bug with resizing DML parameters array is fixed
New in Universal Data Access Components 6.4 (Sep 12, 2016)
- TVirtualQuery component is added;
- TVirtualDataSet component is added;
- TDADataSetOptions.InsertAllSetFields property is added;
- SQL Server data provider:
- Support for IPv6 protocol in Direct Mode is added.
New in Universal Data Access Components 6.3 (Sep 12, 2016)
- RAD Studio 10.1 Berlin is supported;
- Lazarus 1.6 and FPC 3.0.0 is supported;
- Support for the BETWEEN statement in TDADataSet.Filter is added;
- Oracle data provider:
- Transactions behavior when AutoCommit is disabled now is the same as in ODAC;
- SQLServer data provider:
- Direct mode in TUniLoader is supported;
- SmartFetch mode in Disconnected mode is supported;
- MySQL data provider:
- Support for utf8mb4 charset is added;
- SmartFetch mode in Disconnected mode is supported;
- PostgreSQL data provider:
- PostgreSQL 9.5 is supported;
- A MessageCharset option in connection specific options is added;
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.12.0;
- Support for URI filenames is added;
- Adaptive Server Enterprise data provider;
- Direct mode is supported;
- Specific option HostName was renamed to ClientHostName;
- ODBC data provider:
- An ability to select ODBC Driver Manager is added;
- MS Access data provider:
- Possibility to select a driver is added.
New in Universal Data Access Components 6.2 (Sep 12, 2016)
- RAD Studio 10 Seattle is supported;
- INSERT, UPDATE and DELETE batch operations are supported;
- Now Trial for Win64 is a fully functional Professional Edition;
- Oracle data provider:
- Support for Offset is added for DML arrays;
- Support for OraNet.PacketSize is added to improve performance in VPN and Wireless networks;
- Now NULL and empty strings are different values for ftOraLob and ftOraClob parameters;
- MySQL data provider:
- MariaDB Embedded is supported;
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.8.11.1;
- The EnableSharedCache specific option of the Connection component for non-Windows platforms is added.
New in Universal Data Access Components 6.1.3 (Apr 17, 2015)
- RAD Studio XE8 is supported
- AppMethod is supported
- The ParamCheck option behavior is fixed
- Bug on calling Code Editor in the UniStoredProc editor is fixed
- Bug with invalid names of Master-Detail parameters is fixed
- Bug with AV on calling GetVersion() in C++Builder is fixed
- Bug with AV failure in the SmartFetch mode is fixed
- Bug with the 'Cannot convert type' error in the TDADataSet.RefreshRecord method when data type mapping is used is fixed
- Oracle data provider:
- Direct mode in Lazarus is supported
- Now the Direct mode is supplied as source code
- Support for Objects in the Direct mode is added
- Support for EZCONNECT in the Direct mode is added
- Support for fields with Cursor data type in the Direct mode is added
- Now statements with RETURN INTO clauses can return RowsAffected in the Direct mode
- Bug with detecting instant client is fixed
- Bug with detecting default client is fixed
- Bug with memory leak after calling GetFieldNames is fixed
- SQLServer data provider:
- Direct mode in Lazarus is supported
- Now the Direct mode is supplied as source code
- Performance of connection establishing in the Direct mode is improved
- The specific option "OLEDBProvider" is renamed to "Provider"
- Bug with the 'TableName cannot be empty' assertion failure on query opening is fixed
- Bug with processing LongWord parameters is fixed
- Bug with the 'DateTime type 40' error on query opening is fixed
- InterBase data provider:
- Firebird 3 support is added
- Firebird 3 BOOLEAN column type support is added
- Bug with using Firebird Embedded within a DLL is fixed
- Bug with BLOB field types when using InterBase XE and higher is fixed
- Bug with obtaining a generator value for a newly inserted record is fixed
- Bug with inserting a record when the key field is not the first one in a query is fixed
- PostgreSQL data provider:
- PostgreSQL 9.4 support is added
- SQLite data provider:
- Direct mode for Mac OS X, iOS and Android platforms is supported
- Database encryption for Mac OS X, iOS and Android platforms is supported
- Now the Direct mode is based on the SQLite engine version 3.8.9
- The ConnectMode specific option is added
- The TLiteUtils.ReleaseDatabaseMemory method is added
- The TLiteUtils.IsDatabaseReadOnly method is added
- Bug with installing both LiteDAC and UniDAC Express is fixed
- Bug with missing LiteStaticUni.obj is fixed
- ODBC data provider:
- ODBC provider for Lazarus is added for Unix platforms
New in Universal Data Access Components 6.0.2 (Apr 17, 2015)
- Lazarus 1.2.6 is supported
- Bug with linking UniDAC providers in C++ Builder for x64 platform is fixed
- Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
- Bug with losing data after VirtualTable closing on SaveToStream is fixed
- Bug with RestoreUpdates in CachedUpdates mode is fixed
- Oracle data provider:
- Bug with double calling the AfterExecute event on query Execute is fixed
- SQLServer data provider:
- Bug with processing a query containing a 'UNION' clause is fixed
- Bug with editing DateTime fields when string-to-datetime data type mapping is used is fixed
- Bug with loading datetime2 fields via TUniLoader by OLEDB Provider is fixed
- MySQL data provider:
- Support for fraction seconds of datatime fields is added
- Getting datetime precision of table columns via TUniMetaData for MySQL server 5.6 and higher is added
- Performance of backup data using TUniDump is improved
- Bug with processing FarEast symbols in WideString fields is fixed
- Bug in TUniLoader with loading Extended fields is fixed
- Bug in TUniDump with backup Unicode text fields is fixed
- Bug on using the AssignConnect method in Dll is fixed
- InterBase data provider:
- Bug with KeyGenerator behaviour when CachedUpdates = True is fixed
- Bug with mapping SMALLINT database columns to float fields is fixed
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.8.7.4
- Bug with AV when connecting in the Direct mode on x64 platform is fixed
New in Universal Data Access Components 6.0.1 (Nov 27, 2014)
- Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
- Bug with 'Thread Error' when connecting on OS X is fixed
- Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
- Bug with editing DateTime fields when data type mapping from string to DateTime is used is fixed
- Bug with refreshing record if the key field has the TSQLTimeStamp data type is fixed
- Bug when using table aliases in the DetailFields name is fixed
- Bug with using UPPER and LOWER functions in filter is fixed
- Bug with TCustomDADataSet.FindKey is fixed
- SQLServer data provider:
- Direct Mode is supported
- Mac OS X is supported
- iOS is supported
- Android is supported
- Bug with using view in SQL query in the SmartFetch mode is fixed
- Bug with record editing in the SmartFetch mode when RefreshOptions.roBeforeEdit is set is fixed
- Oracle data provider:
- Bug with connection to Oracle 8.0.x is fixed
- Bug with editing Lob fields in the UniDirectional mode is fixed
- Bug with SQL statements containing a WITH clause in TUniScript is fixed
- Bug with AV on opening DataSet in threads is fixed
- MySQL data provider:
- Bug with setting time values greater than 24:00:00 for Time fields is fixed (MySQL provider)
- InterBase data provider:
- The QueryRowsAffected dataset specific option is added for increasing performance of update operations
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.8.7.1
- Bug with registering SQLiteUniProvider is fixed
- Bug with retrieving a table index list using the MetaData component on non-Windows platforms is fixed
- Bug with unnecessary preparing of a DML-statement when a dataset is opening is fixed
- NexusDB data provider:
- Nexus Embedded support is added
- ASE data provider:
- Ability to set CharSet is added
- Advantage data provider:
- Assert on fetch data is fixed
- DB2 data provider:
- Support for 64-bit client is added
New in Universal Data Access Components 5.5.12 (Oct 1, 2014)
- ConnectionTimeout is now used on OSX and Mobile platforms
- Bug with RecNo in the UniDirectional mode is fixed
- Bug with setting SQL query when ParamCheck = False is fixed
- Bug with AV failure on getting metadata by TCustomDADataSet is fixed
- Bug with AV failure under Mobile when DacFMX is used is fixed
- Oracle data provider:
- Bug with AV on an attempt to access server after connection loss is fixed
- Bug with auto-generated parameter types is fixed
- InterBase data provider:
- Translation of the DataSource property of the FIBPlus dataset into the MasterSource property in MigrationWizard is added
- PostgreSQL data provider:
- Backup of huge BLOB-fields with TUniDump is fixed
- SQLite data provider:
- Bug with fetching WideString fields is fixed
- Bug with detection of auto-incremental field is fixed
New in Universal Data Access Components 5.5.11 (Sep 17, 2014)
- RAD Studio XE7 is supported
- Lazarus 1.2.4 is supported
- New free Express edition is added
- Providers are added to the Standard edition and now it doesn't require other DAC products installation
- Demo projects for FastReport 5 are added
- SpecificOptions names and values validation are added
- The TCustomDADataSet.GetKeyFieldNames method is added
- The TCustomDAConnection.GetKeyFieldNames method is added
- The ConstraintColumns metadata kind for the TDAMetadata component is added
- Several bugs in the SmartFetch mode are fixed
- Bug with quoting names in the EmptyTable method is fixed
- Bug with calling the Refresh method after executing the EmptyTable method is fixed
- Bug with setting calculated field values using the AsExtened property is fixed
- Bug with re-calling the AfterExecute event is fixed
- Bug with re-calling the BeforeExecute event is fixed
- Oracle data provider:
- RAC server support is improved
- Support for WITH FUNCTION clause for Oracle 12c is added
- The HideRowId option is added
- Bug with Blob in the disconnected mode is fixed
- Bug with AV on raising an Oracle error in the Trial edition is fixed
- Bug with AV on application closing if connection was established in the OCI7 mode is fixed
- InterBase data provider:
- The OldTransactionBehaviour global variable is added
- Bug with possible AV after TParam.Clear when the parameter has the type of ftBytes is fixed
- Bug with updating a record when Disconnected = True and DeferredBlobRead = True is fixed
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.8.6
- Several bugs with metadata retrieving are fixed
- Bug with mapping TIMESTAMP columns to float fields is fixed
- NexusDB data provider:
- NexusDB 4.07 is supported
- ODBC data provider:
- Fetch performance is improved
- Now the VarBytesAsBlob specific option is replaced with the VarBinaryAsBlob and LongVarBinaryAsBlob specific options
- Information about TypeInfo is added to ODBCMetaData
New in Universal Data Access Components 5.3.10 (Aug 6, 2014)
- The EmptyTable method is added to TUniTable
- The SQL property is added to TUniConnection
- Support for the Upper and Lower statements in TDADataSet.Filter is added
- Support for the ftOraTimeStamp type in TVirtualTable is added
- Bug with reopening TDADataSet after BreakExec is fixed
- Bug with processing calculated and lookup fields in the SmartFetch mode is fixed
- Bug with getting RecordCount when QueryRecordCount is True is fixed
- Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
- Bug with "Invalid field size" in TVirtualTable is fixed
- Bug with AV failure on freeing objects on mobile platforms is fixed
- Several bugs in the SmartFetch mode are fixed
- Oracle data provider:
- Data type mapping from RAW(16) to ftGuid is added
- Now result parameter detection in UniConnection.ExecSQL is similar to the one in ODAC
- Bug with connection establishing if the client has negative half-hour time zone is fixed
- Bug with transactions in the OCI7 mode is fixed
- Bug with tnsnames.ora parsing is fixed
- Bug with parsing table names a if sub-query contains a WITH keyword is fixed
- SQLServer data provider:
- Bug with opening a query with too long columns is fixed
- Bug with cutting an input-output parameter value is fixed
- Bug with processing identity field is fixed
- Bug with processing tinyint fields is fixed
- Bug with processing tinyint and bigint parameters in SQL Server Compact Edition is fixed
- Bug with the Integer Overflow error on query preparation when DescribeParams is True is fixed
- Bug with getting metadata in MS SQL Server 64 bit is fixed
- MySQL data provider:
- Possibility to retrieve time values greater than 24:00:00 for a Time field is added
- Bug in TMyDump with data backup in the Unicode mode is fixed
- InterBase data provider:
- The NoDBTriggers connection option is added
- Bug with query execution when AutoPrepare = True is fixed
- PostgreSQL data provider:
- Bug with incorrect parsing of table names containing a "$" character is fixed
New in Universal Data Access Components 5.3.9 (May 28, 2014)
- Bug with compilation in C++Builder is fixed
- Bug with setting boolean parameters in a non-English IDE at design-time is fixed
- Bug with AV failure on fetching records in the UniDirectional mode is fixed
- Bug with finding master parameters by original name on refreshing record when using master/detail relationship by parameters is fixed
- Bug with missing SmartFetch option is fixed
- Oracle data provider:
- Named parameters on generating procedure call are supported
- Bug with invalid behavior in multithreaded applications is fixed
- Bug with AV on appending a record with BLOB if DataSet was reopened is fixed
- Bug with SQL query for indexes retrieving is fixed
- Bug with instant client is fixed
- SQLServer data provider:
- Bug with unnecessary update of all fields when using server cursor is fixed
- Bug with AV failure on appending new records when using server cursor and CursorUpdate = False is fixed
- Bug with hanging application on closing dataset with non-fetched records is fixed
- InterBase data provider:
- Bug with transaction handling when executing a stored procedure is fixed
- Bug with incorrect table alias names detection is fixed
- Bug with incorrect DECIMAL fields mapping is fixed
- ODBC data provider:
- Bug with repeated call of the Execute method on error is fixed.
- ASE data provider:
- Ability to set HostName is added
- MSAccess data provider:
- The bug with tables, which names start with numbers, is fixed
New in Universal Data Access Components 5.3.8 (May 1, 2014)
- RAD Studio XE6 is supported
- Android in C++Builder XE6 is supported
- Lazarus 1.2.2 and FPC 2.6.4 is supported
- SmartFetch mode for TDataSet descendants is added
- The TUniDataSetOptions.MasterFieldsNullable property is added
- Now update queries inside TDataSet descendants have correct owner
- The SetOrderBy method behavior is fixed
- The GetOrderBy method behavior is fixed
- Bug with displaying already installed DAC version in setup messages is fixed
- Bug with the Filter behavior in the Metadata component is fixed
- Bug with AV on modify table with one only Object field is fixed
- Bug with Locate when a NULL value is present in the index field is fixed
- Bug with IndexFieldNames when DataTypeMapping is enabled is fixed
- Bug with freeing memory in the TDADataSet.Lookup method is fixed
- Bug with error processing on socket data reading under Unix is fixed
New in Universal Data Access Components 5.2.7 (Feb 26, 2014)
- Bug with buttons layout on the "SQL Editor" form in design-time is fixed
- Oracle data provider:
- Now OraNetUni.obj and OraNetUni.o files are supplied for C++Builder
- Bug on connection establishing using Oracle 8, 9, 10.1 clients is fixed
New in Universal Data Access Components 5.2.6 (Feb 20, 2014)
- Now .obj and .o files for all providers are supplied for C++Builder
- Possibility to use MAS_ prefix for parameters when using master/detail relationship is added
- Bug with post data when LockMode=lmOptimistic and Data Type Mapping is applied is fixed
- Bug with opening dataset when persistent fields were created in dataset is fixed
- Bug with parameter name quoting on assigning field value to parameter is fixed
- Bug with deleting a record inserted earlier in CachedUpdates mode is fixed
- Bug on sorting BLOB fields is fixed
- Bug with percentage count in the OnRestoreProgress event of the TDADump class is fixed
- Bug with generating SQL queries by "SQL Generator" in design-time is fixed
- Bug with detecting parameters with the same name is fixed
- Bug with opening inherited forms in IDE is fixed
- Oracle data provider:
- Bug when the Inited property of TOracleHome is not set to True for Oracle Instant Client is fixed
- Bug with connection to Oracle on Unix platforms is fixed
- Bug with AV on prepared Stored Procedure execution is fixed
- Bug with the ORA-24344 error message format in the Direct mode is fixed
- Bug with AV on reconnection for Mobile platforms is fixed
- SQLServer data provider:
- Bug with changing TParam.ParamType when preparing parameters of stored procedure when DescribeParams is True is fixed
- MySQL data provider:
- Support for Autorefresh mode for Mac OS X, iOS and Android platforms is added
- PostgreSQL data provider:
- Bug with the 'Unexpected server response' error when using Master-Detail is fixed
- Bug in TUniQuery when FlatBuffers=False and UnknownAsSring=True is fixed
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.8.3.1 in the SQLite provider
- Support for Delphi DateTime format is added
New in Universal Data Access Components 5.2.5 (Dec 28, 2013)
- iOS in C++Builder XE5 is supported
- RAD Studio XE5 Update 2 is now required
- Now .obj and .o files are supplied for C++Builder
- Compatibility of migrating floating-point fields from other components is improved
- Bug with data loss when updating records in the CachedUpdates mode is fixed
- Bug with RefreshRecord in the CachedUpdates mode is fixed
- Bug with Master-Detail when a connection and a query are placed in different units is fixed
- Bug with data display in Detail Dataset when master field is Null is fixed
- Bug with incorrect parameter sizes when re-opening a query is fixed
- Bug with mapping to BCD fields when using TClientDataSet is fixed
- Bug with mapping single types to float types is fixed
- Bug with mapping to BCD and FmtBCD types is fixed
- Bug with filtering boolean fields is fixed
- Bug with freeing complex fields after refreshing before editing is fixed
- Bug with Locate by fields where Data Type Mapping is applied is fixed
- Bug with RefreshQuick when IndexFieldNames is set is fixed
- Bug with the TUniLoader.AutoCommit property is fixed
- Oracle data provider:
- An ability to establish OCI and Direct connections in the same application is supported
- New Oracle 12c connection modes are added (SYSBACKUP, SYSDG, SYSKM)
- Bug with connecting in the Direct mode under Windows 2000 and lower is fixed
- Bug with Password which length is exactly 16 characters for Oracle 10 in the Direct mode is fixed
- Bug with DB object names containing the '$' and '#' characters is fixed
- Memory Leak in the NonBlocking mode is fixed
- SQLServer data provider:
- Bug with incorrect committing of data by the Loader component on errors is fixed
- MySQL data provider:
- Bug with connecting in the Direct mode under Windows 2000 and lower is fixed
- Bug with returning an incorrect value in the RowsAffected property is fixed
- InterBase data provider:
- Now RowsAffected returns a correct value without the need to prepare a statement explicitly
- Bug with string truncation when using the Loader component is fixed
- Bug when working with parameters of the ftTimeStamp type is fixed
- PostgreSQL data provider:
- Bug with connecting in the Direct mode under Windows 2000 and lower is fixed
- Bug with handling international characters when using protocol version 2 is fixed
- Bug with backup of ENUM types using the Dump component is fixed
- Bug with Memory leak is fixed
- SQLite data provider:
- Direct mode for x64 platform is supported
- Now the Direct mode is based on the SQLite engine version 3.8.2
- Bug with executing multi-SQL statements is fixed
New in Universal Data Access Components 5.1.4 (Sep 26, 2013)
- Critical bug with parsing unicode SQL queries is fixed
- Bug with memory leak in TUniProvider is fixed
New in Universal Data Access Components 5.1.3 (Sep 20, 2013)
- RAD Studio XE5 is supported
- Android in RAD Studio XE5 is supported
- Automatic checking for new versions is added
- Flexible management of conditions in the WHERE clause is added
- Performance is improved
- IPv6 protocol support is added
- Migration from FIBPlus is added
- The possibility to use ranges is added
- The Ping method for the Connection component is added
- The AllowImplicitConnect option for the Connection component is added
- The SQLRecCount property for the Query and StoredProc components is added
- The ScanParams property for the Script component is added
- The RowsAffected property for the Script component is added
- Support of the IN keyword in the TDataSet.Filter property is added
- Like operator behaviour when used in the Filter property is now similar to TClientDataSet
- ConnectionTimeout is now used when disconnecting after connection loss
- Bug when using the Uni.EnableUniSQL global variable is fixed
- Bug with storing the dbMonitor active state to DFM is fixed
- Bug with setting ConnectionTimeout for Unix, Mac OS and iOS platforms is fixed
- Bug with incorrect displaying of long names of parameters and macros in design-time is fixed
- Bug with processing cached data when UpdateRecordTypes is not default is fixed
- Bug with moving data from WideMemo to String fields by TCRBatchMove is fixed
- Bug in TCRBatchMove when destination dataset has no key fields is fixed
- Bug with TCRBatchMove and DataSets in the UniDirectional mode is fixed
- Bug with showing a connection dialog in design-time when LoginPrompt is set to False is fixed
- Bug with setting the connection string containing inline comments is fixed
- Bug with unnecessary unlock calling after an update error is fixed
- Oracle data provider:
- The UROWID data type is supported in the Direct mode
- Bug with Memory Leak in the Direct Mode is fixed
- Bug with an empty error message for ORA-24344 in TUniDataSet is fixed
- Bug with retrieving KeyFields when using Data Base Link is fixed
- Bug with getting TimeStamp & Interval fields when FieldsAsString=True is fixed
- Bug with getting a parameter with the Currency data type is fixed
- SQLServer data provider:
- The CursorType specific option for the SQL Server provider is added
- Bug with using connection macros is fixed for the SQL Server provider
- Bug with using ptResult parameters is fixed for the SQL Server provider
- Bug with calling RefreshRecord when FullRefresh is set to True is fixed for the SQL Server provider
- MySQL data provider:
- MariaDB is supported
- Bug with AssignConnect from a disconnected source connection is fixed for the MySQL provider
- InterBase data provider:
- Now Params specific option values for TUniTransaction can be separated by a semicolon for the InterBase provider
- The ForceUsingDefaultPort global variable is added for the InterBase provider
- TUniLoader.LoadFromDataSet for cases when a dataset record count is less than the RowsPerBatch value is optimized for the InterBase provider
- Bug with setting the TBlobField.AsString value when CacheBlobs = False is fixed for the InterBase provider
- PostgreSQL data provider:
- PostgreSQL 9.3 is supported for the PostgreSQL provider
- Bug with AssignConnect from a disconnected source connection is fixed for the PostgreSQL provider
- Bug when the UnpreparedExecute option is set to True is fixed for the PostgreSQL provider
- Bug with an "Invalid password packet size" message in the PostgreSQL log is fixed for the PostgreSQL provider
- Bug with a zero-valued LastInsertID result is fixed for the PostgreSQL provider
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.8.0 for SQLite provider
- The AutoCommit and AutoCommitRowCount TUniLoader specific options for the SQLite provider are added
- Bug with AssignConnect from a disconnected source connection is fixed for the SQLite provider
- Bug with an incorrect datetime (date, 'localtime') function result in the Direct mode is fixed for the SQLite provider
- Bug with detecting auto-increment fields is fixed for the SQLite provider
- ODBC data provider:
- The DefaultStrParamSize specific option is added
- An option that allows fetching VarBytes as BLOB is added
- ConnectionTimeout is now used when disconnecting after connection loss
- The "SQL statement doesn't return rows" bug when DetectFieldsOnPrepare=False is fixed
- MSAccess data provider:
- The ForceCreateDatabase option is added
- Bug with updating table in the Optimistic lock mode is fixed
- NexusDB data provider:
- NexusDB 3.12 is supported
New in Universal Data Access Components 5.0.2 (Jul 16, 2013)
- Connection dialog is improved
- Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
- Bug in the alerter when DisconnectedMode is set to True for a connection is fixed
- Bug with the connection OnLogin event is fixed
- Bug with incorrect counting of connections in pool is fixed
- Bug with time fields in Lazarus is fixed
- Bug with varbinary fields in Lazarus is fixed
- Bug with using case-insensitive filter is fixed
- Bug with getting and setting the SQL property of FastReport datasets is fixed
- Bug with positioning of Fields Editor is fixed
- Bug with not using index fields on locating records is fixed
- Bug with processing the cached data when UpdateRecordTypes is not default is fixed
- Bug with processing persistent fields in TVirtualTable is fixed
- Oracle data provider:
- Oracle 12c is supported
- Bug with getting error message on object compilation in Oracle client versions lower than 11 is fixed
- Bug with size of NVARCHAR2 columns in the SELECT query in the Direct mode is fixed
- Bug with TIMESTAMP parameters of stored procedures in the direct mode is fixed
- SQLServer data provider:
- Now schema name is used when filling default values if DefaultValues = True
- Bug with processing parameters of stored procedures is fixed
- Bug with the QueryRecCount option queries containing the 'GROUP BY' clause is fixed
- Bug with "Multiple-Step OLE DB Operation generated errors" is fixed
- MySQL data provider:
- Bug with data type mapping of BLOB fields is fixed
- InterBase data provider:
- Bug with setting the default transaction isolation level after a connection is open is fixed
- Bug with getting metadata when using Firebird 1.5 is fixed
- Bug with cutting strings when getting metadata from system tables in the Unicode mode for InterBase 2007 is fixed
- Bug with a "Dynamic SQL error" when querying record count is fixed
- PostgreSQL data provider:
- Bug with multiple metadata requests when using domain field types is fixed
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.7.17
- Now the UNKNOWN data type is mapped as ftMemo
- Bug with incorrect column type determination when metadata API is unavailable is fixed
- Bug with avg(), count(), max() & last_insert_rowid() functions on Mac OS X is fixed
- ODBC data provider:
- Bug with getting OUT parameters is fixed
- Bug with numeric parameters for MS SQL Server is fixed
- Bug with string parameters for MS SQL Server is fixed
- Bug with reading Blob fields from a Tibero database is fixed
- MSAccess data provider:
- Bug with copying data by TCRBatchMove is fixed
- Bug with copying data by TUniLoader is fixed
- ASE data provider:
- Bug with encrypted password when working on client versions lower than 15 is fixed Bug with detecting NUMERIC parameters of stored procedures is fixed
New in Universal Data Access Components 5.0.1 (Apr 27, 2013)
- Rad Studio XE4 is supported
- NEXTGEN compiler is supported
- Application development for iOS is supported
- Connection string support is added
- Possibility to encrypt entire tables and datasets is added
- Possibility to determine if data in a field is encrypted is added
- Support of TimeStamp, Single and Extended fields in VirtualTable is added
- Migration from PgDAC and LiteDAC is added to the Migration Wizard
- Migration from AnyDAC and FireDAC is added to the Migration Wizard
- Bug with Master-Detail for TClientDataSet in Rad Studio XE3 is fixed
- Bug with Master-Detail by non-English fields is fixed
- Bug with IndexFieldNames by non-English fields is fixed
- Bug with incorrect RecordCount result when a query contains both ORDER BY and LIMIT is fixed
- Bug with calling Cancel in the BeforePost event is fixed
- Bug when setting the TDataSet.Filter property for empty dataset is fixed
- Bug with incorrect TVirtualTable version displaying in the About box is fixed
- Bug with TUniLoader.LoadFromDataSet when UniDirectional = True and FetchRows = 1 is fixed
- Thread handle leak when using pooling is fixed
- Oracle data provider:
- BINARY_DOUBLE & BINARY_FLOAT data types support in the Direct mode is added
- Bug with raising internal "Net Error 1" on reading Lob data types for some encodings in the Direct mode is fixed
- Bug with incorrect detecting constant values length in SELECT expression for UTF8 databases in the Direct mode is fixed
- Bug with application hang on get NVarchar column through link to MS SQL Server in the Direct mode is fixed
- Bug with inserting NVARCHAR data for UTF8 databases and Oracle 10 or below if INSERT statement contains RETURNING section is fixed
- Bug with application hang in non-blocking mode is fixed
- SQLServer data provider:
- Bug when opening table for SQL Server Compact Edition 4.0 for 64-bit Windows is fixed
- MySQL data provider:
- SSL support in Mac OS is fixed
- Bug with memory leak when RefreshOptions.roBeforeEdit is set is fixed
- InterBase data provider:
- Application development for iOS using InterBase XE3 ToGo Edition is supported
- The DefaultTransaction property in TUniConnection is added
- The Params specific option in TUniTransaction is added
- PostgreSQL data provider:
- Now ErrorCode indicates a socket error code when a connection error appears
- SSL support in Mac OS is fixed
- Bug with mapping CHARACTER VARYING fields to ftString is fixed
- Bug with automatic transaction restart when FetchAll = False on connection loss is fixed
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.7.16.2
- Now SQLite string data type without length is mapped as ftMemo instead of ftString
- Converter from Unix and Julian data formats to ftDateTime is added
- ASE data provider:
- The EncryptPassword option is added
- The DetectFieldsOnPrepare option is added
- Bug with TUniStoredProc is fixed
- DB2 data provider:
- XML fields support is added
- Bug with connection pool is fixed
New in Universal Data Access Components 4.6.12 (Feb 15, 2013)
- Rad Studio XE3 Update 2 is now required
- TUniEncryptor components are supported in Migration Wizard
- Bug with memory leak when working with UniAlerter is fixed
- Bug with AV on adding TFieldDef items to FieldDefs for Delphi 2009 and higher is fixed
- Bug with incorrect detection of the numeric parameter type in ExecSQL is fixed
- Bug with assigning data to blob fields when using Data Type Mapping is fixed
- Bug with inserting a new record into TStringGrid in FMX is fixed
- Bug with unlocking a record after constraint violation is fixed
- Bug with quoting index field names in TCRDBGrid is fixed
- Bug with Master-Detail link by fields with non-English names is fixed
- Bug with saving Date fields in XML is fixed
- Oracle data provider:
- Bug with memory leak in Master-Detail datasets that contain OraLob fileds is fixed
- SQLServer data provider:
- Bug with data type mapping of nvarchar(max) field is fixed for SQL Server provider
- Bug with the 'List index out of bounds' error on refresh of detail table is fixed for SQL Server provider
- Bug with AV failure on repeated execution of a prepared stored procedure is fixed for SQL Server provider
- Bug with AV failure on filling default field values is fixed for SQL Server provider
- MySQL data provider:
- Bug with AV failure on filling default field values is fixed for MySQL provider
- InterBase data provider:
- 'Range check error' when using TUniAlerter is fixed
- Bug with using unsigned integer values in parameters is fixed
- Bug with connecting to InterBase 7 and lower is fixed
- Bug with assertion failure on filling default field values is fixed
- SQLite data provider:
- Bug in TLiteUtils.EncryptDatabase when using a third-party sqlite3.dll is fixed
- MS Access data provider:
- Bug with retrieving string field values is fixed
- DBF data provider:
- Bug when installing DBFUniProvider from sources using the make.bat file is fixed
New in Universal Data Access Components 4.6.11 (Dec 18, 2012)
- Rad Studio XE3 Update 1 is now required
- C++Builder 64-bit for Windows is supported
- Bug with getting default values for fields with aliases is fixed
- Bug with storing Specific options is fixed
- Bug with using quoted field names in the IndexFieldNames property is fixed
- Bug with processing macros named in Cyrillic is fixed
- Bug in TUniStoredProc with closing dataset when the Disconnected property is True is fixed
- Oracle data provider:
- Bug with loading data into column with TDateTime data type by UniLoader is fixed
- Bug with invalid backup progress in TUniBackup is fixed
- Bug with impossibility to edit query if it contains '(' inside quotes is fixed
- Bug with Filter and CHAR data type when UseUnicode=True is fixed
- Bug with getting data with CHAR type for Oracle 7 is fixed
- Bug with setting Charset property for Oracle client 9 & 10 is fixed
- Bug with AV in ApplyUpdates method in UniDataSet with not defined Session property is fixed
- SQLServer data provider:
- The Port specific option that allows specifying the port number for connection is added
- Bug with getting default field values when using not the default dbo schema is fixed
- MySQL data provider:
- Bug with dump BIGINT UNSIGNED fields is fixed
- Bug with resolving hostname on iOS device is fixed
- PostgreSQL data provider:
- Bug with SETOF REFCURSOR procedure parameters is fixed
- Bug with resolving hostname on iOS device is fixed
- InterBase data provider:
- Bug with datetime field default values is fixed
- ODBC data provider:
- Bug with AV on freeing a DLL linked statically is fixed
- Bug with trash symbols instead of empty string value is fixed
- MS Access data provider:
- Bug with parameters in master-detail relationship when QuoteNames=True is fixed
New in Universal Data Access Components 4.5.10 (Nov 7, 2012)
- Some improvements for NEXTGEN support are added
- Support for ftGraphic and ftFmtMemo parameter data types is added
- Informativity of messages about errors in connection is improved
- Dependency of design-time packages on FMX packages is removed
- Bug with data loss in pessimistic lock mode is fixed
- Bug with AV failure in RefreshQuick method is fixed
- Bug with renaming of fields with the same names is fixed
- Bug with dependency parameters count in macros on delimeter is fixed
- Bug with storing the LoginPrompt connection property is fixed
- Bug with dump data from VIEW is fixed
- Bug with creating columns on setting the TableName property in TDALoader is fixed
- Bug with setting specific connection options in the connection editor under Lazarus is fixed
- Several bugs in design-time editors are fixed
- Oracle data provider:
- Limitation on maximum 10 Oracle Homes is removed
- Bug with parameter length for UTF8 databases is fixed
- Bug with parameter length loaded from DFM is fixed
- Bug with LargeInt calculated fields is fixed
- Bug with refresh cursor with AutoClose=True is fixed
- Bug with LOB fields for Oracle 8.0.5 is fixed
- SQLServer data provider:
- The NativeClientVersion specific option to set the version of SQL Native Client provider is added
- Bug with using the NEWSEQUENTIALID() default expression is fixed
- Bug with inserting float values to real fields is fixed
- 'Range check error' when working with varbinary(max) or varchar(max) is fixed
- MySQL data provider:
- Support of interactive connections is added
- Support for binary parameters of stored procedures is added
- PostgreSQL data provider:
- Bug when processing domain type procedure parameters is fixed
- Bug with processing composite type fields is fixed
- Bug with executing a stored procedure when multiple default schema names are set in the connection is fixed
- Bug in the TPgQuery.BreakExec method is fixed
- SQLite data provider:
- Now the Direct mode is based on the SQLite engine version 3.7.14.1
- FTS3 and FTS4 support in the Direct mode is added
- NexusDB data provider:
- Support of NexusDB 3.11 is added
- Data Type Mapping support is added
- The HeartbeatInterval, LostConnectionTimeout and WatchdogInterval options for connection is added
- Bug with the filter timed out error is fixed
New in Universal Data Access Components 4.5.9 (Sep 11, 2012)
- Rad Studio XE3 is supported
- Windows 8 is supported
- Bug with storing empty MapRules collection in DFM is fixed
- Bug with AV failure at freeing connection, for which AssignConnect was executed, is fixed
- Oracle data provider
- Bug with getting Raw as String is fixed
- Bug with describing stored procedure parameters from a package in the Direct mode is fixed
- Bug with AV at releasing temporary Lobs is fixed
- InterBase & Firebird data provider
- Bug with reading BLOB data when using Firebird x64 in the Interbase data provider is fixed
- SQLite data provider
- Now the Direct mode is based on the SQLite engine version 3.7.13
- Extended error codes support is added
- Bug with memory leak when working in Direct mode is fixed
- Bug with the ForceCreateDatabase option when specifying a DB name without full path is fixed
- Bug with the DecryptDatabase method when setting connection for Delphi versions since Delphi 2009 is fixed
- Bug with low performance when executing the UPDATE SQL-statement in DirectMode is fixed
- Bug with changing DB page size (executing the sequence of instructions PRAGMA page_size + VACUUM) in DirectMode is fixed
- MS Access data provider
- Bug when mapping a TEXT field to ftString in Delphi versions since Delphi 2009 is fixed
New in Universal Data Access Components 4.3.8 (Jul 27, 2012)
- Bug with compilation for iOS is fixed
- Bug with Data Type Mapping and persistent fields is fixed
- Bug with Data Type Mapping to Bytes and VarBytes is fixed
- Bug with decryption of binary fields is fixed
- Bug with editing calculated fields is fixed
- Connection dialog is now open in the screen center instead of the desktop center
- Several bugs with compilation on Delphi XE2 from Source code are fixed
- SQLite data provider:
- Static linking of SQLite library is added
- SQLite database encryption is added
- The ForceCreateDatabase option is added
- Bug with compilation for iOS is fixed
- MySQL data provider:
- HTTP connection is added
- Oracle data provider:
- Bug with the ftCurrency, ftDate, ftTime parameter types is fixed
- Bug with detecting Oracle client version is fixed
- Bug with not resetting a statement index in UniScript after an error is fixed
- InterBase & Firebird data provider:
- Bug with setting a value with the TUniParam.AsShortInt method is fixed
- PostgreSQL data provider:
- Bug with application hang at connection loss is fixed
- Bug with infinite loop at UniAlerter stop after connection loss is fixed
- MS Access data provider:
- Bug with distinction between empty string and null is fixed
New in Universal Data Access Components 4.2.7 (Jun 24, 2012)
- Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
- Data Type Mapping support is added
- Data Encryption in a client application is added
- The TUniEncryptor component for data encryption is added
- Calling of the TCustomDASQL.BeforeExecute event is added
- Bug with executing a script that ends with a commented line is fixed
- Bug with assigning outsize data to TWideStringField is fixed
- Bug with DATE parameters in design-time is fixed
- Bug with TUniDump using an old connection after assigning a new connection is fixed
- Bug with AV failure at calling the SetRecNo method when using local sorting is fixed
- Bug in design time editor of the TVirtualTable component with master-detail relationship is fixed
- Oracle data provider:
- Bug with connection to Oracle XE with the UTF8 charset is fixed
- Bug with auto-generated queries for tables with case-sensitive fields in the Direct mode is fixed
- Bug with Connection Mode set for a connection that is established from UniScript is fixed
- Bug with statements count when a script contains the "Connect" command is fixed
- Bug with loading Unicode strings by TUniLoader is fixed
- IBDAC data provider:
- Bug with accessing InterBase 64-bit from a x64 application built in Delphi XE2 is fixed
- PostgreSQL data provider:
- Bug with getting metadata for PostgreSQL 7.x is fixed
- SQLite data provider:
- The ForeignKeys option is added to the SQLite specific connection options
- Bug with defining the VARCHAR field type larger than 4095 is fixed
- Bug with initialization of user-defined functions after TSQLiteConnection.AssignConnect is fixed
- ODBC data provider:
- Bug with result parameters in functions is fixed
New in Universal Data Access Components 4.1.6 (Apr 4, 2012)
- Lazarus 0.9.30.4 and FPC 2.6.0 are supported
- Bug with SQL Generator in the design-time is fixed
- Bug with generating Update SQL with fields that have aliases is fixed
- Bug with saving BCD fields from Virtual table to a Stream is fixed
- Bug with LocalMasterDetail is fixed
- Oracle data provider:
- Bug with filling fileds with Unicode names from Sequences in the Direct mode is fixed
- SQL Server data provider:
- Bug with pdInputOutput parameters is fixed
- PostgreSQL data provider:
- Bug with retrieving the list of tables from a case-sensitive schema is fixed
- ODBC data provider:
- Bug with the query that is generated for the QueryRecCount option is fixed
- SQLite data provider:
- Bug with Primary Keys that contain "." in name is fixed
New in Universal Data Access Components 4.1.4 (Dec 29, 2011)
- The UniqueFieldIndexSeparator global variable is added
- Bug with defining specific option with not defined ProviderName is fixed
- Bug with "Multiple transactions are not supported by the database" is fixed
- Bug with parsing the table names separated by comma in TUniDump is fixed
- Bug with assertion failure at proccesing the cached data is fixed
- Bug with Delphi IDE hanging at closing in case of using DBMonitor is fixed
- Bug with freeing memory in Lazarus is fixed
- Several bugs with 64-bit application development are fixed
- Several bugs in design-time editors are fixed
- Oracle data provider:
- Bug with memory leak and non-existing stored procedure in the Direct mode is fixed
- Bug with '(' and ')' application name in the Direct mode is fixed
- SQL Server data provider:
- Bug with generation the SQL query for data refresh, while FullRefresh is True and the macros is used, is fixed
- Bug with the stored procedures executing in SQL Azure is fixed
- Bug with GetProcedureList is fixed
- MySQL data provider:
- Improved performance of HTTP tunneling
- InterBase data provider:
- Bug with query containing 'UNION' clause that is generated for the QueryRecCount option is fixed
- PostgreSQL data provider:
- Reading the Bytes data type as Hex is supported
- SQLite data provider:
- Bug with UPDATE, when a key field is of the TEXT data type, is fixed in the SQLite data provider
- Lazarus 0.9.30.2 and FPC 2.4.4 are supported
New in Universal Data Access Components 4.1.3 (Dec 29, 2011)
- Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
- Mac OS X and iOS in RAD Studio XE2 is supported
- FireMonkey support is improved
- Lazarus 0.9.30.2 and FPC 2.4.4 are supported
- Mac OS X in Lazarus is supported
- Linux x64 in Lazarus is supported
- FreeBSD in Lazarus is supported
- Bug with memory leak in TDALoader is fixed
- Problem with receiving DateTime parameter for DBMonitor in Delphi 2009 and higher is fixed
- Oracle data provider:
- Oracle 11g Express Edition is supported
- Support for the NonBlocking option is added
- The QueryResultOnly option is added to TOraChangeNotification
- Conflict with size_t data type in C++Builder is resolved
- Bug with invalid password in the Direct mode for Windows 98 is fixed
- Bug with reading long ORACLE_HOME line from the registry is fixed.
- Bug with updating DatSet when LongStrings=False is fixed
- Bug with posting nested objects of the not final type is fixed
- SQL Server data provider:
- SQL Azure support is improved
- Bug with backing up BLOB fields is fixed
- Bug with query containing 'WITH' clause that is generated for the QueryRecCount option is fixed
- Bug with processing parameters values of which are set to the SqlTimestamp type is fixed
- InterBase data provider:
- Bug with query containing 'WITH' clause that is generated for the QueryRecCount option is fixed
- Bug with getting database info is fixed
- MySQL data provider:
- Bug with deleting record in FetchAll = False mode when LockMode is lmPessimistic is fixed
- PostgreSQL data provider:
- PostgreSQL 9.1 is supported
- Bug with time zone for time and timestamp data types is fixed
- Bug with PgDump with PostgreSQL 8.2 is fixed
- SQLite data provider:
- DateFormat and TimedFormat specific options are added in the SQLite data provider
- NexusDB data provider:
- Support of NexusDB 3.09 is added
- MS Access data provider:
- Type of the ExtendedAnsiSQL specific option is changed from Integer to Boolean
New in Universal Data Access Components 4.0.2.0 (Oct 21, 2011)
- SpecificOptions definition in the run-time is improved
- Bug with compilation for Linux in Lazarus is fixed
- Oracle data provider
- Bug with multi-dimension arrays is fixed
- Bug with getting attributes of inherited object types is fixed
- Bug with Lob parameters in the Direct mode if ParamType=ptUnknown is fixed
- MySQL data provider
- Bug with the QueryRecCount option queries containing the 'DISTINT' and 'AS' clauses is fixed
- PostgreSQL data provider
- Bug with Unicode password is fixed
- Bug with multiple default schemas definition is fixed
- InterBase data provider
- Bug with processing parameters values of which are of the SqlTimestamp type is fixed
- Bug with the QueryRecCount option queries containing ';' delimiter in query is fixed
New in Universal Data Access Components 4.0.1.0 (Oct 21, 2011)
- Embarcadero RAD Studio XE2 is supported
- Application development for 64-bit Windows is supported
- FireMonkey application development platform is supported
- Support of master/detail relationship for TVirtualTable is added
- OnProgress event in TVirtualTable is added
- TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string is added
- Bug with processing transaction when connection is lost is fixed
- MS Access data provider
- Exclusive access to databases in MSAccess provider is added
- Adaptive Server Enterprise data provider
- Ability to set ApplicationName in the ASE provider is added
- The AnsiNull option in the ASE provider is added
- Oracle data provider
- Bug with UniLoader for Number(1,0) data type is fixed
- Bug with Int64 data type for UniLoader in Oracle provider is fixed
- Bug with LOB parameters is fixed
- PostgreSQL data provider
- Bug with SQL query following an empty SQL query is fixed
- SQLite data provider
- Loading the sqlite3 library for Linux in SQLite provider is fixed
- Bug with Table name that contains "." in SQLite provider is fixed
New in Universal Data Access Components 3.70.0.19 (Oct 21, 2011)
- Bug in TCustomDADataSet.PSGetKeyFields method when persistent fields are created in dataset is fixed
- Bug in TUniTable with creating SQL query when Options.QuoteNames is set to True and provider is changed is fixed
- Bug with assertion failure on using master/detail relationship with TClientDataset is fixed
- Bug with several connections and when OCIUnicode=True for the Oracle data provider is fixed
- Bug with getting ServerList for the PostgreSQL data provider is fixed
- Bug with returning "not an error" for the SQLite data provider is fixed.
New in Universal Data Access Components 3.70.0.18 (Oct 21, 2011)
- Possibility to load data in TVirtualTable without recreating persistent fields is added
- Working in design time editor of the TVirtualTable component is improved
- Loading files opened by other applications is improved
- Bug with the "BAD HANDSHAKE" error on connecting to some versions of MySQL server in the MySQL provider is fixed
- Bug with processing key fields on record posting is fixed
- Bug with empty string parameters is fixed for ASE data provider
- Bug with DateTime parameter is fixed for ASE data provider
- Bug with "SQL statement doesn't return rows" is fixed for ASE data provider
- Several bugs with design-time editors for Lazarus are fixed
New in Universal Data Access Components 3.70.0.17 (May 6, 2011)
- Lazarus 0.9.30 and FPC 2.4.2 is supported
- New DBF provider is added
- Bug in bookmark validity check is fixed
- Oracle data provider:
- Oracle 9, Oracle 10, and Oracle 11 authentication in the Direct mode is supported
- Case sensitive login and password in the Direct mode is supported
- Unicode login and password in the Direct mode is supported
- Client Identifier in the Direct mode is supported
- Support of BLOB, CLOB, and NCLOB data types in TUniLoader is improved
- PostgreSQL data provider:
- Application Name connection option is supported
- Payload parameter for PostgreSQL notification is supported
- SQL Server data provider:
- Support for SQL Server Compact Edition 4.0 is added
- SQLite data provider:
- User-defined function for SQLite provider is supported
- Default UniNoCase collation for SQLite provider is added (the DefaultCollations specific option)
- Interface user-defined collation registration for SQLite provider is improved
- SQLite source version is fixed (missing .inc file is added)
- Bug with "SQLite function is not linked" in the SQLite data provider is fixed
- Adaptive Server Enterprise data provider:
- Support for the AnsiNull option in the ASE provider is added
- Bug with getting extended fields info in a transaction in the ASE data provider is fixed
New in Universal Data Access Components 3.60.0.16 (May 6, 2011)
- Delphi & C++Builder XE Starter Edition supported
- Added ability to get databases list in the NexusDB provider
- Fixed bug with access to several databases in the NexusDB provider
- Fixed bug with getting database info for 64-bit OS in the InterBase provider
- Fixed registration procedure of Borland SQL Monitor when TUniSQLMonitor is created at runtime
New in Universal Data Access Components 3.60.0.15 (Feb 10, 2011)
- Added NexusDB provider
- Added support for connection with using Service Name in the Direct mode in the Oracle provider.
- Added support for ASCII databases in the SQLite provider (the ASCIIDataBase specific option)
- Changed Collation and Encryption function calling in the SQLite provider (this function is moved to the TLiteUtils class in the SQLiteUniProvider unit)
- Improved performance in the PostgreSQL provider
- Improved Encryption function in the SQLite provider (it raised exception if database wasn't encrypted successfully)
- Fixed bug with parameters quoting by SQL Generator in the design-time in the SQLite provider
- Fixed memory leak in the SQLite provider
- Fixed bug with the Currency parameter type support in ODBC provider
- Fixed bug in TUniDump with backup boolean fields in the InterBase provider
- Fixed bug with processing Unicode in BLOB parameters in the InterBase provider
- Fixed bug with processing parameters of stored procedures in the InterBase provider
New in Universal Data Access Components 3.50.0.14 (Feb 10, 2011)
- Added encryption support in the SQLite provider
- Added calling the BeforeExecute event for the Open and Refresh dataset operations.
- Fixed the Detail dataset refreshing (for Master-Detail datasets) after connection loss in the LocalFailover mode
- Fixed bug with refreshing record for Master-Detail datasets
- Fixed bug when user's value was overridden by the sequence value in the smPost sequence mode in the Oracle provider
- Improved performance of INSERT, UPDATE, DELETE, and SELECT queries that return few records in the PostgreSQL provider
- Fixed sorting order for columns that contain NULL values if sort is defined by the IndexFieldNames property in the PostgreSQL provider
New in Universal Data Access Components 3.50.0.13 (Feb 10, 2011)
- PostgreSQL 9.0 supported
- Added checking that dataset is open on calling the TDataSet.Locate method
- Improved table names detecting inside SQL queries for the UpdatingTable property in the PostgreSQL provider
- Fixed bug with table or view names that contain single quotes (for example, 'name') in the PostgreSQL provider
- Fixed bug with selecting Unique Key instead of Primary Key as a Key field in the Oracle provider
- Fixed bug with fetching data in the Direct mode in the Oracle provider
- Fixed bug with updating NVARCHAR fields in the Direct mode with OCIUnicode=true in the Oracle provider
- Fixed bug with decoding data on loading XML
- Fixed bug in the Migration wizard with migrating parameters in the date format
- Fixed bug in Migration Wizard with adding unnecessary spaces
New in Universal Data Access Components 3.50.0.12 (Feb 10, 2011)
- Embarcadero RAD Studio XE suppored
- Fixed bug with AL32UTF8 and ZHS16GBK encoding for Oracle in OCI and Direct modes. Now field size and strings storing in these encodings is correct.
- Fixed bug with filling default expression for fields in the design mode for inactive dataset
- Fixed bug with the LIKE keyword in the TDataSet.Filter property
New in Universal Data Access Components 3.00.0.11 (Feb 10, 2011)
- Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
- Added the OnBeforeExecute event
- Added function ActiveMacroValueByName that returns macros value for the current data provider
- Added UTF sorting for the SQLite database
- Added support for extended SQL for MS Access (set the ExtendedAnsiSQL specific option to 1)
- Fixed bug with saving OleObjects for the Access database
- Fixed bug with processing parameters used in the BeforeUpdateExecute event handler
- Fixed bug with RefreshRecord and numbers with floating point
- Fixed bug in Migration Wizard with converting units in the UTF8 and UTF16 encoding
New in Universal Data Access Components 3.00.0.10 (Feb 10, 2011)
- Added ability to lock records in the CachedUpdate mode
- Added overloaded declaration of the ApplyUpdates method to choose update kind
- Fixed bug with quote that first character inside quoted string for the Filter property
- Fixed bug in TCRBatchMove with processing RecordCount
- Fixed UniLoader bug with loading data
- Fixed bug with processing added parameters in the BeforeUpdateExecute event handler
- Fixed bug with SSL connection to PostgreSQL
- Fixed bug with setting SpecificOptions for Lazarus
New in Universal Data Access Components 3.00.0.9 (Feb 10, 2011)
- Fixed bug with ODBC provider and Nexus DB that generates the "Option 5 not supported" message
- Fixed bug with ODBC provider when long strings were read with excess zeros (#0 char) inside.
- Fixed bug with the UNSIGNED BIG INT data type for SQLite database: now the UNSIGNED BIG INT data type is represented by TLargeintField
- Fixed bug with processing UniSQL in the TUniConnection.ExecProc method
- Fixed problem with processing TBCDField for SQL Server
New in Universal Data Access Components 3.00.0.8 (Feb 10, 2011)
- Added the BreakExec method
- Added support of ONLY lexeme in the FROM statement for PostgreSQL
- Fixed bug with comparing Date field values on optimistic locking
- Fixed bug in the AddWhere, DeleteWhere, SetOrderBy, and GetOrderBy methods for Tables
- Fixed bug with calculating RecNo in CachedUpdates mode
- Fixed bug with getting Database Info
- Fixed bug with "Insert into Table () values ()" when all fields are empty
- User_name in metadata changed to schema_name for SQL Server
New in Universal Data Access Components 3.00.0.7 (Feb 10, 2011)
- 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
New in Universal Data Access Components 3.00.0.6 (Feb 10, 2011)
- 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
New in Universal Data Access Components 3.00.0.5 (Dec 9, 2009)
- 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
New in Universal Data Access Components 3.00.0.4 (Dec 9, 2009)
- 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
New in Universal Data Access Components 3.00.0.3 (Dec 9, 2009)
- 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
New in Universal Data Access Components 3.00.0.2 (Oct 5, 2009)
- 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
New in Universal Data Access Components 2.70.0.8 (Jun 23, 2009)
- 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
New in Universal Data Access Components 2.70 (Jun 5, 2009)
New in Universal Data Access Components 2.00 (Feb 15, 2009)
- PostgreSQL support added
- 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