TSimpleDataSet

[deFreitas]

Need an example of how to replace TSimpleDataSet with MyDAC components, please.
Mário de Freitas
São Paulo - BR

[jkuiper2105]

You can't.
TSimpledataset is a DBExpress component.

Why would you?

[deFreitas]

Yes, I know it's a DBExpress component.
I also know that with him:
It has an internal connection;
Provides access to properties and events of the DataSet and internal SQLConnection;
TFields allows you to configure the internal DataSet;

But I want to change all this by MyDAC components. Therefore seeking an example to help me.
Regards.

[deFreitas]

Hi, I managed to solve my doubt by searching, as follows:

The TSimpleDataSet is a "provider" of data, just as the TMyQuery. Based on an SQL sentence they will provide the data.

To replace the TSimpleDataSet by TMyQuery we copy the SQL statement from of the DataSet.CommandText TSimpleDataSet property and we put in the property SQL TMyQuery.

======
Consegui resolver a minha dúvida através de pesquisas.

O TSimpleDataSet é um “provedor” de dados, assim como o TMyQuery. Com base em uma sentença SQL eles vão fornecerão os dados.

Para substituir o TSimpleDataSet pelo TMyQuery, deve-se pegar a sentença SQL que está na propriedade DataSet.CommandText do TSimpleDataSet e colocá-la na propriedade SQL do TMyQuery.

[Dimon]

It is good to see the this issue has been solved. Feel free to contact us if you have any further questions about MyDAC.