Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xml
Message
From
24/08/2010 11:21:29
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Re: Xml
Miscellaneous
Thread ID:
01478130
Message ID:
01478151
Views:
94
If the schema is too complex, try to read the data that matters to you by using an XML parser. For instance, this will list all properties locations:
m.loXML = CREATEOBJECT("Microsoft.XMLDOM")

m.loXML.async = .F.
m.lcXMLFile = GETFILE()
m.loXML.Load(m.lcXMLFile)

m.loXMLDoc = m.loXML.documentElement

m.loProperties = m.loXMLDoc.selectNodes("//List_formData/formData/formHeader")

FOR EACH m.loProperty IN m.loProperties
	? "Property location: " + m.loProperty.selectSingleNode("propertyLocationStreet").text + ", " + ;
            m.loProperty.selectSingleNode("propertyLocationCity").text
ENDFOR
>I need to read XML file with complex structure - it has several number of forms.
>XMLTOCURSOR() function failed with errror 2120 - Unable to infer XML schema.
>Please,Help!!!!
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform