Softpedia >Windows >Programming >Components & Libraries >SQL Server Data Access Components >  Changelog

SQL Server Data Access Components Changelog

What's new in SQL Server Data Access Components 11.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 SQL Server Data Access Components 11.2.0 (Apr 24, 2024)

  • Added support for RAD Studio 12 Athens Release 1
  • Added support for Lazarus 3.2
  • 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

New in SQL Server Data Access Components 11.1.0 (Feb 19, 2024)

  • Lazarus 3.0 is supported
  • Fixed bug with preparing Stored Procedure execution
  • Fixed bug with setting parameter values on record posting
  • Fixed bug with SQL Generator in the design-time when the database name must be quoted

New in SQL Server Data Access Components 11.0.0 (Nov 15, 2023)

  • Added support for RAD Studio 12
  • Added support for SQL Server 2022
  • Added support for macOS Sonoma
  • Added support for iOS 17
  • Added support for Android 13
  • 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
  • Fixed bug with connecting to the default instance
  • Fixed bug with "Wrong amount of parameters N in TableName" when the TableName contains spaces
  • Fixed bug with detecting parameter names
  • 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

New in SQL Server Data Access Components 10.3.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 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
  • 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

New in SQL Server Data Access Components 10.2.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 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 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 in SQL Server Data Access Components 10.1.1 (Apr 12, 2022)

  • RAD Studio 11.1 Alexandria is supported
  • Lazarus 2.2.0 is supported
  • Windows 11 is supported
  • Passing the "client_interface_name" parameter to the server in the Direct mode is added
  • Fixed bug with adding a condition to the WHERE clause on calling the AddWhere method
  • Fixed bug with a "Cannot modify a read-only dataset" on Delete where all fields are read-only
  • Fixed bug with executing batch operations when constants in parameters
  • Fixed bug with resetting param values when changing param values count
  • Fixed bug with getting IndexColumns metadata in the Direct mode
  • Fixed bug with removing persistent fields in Android
  • Fixed bug with AV when encrypting a field
  • Fixed bug with HTTPS tunneling in the Direct mode
  • Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

New in SQL Server Data Access Components 10.0.2 (Dec 10, 2021)

  • The PoolId connection pool option is added
  • 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
  • Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
  • Fixed bug with freezing multiply connection pools in threads
  • 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

New in SQL Server Data Access Components 10.0.1 (Sep 14, 2021)

  • RAD Studio 11 Alexandria is supported
  • Added demo project for FastReport FMX
  • Fixed bug with using the NonBlocking mode from threads
  • Fixed bug with Varchar(max), NVarchar(max), Text and NText OUT parameters
  • 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 comp

New in SQL Server Data Access Components 9.4.3 (Apr 7, 2021)

  • Bug a string parameter getting trimmed is fixed
  • Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

New in SQL Server Data Access Components 9.4.2 (Mar 26, 2021)

  • Lazarus 2.0.12 is supported
  • Bug with the data type mapping of varbinary fields is fixed
  • 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

New in SQL Server Data Access Components 9.4.1 (Mar 3, 2021)

  • 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
  • Bug with setting the ReadOnly field property at runtime is fixed
  • Bug with 'Range check error' in the Direct mode is fixed
  • Bug with getting the list of server names is fixed
  • Bug with string data getting truncated in TMSLoader is fixed
  • Bug with converting memo fields to the local encoding is fixed
  • Bug with "Session ID is not found" when starting a transaction in the Direct mode is fixed
  • Bug with "c0000091 FLOAT_OVERFLOW" when fetching records in SQL Server Compact Edition is fixed
  • Bug with rounding DATE values is fixed
  • Bug with describing date params in the Direct mode is fixed

New in SQL Server Data Access Components 9.3.2 (Sep 15, 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
  • 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

New in SQL Server Data Access Components 9.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
  • 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

New in SQL Server Data Access Components 9.3.1 (Aug 27, 2020)

  • 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
  • Failure to connect in the Direct mode with different credentials after unsu�cessful initial connection attempt is fixed

New in SQL Server Data Access Components 9.2.4 (Jun 3, 2020)

  • RAD Studio 10.4 Sydney is supported
  • Lazarus 2.0.8 is supported
  • macOS 64-bit in Lazarus is supported
  • Bug with setting a value for the TrustServerCertificate option is fixed
  • Bug with switching databases in Direct mode 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

New in SQL Server Data Access Components 9.1.3 (Mar 11, 2020)

  • Bug with installing different editions of two or more DAC's in a single system is fixed
  • The UuidWithBraces option is added
  • Performance of loading data with TMSLoader in Direct mode is improved
  • Bug with reconnecting to the server is fixed
  • Bug with connecting after a server connection failure is fixed
  • Bug with assertion failure when opening datasets is fixed
  • Bug with opening several datasets in batch is fixed
  • Bug with performing a TLS 1.2 handshake during connection attempt to the server is fixed
  • Bug with getting the value of the RETURN_VALUE parameter from SP 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
  • Bug with the "Function is not linked" error when connecting to the server on iOS is fixed

New in SQL Server Data Access Components 9.1.2 (Nov 26, 2019)

  • 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
  • Bug with connecting to SQL Server 2000 in Direct mode is fixed
  • Bug with the NativeClientVersion connection option being set from ConnectionString is fixed
  • Bug with AV failure when using encryption is fixed
  • Bug with using the FieldOrigins property 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
  • Several bugs that occurred when using DataSet Manager are fixed

New in SQL Server Data Access Components 9.0.1 (Jul 23, 2019)

  • MacOS 64-bit is supported
  • Update 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
  • Bug with the "StoredProc has too many arguments specified" error when executing SP is fixed
  • Bug with using the AsMemo method in batch operations is fixed

New in SQL Server Data Access Components 8.3.10 (Jun 24, 2019)

  • 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
  • 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 datetime value is fixed
  • Bug with using the FieldOrigins property is fixed
  • 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

New in SQL Server Data Access Components 8.2.9 (Jan 21, 2019)

  • Bug with the "Cannot modify a read-only dataset" error in Android is fixed
  • Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed

New in SQL Server Data Access Components 8.1.7 (Sep 18, 2018)

  • Support for Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is added
  • Support for connecting to SQL Server using a server alias in the Direct mode is added
  • Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
  • 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 Runtime error 231 when getting a lot of database errors in one statement under Windows x64 is fixed
  • Bug with getting a list of key fields for SQL Server Compact Edition is fixed
  • Bug with "Windows Authentication is not supported under non Windows environment" when connecting to a database on Android is fixed
  • Bug with suspending application with using NonBlocking in the Direct mode is fixed
  • Bug with application freezing when using NonBlocking in the Direct mode is fixed

New in SQL Server Data Access Components 8.1.6 (Jul 9, 2018)

  • 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
  • Memory leak in NEXTGEN is fixed
  • Bug with processing parameters with ftUnknown data type is fixed
  • Bug with processing transaction descriptors is fixed
  • Bug with re-deleting the service by TMSChangeNotification 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

New in SQL Server Data Access Components 8.0.5 (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 processing parameters with ftUnknown data type is fixed

New in SQL Server Data Access Components 8.0.4 (Jan 18, 2018)

  • Lazarus 1.8 and FPC 3.0.4 are supported
  • Windows authentication in the Direct mode is supported
  • Support for custom constraints is added
  • The UseBlankValues property for the Loader component is added
  • Bug with memory leak in the Direct mode when UniDirectional is True is fixed
  • Bug with fetching data in the NonBlocking mode is fixed
  • Bug with AV failure on processing widestring parameter of large size is fixed
  • Bug with AV failure in TMSChangeNotification is fixed
  • 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

New in SQL Server Data Access Components 8.0.3 (Sep 19, 2017)

  • 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 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 date and time fractional seconds precision when DescribeParams = True is fixed
  • Bug with using DAC components in DataModule for Linux is fixed

New in SQL Server Data Access Components 8.0.2 (May 15, 2017)

  • 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 using the AsGuid property is fixed
  • Bug with the "Invalid column name" error when editing a query with the JOIN statement is fixed

New in SQL Server Data Access Components 8.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 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 detection of field aliases for a query with the JOIN statement is fixed
  • Bug with memory leak when loading Memo fields in TMSLoader is fixed

New in SQL Server Data Access Components 7.3.16 (Dec 27, 2016)

  • Bug with adding Calculated fields after calling Prepare is fixed
  • Bug with WITH clause in TMSScript is fixed
  • Bug with inserting identity fields through TMSLoader in the Direct mode is fixed
  • Bug with updating a field containing a space in an alias in the Direct mode is fixed
  • Bug with setting FilterSQL to SQL query in Disconnected mode is fixed

New in SQL Server Data Access Components 7.3.15 (Dec 27, 2016)

  • The TMSConnectionOptions.MultipleConnections property is added
  • TMSDataSetOptions.UseSessionIdentity property is changed to TMSDataSetOptions.LastIdentityValueFunction property for selecting the function that returns last-generated identity values
  • Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
  • Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
  • Bug with processing parameter name when a name begins from a number is fixed
  • Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed
  • Bug with the assertion failure on processing UDT parameters in TMSStoredProc is fixed
  • Some bugs in TMSLoader in the Direct mode are fixed

New in SQL Server Data Access Components 7.3.14 (Dec 27, 2016)

  • TDADataSetOptions.InsertAllSetFields property is added
  • Support for IPv6 protocol in Direct Mode is added
  • The TMSServiceBroker component for non-Windows platforms is supported
  • Support for UDT fields in the TMSTableData component is added
  • Now the value of NULL output parameters is returned as NULL, not as Unassigned
  • Several bugs in SmartFetch Mode are fixed
  • Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
  • Bug with param values loss after changing TDAParam.ValueCount is fixed
  • Bug with PtrOffset function when Overflow Checking option enabled is fixed
  • Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
  • Bug with the duplicated MacroChar variable is fixed
  • Bug with RowsAffected calculation after executing the RefreshQuick method is fixed
  • Bug in the RefreshRecord method when database name must be quoted is fixed
  • Bug with assertion failure on processing UDT fields is fixed
  • Bug with AV failure on processing float fields for mobile platforms is fixed
  • Bug in TMSLoader in Direct Mode when TableName contains SchemaName is fixed
  • Bug in TMSLoader in Direct Mode when TableName is quoted is fixed
  • Bug with using a non-default port when Pooling is enabled is fixed

New in SQL Server Data Access Components 7.3.13 (Dec 27, 2016)

  • TVirtualDataSet component is added
  • TMSDataSetOptions.UseSessionIdentity property for the use of @@Identity lexem instead of SCOPE_IDENTITY() on refreshing data of inserted record is added
  • Data type mapping from Varbinary type to Blob field is added
  • Bug with assertion failure on editing data in SmartFetch mode is fixed
  • Bug with using parameters and column aliases in Master-Detail relation is fixed
  • Bug with AV on application closing when DLLs are used in the Trial edition is fixed
  • Bug with data type mapping from MONEY type to TBCDField field is fixed
  • Bug with assertion failure on assigning one TMSTableData object to a few parameters is fixed
  • Bug with using the UpdatingTable property without specifying the current schema in table name is fixed
  • Bug with resetting the TParam.ParamType property when Master-Detail relationship is used is fixed
  • Bug when the USE_FTAUTOINC directive is defined is fixed
  • Bug with duplicated query displaying in DBMonitor on calling the OpenNext method is fixed
  • Bug with showing the Debug window on using the TMSConnection.OpenDataSets method is fixed
  • Bug with calling the BeforeOpen and BeforeExecute events when using the TMSConnection.OpenDataSets method is fixed
  • Bug with processing identity fields in TMSLoader is fixed
  • Bug with AV failure on project compilation in Delphi 7 is fixed

New in SQL Server Data Access Components 7.3.12 (Dec 27, 2016)

  • Bug with AV failure when connection is not specified is fixed
  • Bug with batch operations is fixed

New in SQL Server Data Access Components 7.3.11 (Dec 27, 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
  • The TMSLoaderOptions.FireTrigger property is added
  • SmartFetch mode in Disconnected mode is supported
  • Bug with handling international characters in the VirtualTable component is fixed
  • Bug with displaying data in grid on error at applying cached updates is fixed
  • Bug in the SetOrderBy method in case when SQL contains ';' is fixed
  • Bug with using the LIKE clause in a dataset filter is fixed
  • Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
  • Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
  • Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
  • Bug with AV failure on opening dataset inside DLL for MS SQL Server Compact Edition is fixed
  • Bug with generating of UpdateSQL on using WITH clause is fixed

New in SQL Server Data Access Components 7.2.10 (Dec 27, 2016)

  • Data Type Mapping performance is improved
  • Bug with fetching float values is fixed

New in SQL Server Data Access Components 7.2.9 (Dec 27, 2016)

  • Performance of TDALoader on loading data from TDataSet is improved
  • Several bugs in the SmartFetch mode are fixed
  • Bug with processing the cached data in the ApplyUpdates method is fixed
  • Bug with RecNo in the UniDirectional mode is fixed
  • Bug with storing some numbers with floating point is fixed
  • Bug with using TMSServiceBroker in Windows service is fixed
  • 'Range check error' on connection to SQL Server 2005 is fixed
  • Bug with AV failure on opening dataset when the OnFilterRecord event handler is used is fixed

New in SQL Server Data Access Components 7.2.8 (Dec 27, 2016)

  • Bug with showing values array for batch updates in SQLMonitor is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed

New in SQL Server Data Access Components 7.2.7 (Dec 27, 2016)

  • RAD Studio 10 Seattle is supported
  • Now Trial for Win64 is a fully functional Professional Edition
  • INSERT, UPDATE and DELETE batch operations are supported
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
  • Bug with endless reconnection in assigned connection is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed
  • SQLMonitor behavior on using similar objects is fixed
  • Bug with truncation of milliseconds of datetime2 fields is fixed
  • Bug with AV failure on executing query with parameters of Word type is fixed
  • Bug with getting table names in Direct Mode is fixed
  • Bug with execution of stored procedures in Direct Mode is fixed
  • Bug with auto-detection of stored procedure parameters in TMSStoredProc in Direct Mode is fixed
  • Bug in Direct mode with the 'Token 02 below minimal' error when selecting an empty string value for the nvarchar(max) data type is fixed
  • Bug with setting the TMSCompactConnection.IsolationLevel property is fixed

New in SQL Server Data Access Components 7.1.3 (Apr 16, 2015)

  • 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
  • Bug with invalid names of Master-Detail parameters is fixed
  • Bug with the 'Cannot convert type' error in the TDADataSet.RefreshRecord method when data type mapping is used is fixed
  • Bug with AV failure in the SmartFetch mode is fixed
  • Bug with AV on calling GetVersion() in C++Builder is fixed
  • 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
  • Bug with an Abstract error on TMSChangeNotification freeing is fixed
  • Bug with AV failure in the TMSConnection.Ping method is fixed

New in SQL Server Data Access Components 7.0.2 (Jan 15, 2015)

  • Lazarus 1.2.6 is supported
  • Several bugs in the Direct mode are 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
  • 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 TMSLoader by OLEDB Provider is fixed

New in SQL Server Data Access Components 7.0.1 (Nov 25, 2014)

  • Direct mode is supported
  • Mac OS X is supported
  • iOS is supported
  • Android is supported
  • Bug when using table aliases in the DetailFields name is fixed
  • Bug with using UPPER and LOWER functions in filter is fixed
  • Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
  • Bug with TCustomDADataSet.FindKey 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 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
  • Bug with processing TMSTransaction events by DBMonitor is fixed

New in SQL Server Data Access Components 6.11.23 (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
  • Bug with incorrect data loading by TMSLoader is fixed

New in SQL Server Data Access Components 6.11.22 (Sep 29, 2014)

  • RAD Studio XE7 is supported
  • Lazarus 1.2.4 is supported
  • The TCustomDADataSet.GetKeyFieldNames method is added
  • The TCustomDAConnection.GetKeyFieldNames method is added
  • The ConstraintColumns metadata kind for the TMSMetadata component is added
  • Demo projects for FastReport 5 are 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
  • Bug with detecting hidden fields is fixed

New in SQL Server Data Access Components 6.10.21 (Aug 6, 2014)

  • The SQL property is added to TMSConnection
  • Support for the Upper and Lower statements in TDADataSet.Filter is added
  • Bug with reopening TDADataSet after BreakExec is fixed
  • Several bugs in the SmartFetch mode are 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
  • 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
  • Bug with 'Unspecified error' in TMSLoader is fixed

New in SQL Server Data Access Components 6.10.20 (May 28, 2014)

  • 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 compilation in C++Builder is fixed
  • Bug with setting boolean parameters in a non-English IDE at design-time is fixed
  • Bug with unnecessary updating all fields when server cursor used is fixed
  • Bug with detecting slash as a delimiter in TMSScript is fixed
  • Bug with AV failure on appending new records when server cursor is used and CursorUpdate = False is fixed
  • Bug with hanging application on closing dataset with non-fetched records is fixed

New in SQL Server Data Access Components 6.10.19 (May 1, 2014)

  • 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
  • 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 processing widestring parameters is fixed
  • Bug with generating SQL queries for a query with a few keys is fixed
  • Bug with processing tinyint and single parameters in SQL Server Compact Edition is fixed
  • Bug with setting the TField.Required property for SQL Server Compact Edition is fixed

New in SQL Server Data Access Components 6.9.18 (Feb 20, 2014)

  • 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 changing TParam.ParamType when preparing parameters of stored procedure when DescribeParams is True is fixed
  • Bug with deleting other services on closing TMSChangeNotification is fixed
  • Bug with not displaying data in visual controls in the NonBlocking mode is fixed
  • Bug with generating SQL queries by "SQL Generator" in design-time is fixed
  • Bug with "SQL editor" in design-time is fixed

New in SQL Server Data Access Components 6.9.17 (Dec 28, 2013)

  • 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
  • RefreshQuick, RefreshRecord and ReadOnly are now set to True by default
  • Bug with data loss when updating records in the CachedUpdates mode is fixed
  • Bug with RefreshRecord in the CachedUpdates mode is fixed
  • Bug with mapping to BCD and FmtBCD types is fixed
  • Bug with mapping single types to float types is fixed
  • Bug with data display in Detail Dataset when master field is Null is fixed
  • Bug with mapping to BCD fields when using TClientDataSet is fixed
  • Bug with incorrect parameter sizes when re-opening a query 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 incorrect committing of data by the Loader component on errors is fixed
  • Bug with using LongWord parameters is fixed
  • Bug with using TMSDataSetOptions.NonBlocking is fixed
  • Bug with processing varbinary(max) output parameters in stored procedure is fixed
  • Bug with the "Bookmark is invalid" error when using the ctKeyset cursor is fixed

New in SQL Server Data Access Components 6.8.16 (Sep 26, 2013)

  • Critical bug with parsing unicode SQL queries is fixed

New in SQL Server Data Access Components 6.8.15 (Sep 20, 2013)

  • RAD Studio XE5 is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • Flexible management of conditions in the WHERE clause 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
  • Bug in TDALoader with data loading from Dataset when the FetchAll option is set to False is fixed
  • Bug with TDALoader.LoadFromDataSet 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
  • Bug with not setting all properties when assigning TMSSQL is fixed
  • Bug with using ptResult parameters is fixed
  • Bug with calling RefreshRecord when FullRefresh is set to True is fixed
  • Bug with assertion failure when using notifications is fixed
  • Bug with using notifications for long queries is fixed
  • Bug causing different errors when using notifications is fixed
  • Bug with "Multiple-Step OLE DB Operation generated errors" is fixed
  • Bug with processing DateTime fields when using Table-Valued Parameter type is fixed

New in SQL Server Data Access Components 6.7.14 (Jul 16, 2013)

  • Connection dialog is improved
  • Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
  • Now schema name is used when filling default values if DefaultValues = True
  • 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
  • Bug with processing parameters of stored procedures is fixed
  • Bug with the QueryRecCount option queries containing the 'GROUP BY' clause is fixed
  • Bug with processing changed Blob fields is fixed
  • Bug with "Multiple-Step OLE DB Operation generated errors" is fixed
  • Bug with truncating strings containing #0 characters is fixed
  • Bug with the 'Invalid floating point operation' error on dataset opening is fixed
  • Bug with memory leak when using connection pooling is fixed
  • Bug with adding #0 characters when dumping blob fields is fixed

New in SQL Server Data Access Components 6.7.13 (Apr 27, 2013)

  • Rad Studio XE4 is 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 of TimeStamp, Single and Extended fields in VirtualTable is added
  • 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
  • Thread handle leak when using pooling is fixed
  • Bug with 'Unspecified error' when using TMSLoader for UNIQUEIDENTIFIER fields is fixed
  • Bug with TMSLoader.LoadFromDataSet when UniDirectional = True and FetchRows = 1 is fixed
  • Bug when opening table for SQL Server Compact Edition 4.0 for 64-bit Windows is fixed

New in SQL Server Data Access Components 6.6.12 (Feb 15, 2013)

  • Rad Studio XE3 Update 2 is now required
  • 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
  • Bug with data type mapping of nvarchar(max) field is fixed
  • Bug with the 'List index out of bounds' error on refresh of detail table is fixed
  • Bug with AV failure on repeated execution of a prepared stored procedure is fixed
  • Bug with AV failure on filling default field values is fixed
  • Bug with using the TVP parameter not belonging to dbo schema is fixed
  • Bug with dumping data from view is fixed
  • Bug with dumping data from tables of not a standard dbo schema is fixed
  • 'Overflow check error' when using TMSDump is fixed
  • Bug with 'Unspecified error' in TMSLoader is fixed
  • 'Invalid column name 'message_id'' when using notifications in SQL Server 2012 is fixed

New in SQL Server Data Access Components 6.6.11 (Dec 18, 2012)

  • 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
  • Bug with using quoted field names in the IndexFieldNames property is fixed
  • Bug in TMSStoredProc with closing dataset when the Disconnected property is True is fixed
  • Bug with processing macros named in Cyrillic is fixed
  • Bug with getting default field values when using not the default dbo schema is fixed
  • Bug with getting default values for fields with aliases is fixed
  • Bug with filtering XML fields is fixed
  • 'Required provider is not installed' error when working with FILESTREAM data is fixed

New in SQL Server Data Access Components 6.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
  • TMSConnectionOptions.NativeClientVersion property to set the version of SQL Native Client provider is added
  • The possibility of choosing the Authentication mode in TfrxSDACDatabase is added
  • 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 using TVP parameters in queries is fixed
  • Bug with AV failure on TMSTable.Open is fixed
  • Bug with using the '|' symbol in the connection string is fixed
  • 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
  • Bug with errors on starting BDS 2006 is fixed
  • Bug with compilation of FireMonkey Application on C++Builder is fixed
  • Bug with invalid class type cast exception when processing parameters in Trial Edition is fixed

New in SQL Server Data Access Components 6.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
  • Bug with inserting strings and widestrings via TMSLoader is fixed

New in SQL Server Data Access Components 6.2.8 (Jul 27, 2012)

  • 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

New in SQL Server Data Access Components 6.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 TMSEncryptor 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 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
  • Bug with getting stored procedures list for SQL Server 2000 is fixed
  • Bug in design time editor of the TMSStoredProc component is fixed

New in SQL Server Data Access Components 6.1.6 (Apr 4, 2012)

  • 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
  • Bug with pdInputOutput parameters is fixed

New in SQL Server Data Access Components 6.1.4 (Dec 29, 2011)

  • The UniqueFieldIndexSeparator global variable is added
  • 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
  • Bug with executing the queries with parameters in Delphi 5 is fixed
  • Several bugs with 64-bit application development are fixed
  • Several bugs in design-time editors are fixed
  • 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

New in SQL Server Data Access Components 6.0.2 (Nov 9, 2011)

  • Bug with compilation for Linux in Lazarus is fixed
  • Bug with processing identity fields in Table-valued parameters is fixed

New in SQL Server Data Access Components 6.0.1 (Nov 9, 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 excess memory allotment on recordset opening for SQL Server Compact Edition is fixed

New in SQL Server Data Access Components 5.10.0.8 (Nov 9, 2011)

  • Bug with assertion failure on using master/detail relationship with TClientDataset is fixed
  • Bug in TCustomDADataSet.PSGetKeyFields method when in dataset persistent fields was created is fixed
  • Bug with crashing application when preparing parameters for SQL Server Compact Edition is fixed

New in SQL Server Data Access Components 5.10.0.7 (Nov 9, 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 processing key fields on record posting is fixed
  • Several bugs with design-time editors for Lazarus are fixed
  • Bug with specifying schema name on getting table names list in design time editor when not default schema name is used is fixed

New in SQL Server Data Access Components 5.10.0.6 (May 14, 2011)

  • 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 in SQL Server Data Access Components 5.00.0.4 (Feb 11, 2011)

  • Fixed bug with SQL Generator in design time

New in SQL Server Data Access Components 5.00.0.4 (Feb 11, 2011)

  • Fixed bug with SQL Generator in design time

New in SQL Server Data Access Components 4.80.0.54 (Dec 8, 2009)

  • Added support for dbMonitor 3
  • Added support of DATETIMEOFFSET field type for SQL Server 2008
  • 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 repeated executing TMSConnection.OpenDatasets
  • Fixed bug with processing LargeInt parameters in Delphi 5

New in SQL Server Data Access Components 4.80.0.53 (Dec 8, 2009)

  • Added the TMSConnection.OpenDatasets method for opening several datasets as one batch
  • Now Required flag is set for UpdatingTable fields only
  • Now setting the SetFieldsReadOnly option to False makes all fields not read-only (default changed to True)
  • 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
  • Fixed bug with setting right datatype for nvarchar parameter
  • Fixed bug with getting all error messages, when multiple errors are generated

New in SQL Server Data Access Components 4.80.0.52 (Dec 8, 2009)

  • Added support of Base table cursor for SQL Server Compact Edition
  • Now the AssignConnect method copies transaction state
  • Now TFMTBcdField fields are trimmed if they are larger than MaxFMTBcdDigits
  • Fixed problem with help registration under RAD Studio 2010
  • Fixed problem with loading DataSet Manager under RAD Studio 2010
  • Fixed bug with locating records using the LocateEx method and the lxNearest option
  • Fixed bug with SQL Generator in design-time
  • Fixed bug with AV failure in MemData
  • Fixed bug with calculating count of using the sqlncli library
  • Fixed bug with FieldTypesWithSize ambiguity under C++Builder

New in SQL Server Data Access Components 4.80.0.51 (Sep 30, 2009)

  • Embarcadero RAD Studio 2010 suppored
  • Added the TCustomMSDataSet.HasNextResultSet method to check if the next recordset is available
  • Now the subdetail is refreshed before the AfterRefresh event of the detail is called
  • Fixed bug with processing DateTime fields on table locking

New in SQL Server Data Access Components 4.70.0.50 (Sep 30, 2009)

  • Added the TMSDataSetOptions.DisableMultipleResults property allowing to forbid using multiple results for quickly closing dataset
  • Now the value from the master dataset has priority over the DefaultExpression value
  • Fixed bug with parsing TDAScript.Statements
  • Fixed bug with RefreshQuick for query with fields that have similar names in several tables
  • Fixed bug with not unlocking record in the CachedUpdates mode if no fields were changed
  • Fixed bug with GetServerList on getting local SQL Server name
  • Fixed bug with inserting record when Pooling is enabled
  • Fixed bug with calculating count of using the sqlncli library
  • Fixed bug with correct settings of parameters for TMSCompactConnection
  • Fixed bug with checking DB file version of SQL Server Compact Edition in multi thread application

New in SQL Server Data Access Components 4.70.0.48 (Sep 30, 2009)

  • Added the TMSDump.Options.DisableConstraints property to dump multiple tables with foreign keys
  • Fixed bug with local sorting in CachedUpdates mode
  • Fixed bug with raising exceptions on locating records when IndexFieldNames is set
  • Fixed bug with calculating connection count in Disconnected mode
  • Fixed bug with calling the OnError event on connection failure when Pooling is enabled
  • Fixed bug with macros in TDAScript
  • Fixed bug with getting field aliases for SQL Server Compact Edition
  • Corrected packets for �++ Builder 6

New in SQL Server Data Access Components 4.70.0.47 (Jun 15, 2009)

  • Added the Disconnected property to TCustomDADataSet
  • Added support for TQuery.DataSource property in BDE Migration Wizard
  • Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
  • Improved work of SQL instance detection
  • Fixed bug with the GotoCurrent method
  • Fixed bug with LocalMasterDetail and Prepare method
  • Fixed bug with FullRefresh and macros
  • Fixed bug with processing NTEXT fields when using TDataSetProvider for Delphi 2009
  • Fixed bug with processing Unicode symbols in TMSXMLField
  • Fixed bug with calculating connection count on fetch
  • Fixed bug with generating SQL queries by "Sql Generator" of TMSQuery component in design-time when Options.QuoteNames is set to True

New in SQL Server Data Access Components 4.70 (Nov 11, 2008)

  • 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 in SQL Server Data Access Components 4.30 (Nov 15, 2007)

  • CodeGear RAD Studio 2007 supported
  • Added enhanced support for User-defined Types of SQL Server, support for distributed transactions, support for Query Notifications
  • Added support for getting results from queries with the FOR XML clause in readable view
  • Added ability to lock records and tables

New in SQL Server Data Access Components 4.00 (Apr 25, 2007)

  • Disconnected model, Local Failover,
  • added DataSet manager,
  • added TMSScript component,
  • added TMSServiceBroker component,
  • added data export/import to/from XML,
  • extended SQL Server functionality support, including MARS support,
  • lots of existing functionality enhancements,
  • Delphi 2007 for Win32 support