Ah. that info is certainly helpful, but my understanding is that if values are to be passed back to the ADO objects, I must use the adCmdStoredProc - CmdText wont work. Is that right? I'll see if I can find that readme.htm document - perhaps there is a work around(?)


>>Apparently, in order to retrieve a return value, I first need to use the "adCmdStoredProc" CommandType, then set up a Parameter object, append that param. object to the Command object's parameter collection and then execute the command at which time the Parameter(0) object should contain the return value. the problem is, I can't get the stored procedure command type (adCmdStoredProc) to work when calling the vfp stored procedure. Instead I get the Ole error "Unrecognized Command Verb"
>>
>>So, either this CommandType is simply not valid when the data source is a VFP dbc, or I am missing something in the CommandText. Here's the exact code I have:
>
>There's a bug in VFP OLEDB provider. It's docimented in the Readme.htm on VFP installation cd:
>Syntax of Stored Procedure Calls in Visual FoxPro OLE DB Provider. When calling a stored procedure using the Visual FoxPro OLE DB Provider, set CommandType to adCmdText (1) or to adCmdUnknown (8), and not to adStoredProc (4). Visual FoxPro requires that stored procedures have open and close parentheses "()" at the end of the stored procedure name. However, ADO removes the parentheses from the end of the stored procedure name when you use adStoreProc.