Use TClientDataSet with TMSQuery

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
larsmaki
Posts: 1
Joined: Sat 11 Dec 2004 18:12

Use TClientDataSet with TMSQuery

Post by larsmaki » Sat 11 Dec 2004 18:46

Hi, using dbexpress I normally uses a tsqlquery, provider and Tclientdataset.
Should I replace tsqlquery with TMSQuery? I am using the Tclientdataset to work with the data on the "client/memory" side before saving to database.
My question is, am I still required to use Tclientdataset to do that or is there some client/memory side data in the TMSQuery that I can massage before applying to database?

Thanks, Lasse

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Use TClientDataSet with TMSQuery

Post by Ikar » Mon 13 Dec 2004 08:31

You can keep on using Tclientdataset or use CachedUpdates := True mode. At the last case SDAC SQL Generator will be used that will allow to process more exactly specific of MS SQL Server.

Post Reply