Hi
I have some procedures that return XML from select which has for xml explicit clause.
Recently I used ADO connection and SQLXML provider. Now I want to move to functionality embedded in SDAC.
I tried that
TMSXMLField(MSQuery1.Fields[0]).XML;
but I got an error:
"There is an error in XML document (1, 40).."
Is it possible to read content from stream without parsing it by SDAC?
How to read XML content returned from stored proc
Re: How to read XML content returned from stored proc
Hello,
We can't reproduce the issue. XML data is displayed correctly. Please specify the used versions of SDAC, SQL Server, client, and provide type (MSConnection1.Options.Provider).
We can't reproduce the issue. XML data is displayed correctly. Please specify the used versions of SDAC, SQL Server, client, and provide type (MSConnection1.Options.Provider).