SDAC 4.00 Beta available!

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

SDAC 4.00 Beta available!

Post by Antaeus » Thu 21 Dec 2006 15:59

Dear users,

Please try SQL Server Data Access Components 4.00 Beta version available for download now.
Version 4.00 introduces a large number of new features including disconnected model and local failover support,
extended server-specific functionality support and many others.

Here is the description of new features:

New functionality:
  • 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 added
  • New component for transferring data between all types of TDataSets descendants 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
  • Support for sending messages to DBMonitor from any point of your program added
  • Asynchronous fetch mode added
  • Ability to work with compressed BLOB objects added
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 (DBPROPVAL_TI_SNAPSHOT) added
  • Support for more server objects in TMSMetaData added
Extensions and improvements to existing functionality:
  • 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 TMSUpdateQuery objects added
  • Support for DefaultValues on record insertion added
  • Improved performance in specific cases:
    - NUMERIC fields fetching
    - Update commands execution while editing data set
    - DataSet refreshing
    - Records refreshing after updates and inserts
Usability improvements:
  • Syntax highlighting in design-time editors added
  • FAQ section added
  • Easy-to-use demo projects
We're looking forward to your comments and suggestions.

Core Lab development team

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 08 Feb 2007 16:10

SDAC 4 Beta version was recently updated. Below are listed the changes in the new build of SDAC 4 Beta:
  • WideMemo field type in Delphi 2006 supported
  • General performance improved
Core Lab development team