How to use MyDac and XML in Delphi7

How to use MyDac and XML in Delphi7

Postby 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
Hans
 
Posts: 52
Joined: Wed 24 Aug 2005 20:05

Postby Ikar » Wed 02 Nov 2005 15:41

MyDAC does not provide automation for this task.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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
Hans
 
Posts: 52
Joined: Wed 24 Aug 2005 20:05


Return to MySQL Data Access Components