>>
>>oRS=oConn.Execute('StoredProc(Parms)')
>>luRetVAl = oRS.fields(0).Value
>>Cetin
>
>Hi Cetin,
>
>That works perfectly when I'm using ADO objects. What I'm trying to do is find the correct syntax for the SelectCmd property of the CA to execute the proc and return the rowset when I fire the CursorFill().
>
>Also, I wasn't aware that the CA had Connection/Recordset objects that I could get to/mess with/query. Is this the case, and if so, how do I state the object reference (something like oCursorAdapter.ActiveConnection or somesuch)?
>
Hi Evan,
I was under impression that VFPOLEDB doesn't return recordsets from procedures. However, if you are really able to make it work thru ADO directly then you should be able to do make it work thru CursorAdapter. Read help topic for CursorAdapter.CursorFill method (pay attention to nOptions parameter). Also, read help topic for CursorAdapter.DataSource property (this is the property you should assign the Recordset object to).
Thanks,
Aleksey.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only