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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only