New Features in UniDAC 10.1
Oracle data provider
- Added support for connect to servers with enabled Security Banners in the Direct mode
- Improved error message about a non-existent database object in another schema
PostgreSQL data provider
- Improved work with column default values
- Improved work with RefreshRecord queries
- Improved work with arrays in queries
InterBase data provider
- Added support for Firebird 5 (InterBase provider)
- Added support for multiple rows being returned by DML with the RETURNING clause
SQLite data provider
- The RealAsDouble option for the Connection component is added
DBF data provider
- Added support for the UTF8 encoding
- Added support for tables with duplicate column names
- Improved compatibility with Quantum GIS
- Improved error handling when using the IgnoreDataErrors option
NexusDB data provider
- Added support of NexusDB 4.75.01
MS Access data provider
- Added support for Direct mode
DB2 data provider
- Added support SSL connection
New Features in UniDAC 10.0
- 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
- Added support of NexusDB 4.75.01
Oracle data provider
- Added support for Oracle 23c
- Improved UnicodeEnvironment support for non-Unicode Delphi versions
SQLServer data provider
- Added support for SQL Server 2022
- Added support for LastInsertID
- Added DisableConstraints specific option for the Dump component
- Added AddDateTimeFormat specific option for the Dump component
MySQL data provider
- Added support for MariaDB 11
- Added support for mysql_clear_password authentication mechanism
PostgreSQL data provider
- Added support for PostgreSQL 16
- Added support for PREPARE/EXECUTE commands
- Added several specific options for the Dump component
InterBase data provider
- Added support for iOS Simulator ARM 64-bit target platform
SQLite data provider
- Now the Direct mode is based on version 3.42.0 of the SQLite engine
DBF data provider
- Performance of DML operations is significantly improved
- Added support for CREATE TABLE IF NOT EXISTS and DROP TABLE IF EXISTS statements
- Added support for the CREATE TABLE AS SELECT statement
NexusDB data provider
- Added support of NexusDB 4.75.01 (NexusDB provider)
MongoDB data provider
- Added support for MongoDB 7
- Added support for MongoDB 6
- Added support for empty database name when establishing connection
- Improved compatibility with Linked Server in MSSMS
ODBC data provider
- Information from SQLGetInfo is added to ODBCMetaData (ODBC provider)
New Features in UniDAC 9.4
- Added support for RAD Studio 11 Alexandria Release 3
- Added support for iOS Simulator ARM 64-bit 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 Features in UniDAC 9.3
- 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 19 for SQL Server
- 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 Features in UniDAC 9.2
- RAD Studio 11 Alexandria Release 1 is supported
- Lazarus 2.2.0 is supported
- Windows 11 is supported
- macOS Monterey is supported
PostgreSQL data provider
- The AddDelete specific option for the Dump component is added
- Dumping of stores procedures via the Dump component is added
- The SCRAM-SHA-256-PLUS authentication mechanism is supported
- "ON CONFLICT" in batch operations is supported
- Open connection performance is improved
SQLite data provider
- Now the Direct mode is based on version 3.37.2 of the SQLite engine
SQL Server data provider
- Passing the "client_interface_name" parameter to the server in the Direct mode is added
New Features in UniDAC 9.1
- The PoolId connection pool option is added
DBF data provider
- FSIZE SQL function is supported
- Autoinc data type for dfVisualFoxPro tables is supported
PostgreSQL data provider
- PostgreSQL 14 is supported
- OUT parameters in stored procedures for PostgreSQL 14 are supported
InterBase data provider
- The WireCompression option for the Connection component is added
Nexus DB data provider
- Block fetch is supported
- Fetch performance is improved
New Features in UniDAC 9.0
- RAD Studio 11 Alexandria is supported
- macOS ARM is supported
- Added demo project for FastReport FMX
InterBase data provider
SQLite data provider
- Added the IntegerAsLargeInt option for the Connection component
NexusDB provider
- NexusDB 4.50.27 is supported
Google BigQuery data provider
- Added the Google BigQuery provider
HubSpot data provider
- Added the HubSpot provider
New Features in UniDAC 8.4
- RAD Studio 10.4.2 Sydney is supported
- macOS 11 Big Sur is supported
- iOS 14 is supported
- Android 11 is supported
- Performance of batch operations is improved
- Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
- The UseUnicode option in the VirtualQuery component is added
Oracle data provider
- Oracle 21c is supported
- The PrefetchRows option in the Direct mode is supported
- Data fetch performance in the Direct mode is improved
- LOB read/write performance is improved
SQLServer data provider
- LOB read/write performance in the Direct mode is improved
PostgreSQL data provider
- PostgreSQL 13 is supported
- Work in a multi-threaded environment through a single connection is supported
- The MultipleConnections option in the Connection component is added
InterBase data provider
- Over-the-Wire (OTW) encryption is supported
- Automatic detection of computed fields when generating update statements is improved
- Memory consumption in batch operations is reduced
SQLite data provider
- The LockingMode specific option in the Connection component is added
- The Synchronous specific option in the Connection component is added
- The JournalMode specific option in the Connection component is added
- Performance with default values of the new options is significantly improved
ASE data provider
- The TextSize specific option is added
DBF data provider
- The IgnoreIndexErrors specific option in the Connection component is added
- Performance of reading and writing MEMO and BLOB values is improved
- Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved
ODBC data provider
- Data fetch performance is improved
- LOB read/write performance is improved
New Features in UniDAC 8.3
- 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
SQL Server data provider
- SQL Server 2019 is supported
DBF data provider
- Native dBase functions in a SQL statement are supported
ODBC data provider
- Error message retrieving from SQL Anywhere ODBC driver is improved
New Features in UniDAC 8.2
- RAD Studio 10.4 Sydney is supported
- Lazarus 2.0.8 is supported
- macOS 64-bit in Lazarus is supported
Oracle data provider
- Mapping the FLOAT Oracle data type to the ftNumber field is added
PostgreSQL data provider
- The Line geometric type is supported
DBF data provider
- The AllFieldsAsNullable specific option is added
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
New Features in UniDAC 8.1
- Android 64-bit is supported
- Lazarus 2.0.6 is supported
- Now Trial edition for macOS and Linux is fully functional
Oracle data provider
- Oracle 19c is supported
- Long database object names is supported
SQLServer data provider
- TLS 1.2 support in the Direct mode is added
- The connection option MultiSubnetFailover for the MSOLEDB provider is added
- Use of the Server property that contains Port in the Direct mode is added
MySQL data provider
- OpenSSL 1.1 library is supported
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
MongoDB data provider
- The LowerCaseObjectId specific option for the Connection component is added
DBF data provider
- The IdentifierCase specific option is added
- The cmUnsafe value for the ConnectMode specific option is added
New Features in UniDAC 8.0
- macOS 64-bit is supported
- Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
New Features in UniDAC 7.5
- Lazarus 2.0.2 is supported
- The DefaultSortType property for TVirtualTable is added
- Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
New Features in UniDAC 7.4
- RAD Studio 10.3 Rio is supported
- Support of UPPER and LOWER functions for Unified SQL is added
Oracle data provider
- Oracle 18c is supported
- Implicit result sets in Oracle 12 are supported
SQLServer data provider
- QuoteNames option in TUniLoader to escape field names is added
MySQL data provider
- Support for PAM and Windows authentications is added
InterBase data provider
- Possibility to write large blobs by pieces is added
PostgreSQL data provider
- PostgreSQL 11 is supported
SQLite data provider
- Support for the BreakExec method in the Query component is added
DBF data provider
- Detection of the file format when the DBFFormat option is set to dfAuto is improved
- Work with databases which contain a large number of files is improved
BigCommerce data provider
- OAuth authentication is supported
New Features in UniDAC 7.3
- Lazarus 1.8.4 is supported
- Performance of batch operations is improved
- Demo projects for IntraWeb 14 are added
- AutoOpenSources option for TVirtualQuery is added
- OfflineMode option for TVirtualQuery is added
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
SQLServer data provider
- MARS in TDS is supported
- NonBlocking mode in TDS is supported
- Query notifications in TDS are supported
MySQL data provider
- MySQL 8 is supported
- Support for sha2_password, caching_sha2_password authentications is added
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
PostgreSQL data provider
- Support for HTTP/HTTPS tunnel is added
SQLite data provider
- WAL in the Direct Mode for non-Windows platforms is supported
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
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
ZohoCRM data provider
New Features in UniDAC 7.2
- 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
Redshift data provider
- Amazon Redshift provider is added
SQLServer data provider
- Windows authentication in the Direct mode is supported
MySQL data provider
- Support for backup/restore of triggers and stored procedures is added
InterBase data provider
- Loading of the default client library for 64-bit applications is improved
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
DB2 data provider
- Compatibility with DB2 version 11 is improved
New Features in UniDAC 7.1
- 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
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
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
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
DBF data provider
- The CodePage specific options are added
- The ConnectMode specific options are added
DB2 data provider
- The DECFLOAT data type is supported
New Features in UniDAC 7.2
- 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
Redshift data provider
- Amazon Redshift provider is added
SQLServer data provider
- Windows authentication in the Direct mode is supported
MySQL data provider
- Support for backup/restore of triggers and stored procedures is added
InterBase data provider
- Loading of the default client library for 64-bit applications is improved
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
DB2 data provider
- Compatibility with DB2 version 11 is improved
New Features in UniDAC 7.1
- 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
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
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
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
DBF data provider
- The CodePage specific options are added
- The ConnectMode specific options are added
DB2 data provider
- The DECFLOAT data type is supported
New Features in UniDAC 7.0
-
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
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
-
Now the Direct mode is based on the SQLite engine version 3.17.0
-
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
Interbase data provider
-
Possibility to manage batch operations using a transaction is added
-
Possibility to obtain active transaction number using DBMonitor is added
SQLite data provider
-
Now the Direct mode is based on the SQLite engine version 3.17.0
NexusDB data provider
-
Support for using ConnectionString is added
-
Support for using the TfmtBCD fields is added
-
Support for the SmartFetch mode is improved
MongoDB data provider
-
New MongoDB provider is added
DBF data provider
New Features in UniDAC 6.4
-
TVirtualQuery component is added
-
TDADataSetOptions.InsertAllSetFields property is added
SQL Server data provider
-
Support for IPv6 protocol in Direct Mode is added
New Features in UniDAC 6.3
-
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
-
Performance of TDALoader on loading data from TDataSet is improved
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
-
macOS is supported
-
iOS is supported
-
Android 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 Features in UniDAC 6.2
-
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 Features in UniDAC 6.1
-
RAD Studio XE8 is supported
-
AppMethod is supported
-
The ParamCheck option behavior 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
SQL Server 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"
InterBase data provider
-
Firebird 3 support is added
-
Firebird 3 BOOLEAN column type support is added
PostgreSQL data provider
-
PostgreSQL 9.4 support is added
SQLite data provider
-
Direct mode for macOS, iOS and Android platforms is supported
-
Database encryption for macOS, iOS and Android platforms is supported
-
Now the Direct mode is based on the SQLite engine version 3.8.9
ODBC data provider
-
ODBC provider for Lazarus is added for Unix platforms
New Features in UniDAC 6.0
SQL Server data provider
-
Direct Mode is supported
-
macOS is supported
-
iOS is supported
-
Android is supported
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
NexusDB data provider
-
Nexus Embedded support is added
ASE data provider
-
Ability to set CharSet is added
DB2 data provider
-
Support for 64-bit client is added
New Features in UniDAC 5.5
-
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 ConstraintColumns metadata kind for the TDAMetadata component is added
Oracle data provider
-
RAC server support is improved
-
Support for WITH FUNCTION clause for Oracle 12c is added
-
The HideRowId option is added
InterBase data provider
-
The OldTransactionBehaviour global variable is added
SQLite data provider
-
Now the Direct mode is based on the SQLite engine version 3.8.6
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 Features in UniDAC 5.3
-
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
Oracle data provider
-
DataTypeMapping conversion from XMLType to ftString is added
-
DataTypeMapping conversion from Interval to ftString is added
SQL Server data provider
-
SQL Server 2014 is supported
InterBase data provider
-
TUniTransaction.OnCommitRetainig and TUniTransaction.OnRollbackRetainig events are added
SQLite data provider
-
Now the Direct mode is based on the SQLite engine version 3.8.4.3
ASE data provider
-
The PrepareMethod option is added
New Features in UniDAC 5.2
-
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
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)
SQLite data provider
-
Direct mode for x64 platform is supported
New Features in UniDAC 5.1
-
RAD Studio XE5 is supported
-
Application development for Android is supported
-
Lazarus 1.0.12 is supported
-
Automatic checking for new versions is added
-
Flexible management of conditions in the WHERE clause is added
-
The possibility to use conditions is added
-
Performance is improved
-
IPv6 protocol support is added
-
Migration from FIBPlus is added
-
The possibility to use ranges is added
-
The AutoCommit property for the Connection component 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
Oracle data provider
-
The UROWID data type is supported in the Direct mode
SQL Server data provider
-
The CursorType specific option is added
MySQL data provider
InterBase data provider
-
Now Params specific option values for TUniTransaction can be separated by a semicolon
-
The ForceUsingDefaultPort global variable is added
PostgreSQL data provider
-
PostgreSQL 9.3 is supported
SQLite data provider
-
Now the Direct mode is based on the SQLite engine version 3.8.0
-
The AutoCommit and AutoCommitRowCount TUniLoader specific options
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
MS Access data provider
-
The ForceCreateDatabase option is added
NexusDB data provider
-
NexusDB 3.12 is supported
New Features in UniDAC 5.0
-
Rad Studio XE4 is supported
-
NEXTGEN compiler is supported
-
Application development for iOS is supported
-
FPC 2.6.2 and Lazarus 1.0.8 are 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
Oracle data provider
-
BINARY_DOUBLE & BINARY_FLOAT data types support in the Direct mode is added
MySQL data provider
-
SSL support in macOS 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 macOS 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
DB2 data provider
-
XML fields support is added
New Features in UniDAC 4.6
-
Rad Studio XE3 Update 1 is now required
-
C++Builder 64-bit for Windows is supported
SQLServer data provider
-
The Port specific option that allows specifying the port number for connection is added
New Features in UniDAC 4.5
-
Rad Studio XE3 is supported
-
Windows 8 is supported
New Features in UniDAC 4.2
-
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 TMSEncryptor component for data encryption is added
-
Calling of the TCustomDASQL.BeforeExecute event is added
New Features in UniDAC 4.1
-
Update 4 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
-
macOS and iOS in RAD Studio XE2 is supported
-
FireMonkey support is improved
-
Lazarus 0.9.30.4 and FPC 2.6.0 are supported
-
macOS in Lazarus is supported
-
Linux x64 in Lazarus is supported
-
FreeBSD in Lazarus is supported
Oracle data provider
-
Oracle 11 Express Edition is supported
-
Support for the NonBlocking option is added
-
The QueryResultOnly option is added to TOraChangeNotification
PostgreSQL data provider
-
PostgreSQL 9.1 is supported
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
New Features in Universal Data Access Components 4.00
-
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
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
New Features in Universal Data Access Components 3.70
-
Lazarus 0.9.30 and FPC 2.4.2 is supported
-
New DBF provider is added
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)
Adaptive Server Enterprise data provider
-
Support for the AnsiNull option is added
New Features in Universal Data Access Components 3.60
-
NexusDB provider
-
PostgreSQL 9.0 supported
-
Improved performance in the PostgreSQL provider
-
Encryption support in the SQLite provider
-
Support for connection with using Service Name in the Direct mode in the Oracle provider
-
Support for ASCII databases in the SQLite provider (the ASCIIDataBase specific option)
New Features in Universal Data Access Components 3.50
-
Embarcadero RAD Studio XE suppored
-
TUniAlerter component
-
Collation and UTF sorting support in the SQLite provider
-
Support for dbMonitor 3
-
Support for extended SQL for MS Access (set the ExtendedAnsiSQL specific option to 1)
-
Support of ONLY lexeme in the FROM statement for PostgreSQL
-
Ability to lock records in the CachedUpdate mode
-
Ability to use Access system database added
-
Ability to send call stack information to the dbMonitor component
-
Now setting the SetFieldsReadOnly option to False makes all fields not readonly
New Features in Universal Data Access Components 3.00
-
DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and other databases (using ODBC provider) support added
-
Embarcadero RAD Studio 2010 supported
New Features in Universal Data Access Components 2.70
New Features in Universal Data Access Components 2.50
-
Unified SQL support
Unified SQL allows to write truly database-independent SQL code. Unified SQL includes:
-
Macros - in Unified SQL macros can evaluate to a different value depending on the provider used by the TUniConnection component.
-
If - for the purpose of extra flexibility Unified SQL supports conditional inclusion of SQL code into resulting statements using {if} directive. This allows to set different SQL for different DBMS.
-
Functions - introduce standard for calling common SQL functions. In run time function is transformed either to the corresponding native function, or to an equivalent expression.
-
Literal - provides universal syntax for date, time, and timestamp literals.
-
TUniLoader component
serves for fast loading of data to the database. For each type of database server TUniLoader uses its specific interfaces for loading with maximum speed. For example, Oracle Direct Path Load interface is used for Oracle.
-
TUniDump component
serves to store data from tables or editable views as a script and to restore data from a received script.
-
TUniConnection.AssignConnect method
shares physical connection between several TUniConnection components
-
Added support for Free Pascal under Linux
-
Added NoPreconnect property to TUniScript for executing CONNECT and CREATE DATABASE commands
-
Added DMLRefresh support in the PostgreSQL provider
New Features in Universal Data Access Components 2.00
New Features in Universal Data Access Components 1.20
-
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