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 supportedExtensions 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 added3.80.0.34 05-Dec-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 fixed3.80.0.33 31-Oct-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-Sep-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 "&" operand3.80.0.31 28-Aug-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-Jul-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 fixed3.70.3.29 31-May-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 fixed3.70.2.28 18-May-06 SDAC is now compatible with InterBase Data Access Components Bug with Prepare method in Delphi 5 fixed3.70.1.27 12-May-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 fixed3.70.1.26 14-Apr-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 subquery3.70.1.25 10-Mar-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 fixed3.70.0.24 26-Jan-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 method3.55.2.22 19-Dec-05 Fixed bug with trimming VARCHAR fields Bug with restoring BaseSQL property fixed3.55.2.21 07-Dec-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 flag3.55.1.20 24-Oct-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 fixed3.55.1.19 11-Oct-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 fixed3.55.1.18 02-Sep-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 bug3.55.0.17 02-Aug-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 comments3.55.0.16 05-Jul-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 editor3.55.0.15 30-May-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 lost3.50.0.14 29-Apr-05 Update Pack 3 is required for Delphi 8 Fixed bug with FetchAll = False and QueryRecCount = True for Detail queries (6759) MSQuery.AddWhere improved3.50.0.13 29-Mar-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-Feb-05 FastReport3 engine and demo added TCustomDADataSet.UpdateObject support for MIDAS added Fixed bug with CLR BLOB Locate Fixed bug with FmtBCD Locate3.50.0.11 24-Jan-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 error3.00.2.9 23-Nov-04 Fixed bug with IndexFieldNames and Locate Fixed bug with setting MinValue and MaxValue for tinyint fields Fixed bug with KeepDesignConnected3.00.2.8 28-Oct-04 Fixed C++Builder hpp bug3.00.2.5 21-Oct-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.SetAsString3.00.1.3 10-Sep-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-Aug-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 names3.00.0.1 21-Jul-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 dll2.45.2.25 15-Mar-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-Feb-04 Fixed bug with restoring position after Refresh (M3962) Fixed bug with TCustomMSDataSet.PSGetKeyFields (M4001)2.45.2.23 30-Dec-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-Nov-03 Fixed bug with getting RecordCount (ParamCheck = False) (3524)2.45.2.21 02-Oct-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-Jul-03 Fixed bug with possible AV on destroying DataSet in Delphi5 (3069)2.45.1.19 10-Jun-03 Parameter processing for complex queries optimized (3058) Design-time bug occured in Delphi5 and CBuilder5 fixed2.45.1.18 05-Jun-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-May-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-Apr-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.ObjectType2.40.0.15 24-Feb-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-Jan-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-Jan-03 Bug with string quote in filter expression fixed (O2532)2.35.0.12 26-Dec-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)2.30 30-Sep-02 Delphi 7 support New memory management model for ftString and ftVarBytes types. Allows significantly decrease memory usage on large tables fetch. Controlled by FlatBuffers dataset option Support for blob fields in CachedUpdates mode2.05 09-Aug-02 DBMonitor support2.00 18-Jul-02 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 Rollback1.30 21-Mar-02 C++ Builder 6 is supported1.20 08-Nov-01 Added TMSParam class to represent parameters Query Analyzer and Enterprise Manager integration added Accelerated getting identity value on refresh1.00 26-Aug-01 Initial release of SDAC 1997-2022 Devart. All rights reserved.
Devart SQL Server Data Access Components (SDAC) 8.0.1 for Berlin Tokyo
2ff7e9595c
Comments