XML Retreival

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ryan

XML Retreival

Post by Ryan » Mon 31 Jan 2005 19:28

When I set my query to return FOR XML AUTO, how can I get the XML out into a string? We are using TMSStoredProc.

Thanks

RYan

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 01 Feb 2005 09:59

SDAC doesn't perform any conversions under retrieved as a result of query data. Try to search for an answer in MSDN

Ryan

XML

Post by Ryan » Wed 02 Feb 2005 17:55

What does "perform any conversions under retrieved" mean?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 03 Feb 2005 09:32

A result of this query doesn't pass any additional processing. So server returns through OLE DB data in some format and SDAC by Fields[] returns it at the same type without any conversion.

Post Reply