Page 1 of 1

How to use MyDac and XML in Delphi7

Posted: Wed 02 Nov 2005 14:50
by Hans
Hi,

Does anyone here know if and how you can update or insert records from an XML doc to the a MySql table using MyDac components?

best regards,
Hans

Posted: Wed 02 Nov 2005 15:41
by Ikar
MyDAC does not provide automation for this task.

Posted: Wed 02 Nov 2005 16:40
by Hans
ok, Thanks for your reply.

I found a way to get it working. You just need two or three components:

Use TXMLTransFormProvider. Connect it to a ClientDataSet, which is connected to a TDataSource. Using the Delphi XMLMapper Tool you can generate the required transformation file.

No you can open an XML file and tread it as a DataSet.

best regards,
Hans