How to read XML content returned from stored proc
Posted: Mon 29 Feb 2016 15:09
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?
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?