SQL Server Data Access Components

4.10.0.10 02.08.07

Added the XML data type to the parameters list in design-time parameters editor
Fixed bug with PSGetDefaultOrder method freezing for queries with complicated ORDER BY clauses
Fixed bug in TCRBatchMove with mapping fields by name when Fields count and FieldDefs count are not equal
Fixed bug with adding fields in TVirtualTable
Fixed bug with Pooling and Local Failover
Fixed bug with "Invalid Variant Type" exception under Windows 2000 when TDataSet.Refresh is called
Fixed bug with performance penalty when processing lookup and calculated fields
Problem with DBMonitor integration under Windows Vista Ultimate fixed
Bug with field names quotation in CRDBGrid fixed
Fixed bug with freezing in NonBlocking mode
Fixed bug with setting wrong parameter types for queries provided to SQLInsert, SQLUpdate, SQLDelete, SQLRefresh
Fixed bug with performance penalty when processing lookup and calculated fields
Fixed bug with setting the CanModify flag for computed fields
Fixed bug with ReturnParams option and parameter types in Update SQLs
Fixed bug with the RereshQuick method for queries with the WHERE clause
Fixed bug with setting the Hidden flag for FieldDescs with SQL Server Compact Edition and Windows Vista
Fixed bug in TMSStoredProc with Local Failover and Disconnected Model
Fixed bug compound field names quotation
Changed ancestor of TMSXMLField from TMemoField to TField due to Delphi field types limitation

4.10.0.9 12.06.07

C++Builder 2007 supported
TMSConnection.Options.FailoverPartner property added
Added ability to customize information view about fields in DataSetManager
Replacement of the TwwDataSource with TMSDataSource in the BDE/ADO Migration Wizard added
Performance of some operations in DataSet Manager improved
Bug with the BaseSQL property set to an empty string after assigning macro values fixed
Bug with incorrect registry key used by connect dialog to save/load the Server value fixed
Bug with refreshing records in detail dataset fixed
Fixed bug with lookup and data fields with the same name
Fixed bug with reopening queries in NonBlocking mode
Fixed bug with calling the RefreshQuick method for the detail DataSet
Fixed bug with calculated fields with ftDate and ftTime data types
Fixed bug with comparing string values during locate ans sort operations
Fixed bug with prepared stored procedures, whose result set depends on parameter values
Avoided Delphi 6 bug in the TryStrToBool function
Fixed bug with retrieving stored procedure output parameters with DECIMAL data type
Fixed bug with raising exceptions when locating records on filtered recordsets
Removed restriction on datasets that TMyDataSource can be associated with
Minor bugs in DataSet Manager fixed

4.00.0.7 16.05.07

Added ability to drag datasets between connections in group by connections mode in DataSet Manager
Added ability to assign DataSource and DataField properties of DevExpress DB-aware controls automatically in DataSet Manager
Extended abilities of assigning default controls for datasets and fields in DataSet Manager
Fixed bug in the MSDataAdapter component with reading BLOB fields
Fixed bug with AV failure after second call to CommitUpdates when there are skipped records in cache
Bug with processing stored procedures with XML parameters fixed
Fixed bug with retrieving information about foreign keys of a table using the TMSMetaData component
Fixed AV bug with opening detail DataSet when master DataSet is not TCustomMSDataSet descendant
Fixed bug with "DisposeBuf failed" exception on updating string fields in CachedUpdates mode
Bug when UnPrepare is not called for TCustomDASQL on changing value of a macro fixed
Fixed bug with loading DataSet Manager package in a localized IDE
Fixed minor bugs in DataSet Manager
Fixed Access Violation bug on Delphi 2006 exit on Windows Vista
Fixed minor bugs in installation for C++Builder and Delphi 2007

4.00.0.6 20.04.07

Added support for DevExpress controls in DataSet Manager
Added support for using TMemDataSet.IndexFieldNames with RefreshQuick
FastScript v1.9 support added
Fixed bug with SQL Generator in design time
Fixed bug with trimming SQL texts in design-time editors
Bug with setting RecNo property for filtered datasets fixed
Bug with PSGetTableName returning incorrect value after changing the SQL property fixed
Bug with calling TDataSet.Edit for master DataSet in CachedUpdates mode fixed
Minor bugs in installation fixed
Fixed bug in SQL Generator with generating REFRESH statements for detail DataSet
Fixed AV failure with deleting records in CachedUpdates mode
Fixed bug when detail DataSet is refreshed on switching master DataSet to Edit mode
Fixed bug with loading files in TMSScript editor
Fixed bug with calling design-time editors of TDADataSource descendants by double click
Fixed access violation when loading DataSet Manager package under Delphi 2007 and Windows Vista
Fixed bug with DataSet Manager when IDE freezes on loading a form with a large quantity of datasets
Fixed bug with SQL Server Compact and databases with maximum database size greater than 128 MB
Fixed bug with executing parametrized queries in Detail DataSet from design-time editor
Fixed bug with the RefreshQuick method and SELECT statements containing column aliases
Fixed bug in RefreshQuick method with semicolon at the end of the SELECT statement
Fixed bug with displaying invalid object property type in object inspector
Fixed bug with filter expression that contains several consecutive left brackets

4.00.0.5 06.04.07

TCustomMSDataSet.CreateProcCall and TMSSQL.CreateProcCall methods added
DataSet Manager stability improved
Fixed bug in SQL Generator with complex SELECT statements
Bug with setting RecNo property for filtered datasets fixed
Bug with Locate on ordered data fixed
Fixed bug with XmlTextReader.Eof property under C++Builder
Internal error in Delphi 5 fixed
Fixed bug with calling RefreshQuick method for SDAC DataSet with parameters in query
Fixed bug with identity columns in SQL generator

4.00.0.4 20.03.07

New functionality:

Delphi 2007 for Win32 supported
Disconnected model for working offline and automatically connecting and disconnecting supported
Local failover for detecting connection loss and implicitly reexecuting some operations supported
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
- Ability to use standard MS SQL client tool syntax
New component for transferring data between all types of TDataSets descendants added
New TMSServiceBroker component for SQL Server 2005 queuing and reliable messaging added
New TMSLoader component for improving records insertion performance added
New TMSDump component for loading data to and from the server added
Data export and import to/from XML supported
WideMemo field type in Delphi 2006 supported
Support for sending messages to DBMonitor from any point of your program added
Added asynchronous execute and fetch modes
Compressed BLOBs supported

Support for more MS SQL server functionality:

MS SQL Server Compact Edition supported
Multiple Active Result Sets (MARS) supported
Support for new data types, including XML, varchar(MAX), nvarchar(MAX), varbinary(MAX) added
Support for a new level of transaction isolation added
Support for more server objects in TMSMetaData added
Stored procedure parameters with default values supported

Extensions and improvements to existing functionality:

General performance improved
Master/detail functionality extensions:
- Local master/detail relationship support added
- Master/detail relationship 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
- Update commands execution while editing data set
- DataSet refreshing
- Records refreshing after updates and inserts
Support for selecting database name in TMSConnectDialog added

Usability improvements:

Syntax highlighting in design-time editors added
Demo projects became better organized and clearer
FAQ added

3.80.0.34 05.12.06

Fixed bug with TraceFlags in DASQLMonitor (D16224)
Fixed bug with TDAParam.AsDate property (D16213)
Fixed bug with wrong value of the StatementTypes variable in the BeforeUpdateExecute event
Bug with AV failure when modifying VirtualTable data in design time fixed

3.80.0.33 31.10.06

Bug with ApplyUpdates and OnUpdateError in SDAC Trial fixed
Bug with comparing Unicode strings fixed
Bug with BeforeDisconnect event lost in design time fixed
Bug with debug mode in design time fixed
Bug with RefreshRecord in CachedUpdates mode fixed
Bug with mouse wheeling in FilterBar and Search bar of CRDBGrid fixed (15675)

3.80.0.32 29.09.06

Limited support added for Windows Vista Beta 2
Memory usage optimized for tables with many fields
Fixed bug with SQLNCLI provider and server cursors
Fixed bug with unquoted '@' symbol in connection string
Design-time bug with IDE version in TMSConnectionEditor in Delphi 2005 fixed
Fixed bug with macros and "&" operand

3.80.0.31 28.08.06

Support for Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ added
Bug with automatic detail field value generation fixed (D12886)
Fixed bug with TrimVarChar
Fixed bug with FindKey method when the primary key has field of type Int64 (D12558)
Added capability to use quoted field names in IndexFieldNames property (D10091)
Bug with canceling edit on record with BLOB fields fixed
Bug with WideString lookup fields size fixed
Bug with loading wide strings in TVirtualTable fixed
Added support for macros names in which first symbol is digit
Bugs with parsing macros fixed
Bug with filtering DateTime fields when filter expression format differs from one in local system fixed (D12823)

3.70.3.30 07.07.06

Fixed bug with wrong line number in DAScript.EndLine property (M12015)
Fixed bug with filtering empty strings (S12329)
Bug with using calculated and lookup fields in Master/Detail relationship fixed
Fixed bug with design-time editor for Detail dataset in Master/Detail relationship (M12021, M11914)
Bug with modifying FieldDefs in TVirtualTable fixed
Performance of SaveToFile and LoadFromFile functions in TVirtualTable improved (D12435)
Bug in TVirtualTable Editor fixed

3.70.3.29 31.05.06

New MS SQL Server 2005 data types supported
TMSConnection.Options.InitialFileName property added
Modifying FieldDefs in TVirtualTable component accelerated
Fixed bug with memory leak in TCustomDADataSet (11636)
Bug with calling Parameter Editor from Object Inspector fixed (11671)
Bug with Master-Detail linked by parameters fixed

3.70.2.28 18.05.06

SDAC is now compatible with InterBase Data Access Components
Bug with Prepare method in Delphi 5 fixed

3.70.1.27 12.05.06

Fixed bug with loosing connection for FetchAll=False datasets (M11398)
Added support for MIDAS TDataSet.PSExecuteStatement ResultSet parameter (M11351)
Fixed bug with AV failure in ApplyUpdates after CommitUpdates
Bug with local filter under CLR fixed (11291)
Bug with using alternative memory managers fixed

3.70.1.26 14.04.06

Fixed bug with positioning in grid after TCustomDADataSet.Locate (11256)
Fixed bug with Master/Detail relations and local sorting and filtering (11254, 11255)
TCustomDADataSet.Locate now centers position in DBGrid (10976)
Bug with displaying query objects in objects tree in DBMonitor fixed
Optimized using of system resources when opening query (O11270)
Fixed bug with design-time SQL Generator
Added OLE DB limitation workaround when preparing query with parameters in subquery

3.70.1.25 10.03.06

Ability of trimming (N)VARCHAR fields with CustomDADataSet.Options.TrimVarChar property added
Added support for MIDAS master-detail relations
Fixed bug with fetching (N)VARCHAR(4000) fields
Fixed bug with erroneous exception on TDAParam.LoadFromStream
Bug with AV failure when calling CommitUpdates method of inactive dataset fixed
Bug with error failure when assigning empty dataset to VirtualTable under CLR fixed

3.70.0.24 26.01.06

Support for Delphi 2006 added
Support for MS SQL Server 2005 added
FastReport 3.20 support added
Fixed bug with single MacroChar in string constants inside SQL
Bug with invalid processing of SQL statements when using SQL keywords as macros name fixed
Fixed MS SQL server bug with processing 'SET STATISTICS IO ON' statements
Fixed bug with using CheckRowVersion property and RefreshRecord method

3.55.2.22 19.12.05

Fixed bug with trimming VARCHAR fields
Bug with restoring BaseSQL property fixed

3.55.2.21 07.12.05

TMSConnection.Options.PersistSecurityInfo property added
TCustomDADataSet.FindKey, TCustomDADataSet.FindNearest methods added for BDE compatibility
Fixed bug with Locate by multiple fields
Fixed bug with unchanging RecordCount value after CancelUpdates
Bug with refreshing record after changing SQL property fixed
Fixed SetWhere function bug
Fixed bug with server cursors when RefreshOptions property contains roBeforeEdit flag

3.55.1.20 24.10.05

Fixed bug with open detail TMSTable when master is not opened
Fixed bug with design-time SQL Generator
Fixed bug with EOLEDBError.MessageWide
Bug with updating FilterSQL fixed
Bug with VirtualTable registration in CBuilder fixed
Bug with VtReg.pas in Pro version fixed
Bug with closing dataset (SQL contains macros) when the InsertSQL property changes fixed
Bug with incorrect sequence of calling BeforeClose, BeforeDisconnect events fixed

3.55.1.19 11.10.05

Unicode error messages support added with EOLEDBError.MessageWide
SQL Generator improved: now in design-time format is used instead of
Fixed some bugs in design-time SQL Generator
Fixed bug with Master/Detail relations on string keys that differ in case only
Bug with reexecution after SQL statement changed fixed
Bug with assertion failure with OnNewRecord fixed
Fixed bug with detail refresh when field referenced by MasterFields property is empty
Fixed bug with extra detail record posts after master record changed
Bug with firing AfterScroll Event after detail dataset refresh fixed
Bug with simultaneous use of several DAC products fixed
Bug with changing FilterSQL of inactive dataset fixed
Bug with column sizing with CRDBGrid.OptionsEx.dgeStretch=True at design-time fixed
Bug with TCRColumn.SummaryMode=smLabel for string and date fields fixed

3.55.1.18 02.09.05

Deferred detail dataset refresh feature with TCustomDADataSet.Options.DetailDelay property added
Fixed bug with locating, filtering and local sorting of strings that contain '--'
Fixed DisposeBuf bug

3.55.0.17 02.08.05

Optimized macros processing
Fixed bug with using keywords as param name
Fixed bug with local sorting in dsEdit state
Fixed bug with getting Null for Blob fields
Improved behavior on parsing inline comments

3.55.0.16 05.07.05

Fixed performance bug with calling Execute (ReadOnly = True)
Fixed bug with sorting by GUID fields
Bug with TDAParam.AsString with TDataTime parameters fixed
Fixed bug with TMSConnection.ConnectioString design time editor

3.55.0.15 30.05.05

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
Removed TMSStoredProc.ParamCheck property from design-time
Fixed bug with ignoring MSConnection.Options.WorkstationID
Fixed bug with DADataSet.CheckBookmark on filtered datasets
Fixed bug with Transactions on connection lost
Fixed bug with reconnect on connection lost

3.50.0.14 29.04.05

Update Pack 3 is required for Delphi 8
Fixed bug with FetchAll = False and QueryRecCount = True for Detail queries (6759)
MSQuery.AddWhere improved

3.50.0.13 29.03.05

Fixed bug with quoting fields in SQLRefresh
Fixed bug with FieldDefs.Update and prepared TMSStoredProc (6147)
Fixed bug with roAfterUpdate and changing primary key values (6389)

3.50.0.12 24.02.05

FastReport3 engine and demo added
TCustomDADataSet.UpdateObject support for MIDAS added
Fixed bug with CLR BLOB Locate
Fixed bug with FmtBCD Locate

3.50.0.11 24.01.05

Support for Delphi 2005 added
Support for MS SQL Server 2005 Beta 2 added
Guid fields support for VirtualTable added
Fixed some bugs with connection pooling
Fixed bug MSParam.Size on CLR
Fixed bug with KeepDesignConnected
Fixed bug with design-time SQL generator and macros
Fixed bug with design-time MSStoredProc SQL generator
Fixed bug with IndexFieldNames on identical values
Fixed infrequent bug with IndexFieldNames
Fixed bug with params on MSQuery.Execute with SELECT
Fixed bug with disconnect on fatal error

3.00.2.9 23.11.04

Fixed bug with IndexFieldNames and Locate
Fixed bug with setting MinValue and MaxValue for tinyint fields
Fixed bug with KeepDesignConnected

3.00.2.8 28.10.04

Fixed C++Builder hpp bug

3.00.2.5 21.10.04

lxPartialCompare option for DataSet.LocateEx added
Fixed bug with OnFilterRecord and Blob fields (4962)
Fixed bug with Reconnect and prepared statements (4910)
Fixed bug with BlobField.SetAsString

3.00.1.3 10.09.04

Common class DADataAdapter isolated to CoreLab.Dac.AdoNet.dll library
Fixed bugs with ctKeyset, ctDynamic and default values (4082)
Fixed bug with evaluation period in Trial version
Support for TDAConnectionOptions.AssignTo added
Fixed bug with filtering NULL string values (4776)
Fixed bug with large blobs in TVirtualTable (4769)

3.00.0.2 20.08.04

Fatal errors processing improved
Delphi 7.1 bug fixed
MDAC 2.8 Lost connection bug fixed
Fixed bug with QueryIdentity and complex table names (4634)
Fixed bug with quoting complex names

3.00.0.1 21.07.04

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
TCRColumn.TotalValue property added
New time trial limitation
Fixed StackOverflow bug with opening empty ctStatic cursors
Fixed bug with Refresh server cursors (4478)
Fixed bug with small memory leak on SQL error (DbxSda4344)
RefreshRecord now updates timestamp field as default
Fixed bug with updating non-dbo owned tables (4193)
Fixed bug with CustomDADataSet.Options.ReturnParams (4159)
Fixed bug with CRDBGrid
Fixed bug with getting RecordCount if Filtered = True (4125)
Fixed bug with getting OldValue after Insert
Fixed bug with TrimFixedChar and dll

2.45.2.25 15.03.04

Mouse wheel support added to CRDBGrid
Local constraints for ctKeyset, ctDynamic disabled (4082)
Fixed bug with quote char in Filter property
Fixed bug with assigning name with spaces to Database property
Fixed bug with getting Identity value that exceeds MaxInt (4081)
Fixed bug with RefreshRecord and binary key fields (4089)

2.45.2.24 05.02.04

Fixed bug with restoring position after Refresh (M3962)
Fixed bug with TCustomMSDataSet.PSGetKeyFields (M4001)

2.45.2.23 30.12.03

Fixed bug with processing ftTime and ftDate parameters
Fixed bug with setting Null value for string parameters
Fixed bug with processing Blob and Memo parameters (3709, 3726)

2.45.2.22 24.11.03

Fixed bug with getting RecordCount (ParamCheck = False) (3524)

2.45.2.21 02.10.03

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
Fixed bug with MSDataSet.BeforeUpdateExecute and AfterUpdateExecute (3347)
Fixed bug with MSParam.Size (3345)
Fixed bug with calling Refresh after RefreshRecord (M3269)
Fixed bug with MSDataSet.UpdatingTable set at design-time (3164)
Bug with opening queries (FilterSQL <> '', StreamedActive = True) fixed (M3497)

2.45.1.20 02.07.03

Fixed bug with possible AV on destroying DataSet in Delphi5 (3069)

2.45.1.19 10.06.03

Parameter processing for complex queries optimized (3058)
Design-time bug occured in Delphi5 and CBuilder5 fixed

2.45.1.18 05.06.03

SQL Generator improved - support for complicated statements added (2993)
SQL Generator improved - "Quote names" checkbox added
Design-time SQL Generator was simplified
TParam -> TDAParam
Bug on Post (Insert/Append) when InsertSQL execution fails fixed
Fixed bug with ApplyUpdates if Options.ReturnParams is False and Options.QueryIdentity is True
Fixed bug on PSGetKeyFields after dataset is closed(3034)
Fixed bug with wildcard Locate on WideString fields
Fixed memory leak on posting BLOB data with ctKeyset, ctDynamic
Fixed bug with trimming char fields having empty values (2987)
Fixed bug with calling RefreshRecord on SELECT w/o data fields
Fixed bug with calling RefreshRecord on ctDynamic (3053)
Fixed bug with MultiSelect DBGrid for ctKeySet, ctStatic (3054)

2.45.0.17 05.05.03

property MSConnection.Options.WorkstationID added
Performance to insert large BLOBs improved
Fixed bug with using SDAC from dll (2963)
Fixed bug with getting SharedObj-parameters from datasets with LookUp fields (2948)

2.45.0.16 04.04.03

Performance significantly improved
event TMSConnection.OnInfoMessage added
Multiple Errors support added
EMSError now inherited from EOLEDBError
property TBlob.AsWideString added
property MSConnection.Options.ApplicationName added (2813)
Parameters parsing improved. Symbol ':' in string literals is ignored (2836)
Network error processing improved (2554, 2571)
MSConnectDialog improved
Performance demo added
Bug with RefreshRecord fixed
Small memory leak in RefreshRecord on ctKeyset, ctDynamic removed
Fixed bug with storing unicode strings in Memo fields
Fixed bug with processing 'Fail' parameter in TMSConnection.OnError (M2876)
Fixed bug with password storing in MSConnection.ConnectString (2841)
Fixed bug with design-time SQL Generator (2885)
Bug with transaction control on ctKeyset, ctDynamic fixed (2885)
Fixed bug with TMSMetaData.Refresh (2872)
Fixed bug with changing TMSMetaData.ObjectType

2.40.0.15 24.02.03

WideString support added
Refresh improved - current record is restored after Refresh call
Supported types list for TVirtualTable extended. WideString, Smallint, Word, Boolean, Largeint, Currency, Date and Time field
pes added (2779)
Performance of VirtualTable.AssignDataSet improved
Property MSDataSet.Options.QuoteNames added
Property MSConnection.Options.KeepDesignConnected added
Property MSConnectDialog.StoreLogInfo published
Bug with SDAC and ADO incompatibility under CBuilder fixed (2751)
Bug with clearing old value for Null output parameters fixed
Bug with wrong setting parameter values in WHERE clause fixed
Bug with processing empty param values in ConnectString fixed
Bug in MSTable.Execute fixed
Support for LIKE expressions in Filter property added(DAC-2706)
Precision and Size property values setting bug for TBCDField and TFMTBCDField fixed(2723)
Bug with getting field aliases on old clients fixed (2780)
Bug with design-time created fields case sensitivity fixed (2663)
Bug with some memory leak on each connection to server fixed (2679)

2.35.0.14 30.01.03

Improved performance for opening queries with lot of parameters
Dataset 'with many fields' update performance improved
'Connection Lost' error processing improved
MSDataSet.Locate improved (2589)
Fixed bug with compiling applications on C++ Builder
Fixed bug editing MSConnection.ConnectString property on DataModule (2586)
Getting identity improved for MS SQL 2000 (SCOPE_IDENTITY() instead @@Identity)
Fixed bug with getting Identity value after inserting to view (2567)

2.35.0.13 04.01.03

Bug with string quote in filter expression fixed (O2532)

2.35.0.12 26.12.02

Speed optimization for opening small queries (2378)
MSConnection.Options added (2454)
Limited MSConnection.ConnectString support added (2356)
Output string and (var)bytes parameters are now obtained from the server
with the maximum length not depending on set Param.Size (2355)
DBMonitor client implementation moved to COM server
Bug with complex table names fixed
Fixed common bug with lost data in DT-editors(D2137)
Bug with design-time MSConnection in DataModule fixed (O2290)
Design-time editor for MSTable bug fixed (2433)
BLOB fields post for Server Cursors optimized(2117)
Bug with Master/Detail relation for ClientDataSet fixed (O2423)
Fixed some bugs with OutOfMem (1979)