Paul,

I checked the settings and all looks fine.

Can you show me an example of a simple SQL in a stored procedure which can be called via VFP? I am confused on the correct syntax.

TIA

Rex

>Hi Rex,
>
>If your stored procedure asks for multiple rows, you should get multiple rows in your VFP cursor. If you are not getting all the rows, check your settings in VFP menu tools/options/remote data.
>
>Paul
>
>>Paul,
>>
>>Thanks for your reply. Another question: What do I need to do in my stored procedure to return multiple rows to the VFP app?
>>
>>