I want to create a set of cursors from an XML file. There are 3 associated Schemas that must be used together. The Schemas and XML data files are from a Standards organization so I am confident of their correctness. I have slightly modified a FoxPro sample program but cannot get past the first step. After the XMLAdapter.LoadXML command the value of oXMLAdapter.Tables.Count is zero and oXMLAdapter.SOM is NULL. I do not get an error message on the LoadXML command. Is there something else I have to do if I have 3 related Schemas? How can I get my XML file into FoxPro tables? Here is part of the code:
LOCAL lcFile as String
LOCAL oXMLAdapter as XMLAdapter
lcFile = "c:\sedi_8\sedi_xml\transcript_inst_courses_only.xml"
oXMLAdapter = NEWOBJECT('XMLAdapter')
TRY
oXMLAdapter.LoadXML(lcFile, .T.)
WAIT WINDOW "Number of Tables: " + STR(oXMLAdapter.Tables.Count)
Thanks for any insights you can offer.