Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLToCursor issue
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01000463
Message ID:
01000466
Views:
16
Have you checked if there is a special character present in the xml-file for instance: ë or ì. I had something similar where VFP created the XML nicely and IE refused to show the contents.

Regards,
Ron

>Greetings all,
>I'm working on a system to bridge data between SQL and Fox via XML files with about 12-14 columns. I've styled the SQL query two ways, one with "FOR XML RAW" and the other with "FOR XML AUTO, ELEMENT, XMLDATA" - standard T-SQL syntax.
>
>I then tried to read these results in via XMLToCursor and got an error that the XML format was wrong.
>
>Fox error was:
>XML Parse error: Only one top level element is allowed in an XML document.
>Line 1, Position 284. (open_arrow)row sys_code="343-461-02 " pipe=" 1" mile_post=" 1 " ... ~all the rest of my fields and values~ .../(close_arrow)
>
>Opening the two XML files in Netscape nets me more errors.
>The RAW file gets "XML Parsing Error: junk after document element", pointing at the begging of the next "row..." entry.
>
>The other format gets the same error, except it points at the first table entry after the schema block.
>
>If anyone has ever fought with this situation, I'd appreciate any help you can offer.
>
>Thanks much~
Previous
Reply
Map
View

Click here to load this message in the networking platform