David,

You can return only a single value from VFP stored procedure in VFP8 and earlier. It'll be possible to return a Recordset in VFP9.

>
>I have tried almost everything I can think of to make this work, but to no avail. I also didn't find any answer on the net, although this sounds like a very classical question.
>
>We are using VFP as a front end and a VFP database as a back end, sending commands via ADO, using the VFPOLEDB.1 OleDb provider (for those who will ask, the reason for the VFP database is we already have a VFP all-in-one software that we would like to split into a client and a remote database ; the reason for ADO is that we don't want to be bound to a VFP database and may still upgrade it to SQL Server or Oracle in the future).
>
>For easier maintenance and integrity, I would very much like the database to be exposed only through stored procedures. Unfortunately, while everything else works fine, I have not yet been able to retrieve either a Foxpro cursor, either an ADO RecordSet from a stored procedure. All what I managed to get is a single result. I could get a RecordSet or a cursor (via the CursorAdapter) from a SQL query, but not from a stored procedure.
>
>I heard about such a limitation with the .NET OleDb provider. Is it the same from VFP to VFP ? Is there a workaround ? I may well have missed a simple way to get these result sets, but I didn't find any documentation about this, all I could do was trying and trying.
>
>For instance, the following naive try doesn't work and returns only a one-row recordset.
>Stored procedure :
<snip>