Coverting a TMyQuery dataset to TClientDataSet in Delphi

CFaiga · Post by **CFaiga** » Wed 14 Jan 2009 16:37

Hi I make use of the Mydac components by devart (corelab) to access MySql from Delphi (2006) Very often I need to work with data in a TClientDataSet What is the best way to convert the dataset of a TMyQuery to TClientDataSet

Dimon · Post by **Dimon** » Fri 16 Jan 2009 13:19

You can connect TClientDataSet to TMyQuery through the TDataSetProvider component.

CFaiga · Post by **CFaiga** » Sat 17 Jan 2009 08:34

Please can you show me some sample code

Dimon · Post by **Dimon** » Mon 19 Jan 2009 13:41

You can use the following code:

Code: Select all

DataSetProvider.DataSet := MyQuery;
ClientDataSet.ProviderName := DataSetProvider;

After this you can use TClientDataSet.