XML Retreival

Ryan · 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 · 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 · Post by **Ryan** » Wed 02 Feb 2005 17:55

What does "perform any conversions under retrieved" mean?

Ikar · 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.