>Hi John just do a SELECT statment to join all that 3 tables and returns a Cursor with the columns that you want to export, then CURSORTOXML("mycursor", lcXML)
>now lcXML variable will hold all the xml and the schema of your cursor.
>
>
>>I have never created a XML file before and I have been told that our Payroll software must now export the year end returns to a XML file using a schema. All the information that is required for the XML file is held in 3/4 different DBF files. Looking at the schema the XML file has a header and then recurring data after that. I was wondering if VPF could generate the XML file. Any help would be appreciated
IF John works with version of VFP that have CURSORTOXML() function ;o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.