New Features in SDAC 11.1
New Features in SDAC 11.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 SQL Server 2022
- Added AddDateTimeFormat option for the Dump component
- 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
- LastInsertId property for TMSSQL and TMSQuery is added
New Features in SDAC 10.3
- 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 compatibility with Linked Server in MSSMS
- Improved the GetOrderBy method behavior
- Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
New Features in SDAC 10.2
- 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 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 the 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
- Added the CloneCursor method for Query and Table components that allows sharing data between datasets
- Improved the performance of exporting to XML
- Fixed bug with committing transaction on SQL Server 2000 in Direct mode
- Fixed bug with restricting the list of procedures using PROCEDURE_TYPE condition in Metadata component
- Fixed bug when a connection string parameter value contains a single quote
New Features in SDAC 10.1
- RAD Studio 11 Alexandria Release 1 is supported
- Lazarus 2.2.0 is supported
- Windows 11 is supported
- macOS Monterey is supported
- Passing the "client_interface_name" parameter to the server in the Direct mode is added
New Features in SDAC 10.0
- RAD Studio 11 Alexandria is supported
- macOS ARM is supported
- Added demo project for FastReport FMX
New Features in SDAC 9.4
- RAD Studio 10.4.2 Sydney is supported
- macOS 11 Big Sur is supported
- iOS 14 is supported
- Android 11 is supported
- LOB read/write performance in the Direct mode is improved
- Performance of batch operations is improved
- Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
New Features in SDAC 9.3
- SQL Server 2019 is supported
- Lazarus 2.0.10 and FPC 3.2.0 are supported
- Performance of Batch Insert, Update, and Delete operations is improved
New Features in SDAC 9.2
- RAD Studio 10.4 Sydney is supported
- Lazarus 2.0.8 is supported
- macOS 64-bit in Lazarus is supported
New Features in SDAC 9.1
- Android 64-bit is supported
- Lazarus 2.0.6 is supported
- TLS 1.2 support in the Direct mode is added
- Now Trial edition for macOS and Linux is fully functional
- The connection option MultiSubnetFailover for the MSOLEDB provider is added
- Use of the Server property that contains Port in the Direct mode is added
- Updating data after invoking the Refresh method is fixed
New Features in SDAC 9.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 SDAC 8.3
- Lazarus 2.0.2 is supported
- Working with multiple threads sharing a single connection is supported
- The DefaultSortType property for TVirtualTable is added
- Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
New Features in SDAC 8.2
- RAD Studio 10.3 Rio is supported
- TfrxSDACDatabase.DefaultLockTimeout property is added
- QuoteNames option in TMSLoader to escape field names is added
- Support of UPPER and LOWER functions for Unified SQL is added
New Features in SDAC 8.1
- Lazarus 1.8.4 is supported
- MARS in TDS is supported
- NonBlocking mode in TDS is supported
- Query notifications in TDS are supported
- TCustomMSDataSet.CommandTimeout property in TDS is supported
- Performance of batch operations is improved
- Demo projects for IntraWeb 14 are added
New Features in SDAC 8.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
New Features in SDAC 7.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
- The TMSLoaderOptions.FireTrigger property is added
- SmartFetch mode in Disconnected mode is supported
- Data Type Mapping performance is improved
- Performance of TDALoader on loading data from TDataSet is improved
New Features in SDAC 7.2
- RAD Studio 10 Seattle is supported
- Now Trial for Win64 is a fully functional Professional Edition
- INSERT, UPDATE and DELETE batch operations are supported
New Features in SDAC 7.1
- RAD Studio XE8 is supported
- AppMethod is supported
- 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
New Features in SDAC 7.01
- Direct Mode is supported
- Mac OS X is supported
- iOS is supported
- Android is supported
New Features in SDAC 6.11
- RAD Studio XE7 is supported
- Lazarus 1.2.4 is supported
- The TCustomDADataSet.GetKeyFieldNames method is added
- The ConstraintColumns metadata kind for the TMSMetadata component is added
New Features in SDAC 6.10
- RAD Studio XE6 is supported
- Lazarus 1.2.2 and FPC 2.6.4 is supported
- SQL Server 2014 is supported
- SmartFetch mode for TDataSet descendants is added
- The TMSDataSetOptions.MasterFieldsNullable property is added
- Now update queries inside TDataSet descendants have correct owner
New Features in SDAC 6.9
- 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
- The TMSConnection.AutoCommit property is added
- Default values of UNIQUEIDENTIFIER fields without curly brackets are supported
New Features in SDAC 6.8
- RAD Studio XE5 is supported
- Lazarus 1.0.12 is supported
- Performance is improved
- Automatic checking for new versions is added
- Flexible management of conditions in the WHERE clause is added
- The possibility to use conditions 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
- The possibility to use ranges is added
- The Ping method for the TMSConnection component is added
- The AllowImplicitConnect option for the TMSConnection component is added
- The ForceCreateDatabase option for the TMSConnection is added
- The ApplicationIntent option for the TMSConnection is added
- The SQLRecCount property for the TMSQuery and TMSStoredProc components is added
- The ScanParams property for the TMSScript component is added
- The RowsAffected property for the TMSScript component is added
New Features in SDAC 6.7
- Rad Studio XE4 is supported
- FPC 2.6.2 and Lazarus 1.0.8 are supported
- Connection string support is added
- Now the TCustomMSDataSet.Options.UniqueRecords property is set to True by default
- The TCustomMSDataSet.Options.HideSystemUniqueFields property is added
- Possibility to encrypt entire tables and datasets is added
- Possibility to determine if data in a field is encrypted is added
- Support for TimeStamp, Single and Extended fields in VirtualTable is added
New Features in SDAC 6.6
- Rad Studio XE3 Update 1 is now required
- C++Builder 64-bit for Windows is supported
- TMSConnection.Port property that allows specifying the port number for connection is added
New Features in SDAC 6.5
- Rad Studio XE3 is supported
- Windows 8 is supported
New Features in SDAC 6.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 SDAC 6.1
- Update 4 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
- FireMonkey support is improved
- Lazarus 0.9.30.4 and FPC 2.6.0 are supported
New Features in SQL Server Data Access Components 6.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
New Features in SQL Server Data Access Components 5.10
- Lazarus 0.9.30 and FPC 2.4.2 is supported
- Support for Table-Valued Parameters is added
- TMSTableData component for storing data of Table-Valued Parameter type is added
- Support for SQL Server Compact Edition 4.0 is added
- Support of API interface for managing FILESTREAM data is added
New Features in SQL Server Data Access Components 5.00
- Embarcadero RAD Studio XE suppored
New Features in SQL Server Data Access Components 4.80
- Embarcadero RAD Studio 2010 supported
New Features in SQL Server Data Access Components 4.70
- 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
New Features in SQL Server Data Access Components 4.50
- Added compatibility with UniDAC
- Improved support of default field values
- Added ability to specify key fields for a dataset
- Added support of automatic records locking
- Added an option for setting lock wait timeout
New Features in SQL Server Data Access Components 4.35
- SQL Server Compact Edition 3.5 supported
- Tested with SQL Server 2008 CTP 4
New Features in SQL Server Data Access Components 4.30
New Features in SQL Server Data Access Components 4.10
- C++Builder 2007 supported
New Features in SQL Server Data Access Components 4.00
New functionality:
- Delphi 2007 for Win32 supported
- Implemented Disconnected Model for working offline and automatically connecting and disconnecting
- Implemented Local Failover for detecting connection loss and implicitly re-executing some operations
- Added DataSet Manager to control project datasets
- New TMSScript component for easy execution of multistatement scripts with the following features added:
- Support for executing individual statements in scripts
- Support for executing huge scripts stored in files with dynamic loading
- Support for using standard SQL Server client tool syntax
- New TMSServiceBroker component for SQL Server 2005 queuing and reliable messaging added
- New TCRBatchMove component for transferring data between all types of TDataSet descendants added
- New TMSDump component for loading data to and from the server added
- Support for data export and M:Devart.Dac.TVirtualTable.LoadFromFile(System.String,System.Boolean) to/from XML
- WideMemo field type in Delphi 2006 supported
- Support for sending messages to DBMonitor from any point in your program added
- Added asynchronous execute and fetch modes
- Compressed BLOB support
Support for more SQL Server functionality:
Extensions and improvements to existing functionality:
- General performance improved
- Master/detail functionality extensions:
- Local master/detail relationships support added
- Master/detail relationships in CachedUpdates mode support added
- Working with calculated and lookup fields improvements:
- Local sorting and filtering added
- Record location speed increased
- Improved working with lookup fields
- Greatly increased performance of applying updates in CachedUpdates mode
- Connection pool functionality improvements:
- Efficiency significantly improved
- API for draining the connection pool added
- Ability to customize update commands by attaching external components to TMSUpdateSQL objects added
- Support for DefaultValues on record insertion added
- Some performance improvements achieved:
- NUMERIC fields fetching
- Improved performance of executing Update commands while editing a dataset
- DataSet refreshing
- Record refreshing after updates and inserts
- Support for selecting database name in TMSConnectDialog component
Usability improvements:
New Features in SQL Server Data Access Components 3.80
- Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ supported
New Features in SQL Server Data Access Components 3.70
- Support for Delphi 2006 added
- Support for SQL Server 2005 added
New Features in SQL Server Data Access Components 3.55
- Ability of automatic preparing query with TCustomDADataSet.Options.AutoPrepare property added
- Ability to synchronize position at different DataSets with TCustomDADataSet.GotoCurrent method added
- Optimized MSSQLMonitor BLOB parameters processing
- Improved behavior on editing master key on Master/Detail relation
New Features in SQL Server Data Access Components 3.50
- Support for Delphi 2005 added
- Support for SQL Server 2005 beta 2 added
- Guid fields support for VirtualTable added
New Features in SQL Server Data Access Components 3.00
- Support for Delphi 8 added
- Local sorting ability with TMemDataSet.IndexFieldNames added
- Connection pooling support
- TCRDBGrid sources in Standard edition
- MSDataAdapter component added
- .NET Windows Forms demo project added
- ASP.NET demo project added
- TMSConnection.GetStoredProcNames, GetTableNames, GetDatabaseNames added
- TMSConnection.ClientVersion, ServerVersion added
- Milliseconds support added
New Features in SQL Server Data Access Components 2.45.2
- Methods TMSSQL.BreakExec and TCustomMSDataSet.BreakExec added
- Property TMSConnection.Options.AutoTranslate added
- Method ExecSQL in TMSConnection added
- Methods GetTableNames and GetDatabaseNames in TMSConnection added
- Unicode support for Locate on Win9x added
New Features in SQL Server Data Access Components 2.45
- Property MSConnection.Options.WorkstationID added
- Performance to insert large BLOBs improved
- Performance significantly improved
- Event TMSConnection.OnInfoMessage added
- Multiple Errors support added
- Property MSConnection.Options.ApplicationName added
- Property TBlob.AsWideString added
- Parameters parsing improved. Symbol ':' in string literals is ignored
- Network error processing improved
- Performance demo added
New Features in SQL Server Data Access Components 2.40
- WideString support added
- Property MSDataSet.Options.QuoteNames added
- Property MSConnection.Options.KeepDesignConnected added
- Property MSConnectDialog.StoreLogInfo published
New Features in SQL Server Data Access Components 2.35
- Speed optimization for opening small queries
- MSConnection.Options added
- Limited MSConnection.ConnectString support added
- Output string and (var)bytes parameters are now obtained from the server with the maximum length not depending on set Param.Size
- DBMonitor client implementation moved to COM server
New Features in SQL Server Data Access Components 2.30
- Delphi 7 supported
- New memory management model for ftString and ftVarBytes types added
- Support for blob fields in CachedUpdates mode added
New Features in SQL Server Data Access Components 2.05
New Features in SQL Server Data Access Components 2.00
- Server cursors supported
- Queries with Multiple Result Sets supported
- Performance improved
- Opening queries without fetching all rows to client (FetchAll = False) supported
- UniDirectional support added
- Quick getting Identity value
- Refresh supported for StoredProc
- FullRefresh supported
- Check for old row values while executing Update and Delete added
- Changed behavior on close connection with open transaction from Commit to Rollback
New Features in SQL Server Data Access Components 1.30
New Features in SQL Server Data Access Components 1.20
- Added TMSParam class to represent parameters
- Query Analyzer and Enterprise Manager integration added
- Accelerated getting identity value on refresh