Hi Steve,


The ability to return a recordset is built into VFP9 OLE DB provider. However VFP7 stored procedure cannot do that because VFP7 doesn't support this functionality. You can try to get around this limitation using EXECSCRIPT() and external PRG.

>
>Thanks. I have updated my VFPOLEDB provider to version 9.
>
>I read some of your earlier posts where you informed us that it was not possible to return a recordset from a stored procedure in VFP versions prior to VFP9.
>
>I assume then, that VFP9 has provisions for returning a recordset to ADO from a stored procedure?
>
>If so, does this mean that the VFP version under which the database was developed need to be version 9, or does the VFP9 VFPOLEDB provide this functionality when accessing earlier versions of VFP?
>
>In other words, can I use the VFPOLDB provider to return a recordset from a VFP7 database stored procedure, or is this a function of the installed version of VFP?
>
>
>Hope I'm making myself clear ....