>>>Below's runnable sample code that shows how to call VFP SP with 2 date type parameters
>
><snip>
>
>The same for one character parameter
>>>oCmd.CommandText = [CustOrdersOrders(?)]
>>>lcCustomerID = "TOMSP"
>>>oPar = oCmd.CreateParameter(lcCustomerID, ;
>>> adVarChar, adParamInput, LEN(lcCustomerID), lcCustomerID)
>>>oCmd.Parameters.Append(oPar)
>>>oRs = oCmd.Execute()
>>>
>>
>>Can you return VFP cursor using this approach?
>
>See
Re: CursorAdapters and existing ADO recordsets Message #
824438I see. Also I guess I can just do
oConn.Execute('MySp('+transform(par1)+"," + transform(par2)+()') to retrieve my record set.
If it's not broken, fix it until it is.
My Blog