Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xml and xsd files used with xmltocursor and cursortoxml
Message
 
To
09/11/2007 17:27:40
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01268148
Message ID:
01268149
Views:
16
>I have somewhat complex xsd and xml files. The xsd file lists the structure for 4 tables. When I load the xsd file into Visual Studio 2005, it displays the appropriate number of tables based on the xsd file and each of the fieldnames and type is correct for each table. However, when I attempt to reading the xml file (which has one record for each table in it as it is sample data only), only the first table's record in the xml comes in correctly. The table layout matches the first table definition (for fieldnames and types) based correctly on what is in the xsd, so what happens is that each additional record has a null value in each field because the xml tags don't match the fieldnames. How to use xmltocursor when an xml file contains records for different structured cursors? I started using xmladapter but I haven't gotten far because loadxml bombs on line 1 of the xml. It's been awhile since I worked with xml and vfp and never did an xsd have multiple definitions in it.

Could you post a part from that XML (or send it to me) just to play with it?
I am not the biggest XML lover here, but I always wonder what is this animal :-)
Till now I always worked with simple XML files, so I am curious about this.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform