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~
Chris Zangarine
Software Development Engineer
Pipeline Compliance System (PCS)
American Innovations