>I have somewhat complex xsd and xml files. The xsd file lists the structure for 4 tables. When I load the xsd file into Visual Studio 2005, it displays the appropriate number of tables based on the xsd file and each of the fieldnames and type is correct for each table. However, when I attempt to readin the xml file (which has one record for each table in it as it is sample data only), only the first table's record in the xml comes in correctly. The table layout matches the first table definition (for fieldnames and types) based correctly on what is in the xsd, so what happens is that each additional record has a null value in each field because the xml tags don't match the fieldnames. How to use xmltocursor when an xml file contains records for different structured cursors? I started using xmladapter but I haven't gotten far because loadxml bombs on line 1 of the xml. It's been awhile since I worked with xml and vfp and never did an xsd have multiple definitions in it.
I copied both files in some folder and played a little with XMLAdapter. That creates cursors for each table:
CLOSE DATA ALL
oXML = NEWOBJECT([XMLAdapter])
oXML.XMLSchemaLocation = ([d:\XMLTest\test2.xsd])
oXML.LoadXML([d:\XMLTest\test2.xml],.t.,.t.)
FOR lnFor = 1 TO oXML.Tables.Count
oXML.Tables.Item(lnFor).ToCursor()
BROWSE NOWAIT
NEXT
Now I search WHY I can't get the data in the cursors :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.