Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No tables result from XMLAdapter.LoadXML in VFP8
Message
From
24/03/2005 21:15:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
No tables result from XMLAdapter.LoadXML in VFP8
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00999075
Message ID:
00999075
Views:
76
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

* Name of an XML file.
lcFile = "c:\sedi_8\sedi_xml\transcript_inst_courses_only.xml"

* Create an XMLAdapter object to load the XML file into.
oXMLAdapter = NEWOBJECT('XMLAdapter')

   TRY
      * Read the XML file into the XMLAdapter object.
      oXMLAdapter.LoadXML(lcFile, .T.)
      WAIT WINDOW "Number of Tables: " + STR(oXMLAdapter.Tables.Count)
Thanks for any insights you can offer.

Next
Reply
Map
View

Click here to load this message in the networking platform