How to use MyDac and XML in Delphi7

Hans · Post by **Hans** » Wed 02 Nov 2005 14:50

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

Ikar · Post by **Ikar** » Wed 02 Nov 2005 15:41

MyDAC does not provide automation for this task.

Hans · Post by **Hans** » Wed 02 Nov 2005 16:40

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