ors = oConn.Execute('GetUser()')
? oRs.Fields(0).Value

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