How to read XML content returned from stored proc

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sofetch
Posts: 7
Joined: Fri 12 Oct 2007 08:33

How to read XML content returned from stored proc

Post by sofetch » 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?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: How to read XML content returned from stored proc

Post by AlexP » Thu 03 Mar 2016 12:10

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).

Post Reply