Hi,
I'm attempting to read in an XML file that is created by Microsoft's SQL Server Reporting Services export to XML function.
This code is what I have tried:
m.loDom = CREATEOBJECT('MSXML2.DomDocument.4.0')
m.loDOM.loadXML(GETFILE("XML"))
?m.loDom.xml
but I get nothing displayed on the screen. loDom.xml shows up as empty in the debugger too.
How do I upload the XML file I am trying to import?
Is it that the XML is invalid?
FWIW I tried reading it in using the XML Adapter, but got the message that the schema was too complex.
If anybody has any ideas how I can take this file and get its data into a VFP cursor, I would appreciate it.