Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLAdapter Code Examples
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01131922
Message ID:
01131928
Views:
15
>Are there any good straight code examples of using the XMLAdapter to create tables from XML. I've managed to do a .LoadXML but I'm really not sure what I need to do next to turn what has been loaded into a table or even how to navigate it.

Something like this maybe?
* read in received XML data
Local oXA2 as XMLAdapter
oXA2 = NewObject("xmladapter")
oXA2.LoadXML("c:\temp\myxmlfile.xml",.T.,.T.)
Close Tables all
For i = 1 to oXA2.tables.Count
   oXA2.Tables.Item(i).ToCursor()
EndFor
oXA2.ReleaseXML(.t.)


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform