>>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()')
oConn.Execute('GetUser()',@xx)
oConn.Execute('GetUser()',@xx,@numericValIsReturned)
oConn.Close()
?xx,numericValIsReturned
ramil
~~ learning to stand still