Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No data when generating cursors
Message
From
04/02/2014 07:15:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
No data when generating cursors
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01593104
Message ID:
01593104
Views:
43
I have to work on XML files but have not been provided with a Schema; I have used a couple of the free online generator tools to generate the schema. I am not getting any errors when I try to generate cursors, but neither am I getting any data! The cursors are created - but are empty.
oXA = CREATEOBJECT("XmlAdapter")
oXA.xmlschemalocation = lcCustFolder+"XMLORDER.xsd"	
oXA.RespectNesting = .T.

oXA.LoadXML(lcCustFolder+"TEMPORDER.xml",.T.)

* Split the loaded xmal into cursor tables
FOR i=1 TO oXA.Tables.Count
	oXA.Tables(i).Tocursor()
ENDIF
The file I am using to generate the Schema and the one I am testing are identical.

Does anyone have any pointers?

(I can provide a sample file and schema if that would be helpful).

Thanks
Barry Sutton
Reply
Map
View

Click here to load this message in the networking platform