>>Hi all,
>>I have a VFP stored procedure in my VFP database named as: GetUser() which returns a string (xml). I am not accessing the VFP database directly and use ODBC to connect to it, can I use SQLEXEC() to call the stored procedure and accept the string?
>
>No, you cannot. You've to use VFP OLE DB provoder.

How do I get the returned string from the Ado object? Looking at the ADO object, I don't see a property where the results might be stored. The simplest implementation I can think of is:

xx=""
numericValIsReturned = 0
oConn = createobject('ADODB.Connection')
cConnString = "Provider=vfpoledb.1;Data Source=Test.dbc"
oConn.Open(cConnString)
oConn.Execute('GetUser()') && How do I capture the returned string?
oConn.Execute('GetUser()',@xx) && Returns number of rows?
oConn.Execute('GetUser()',@xx,@numericValIsReturned) && Returns a numeric value?
oConn.Close()
?xx,numericValIsReturned