>>No. A stored procedure will return a separate recordset for each SELECT which doesn't store data in the local variables. IOW, a stored procedure may return multiple record sets.
>>
>
>Thank you. But how do I declare in my VFP code that calls a sproc that the sproc will return a record set?
There's nothing to declare in VFP. If you're using SPT then 3rd parameter in SQLEXEC() will specify the name of the first cursor returned. The second and so on cursors will have the same name with sequential number added. For example, SQLEXEC(lnConn, "EXEC mysp", "crsRes"). The second cursor returned will be 'crsRes1', the third 'crsRes2', etc
--sb--