Export VFP table to XML
Posted on 2011-10-10
I am updating a VFP-7 app. where keyed data needs to be exported to an XML document. I am completely new to XML and totally ignorant.
My client has provided a sample XML and "SCHEMA" files (there are 81 of them - one for each data-set (field?).
I created a DBF that contains fields named the same as in the sample XML. There are about 250 fields. I tried using CURSORTOXML but my resulting XML does not much look like the sample XML. This is the statement:
CURSORTOXML("DbfTable", (M_XMLFil), 1, 512)
As stated, this app. was done with VFP-7 using a framework and would not be too easy to upgrade, however, if VFP-9 has superior tools for creating the XML, I could create a mini app. using VFP-9 just to create the XML.
Is there a "crash course" out there as I just don't get it - its like trying to learn Greek or something! Please help get me on the right track.