Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return vfp cursor through odbc?
Message
From
15/01/1999 12:50:46
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00175764
Message ID:
00176576
Views:
33
>VFP Stored Procs cannot be invoked as in the case of backends like SQL-Server. There is a limited command set that is supported by the driver - like Set Reprocess, etc. Otherwise, you would have a 2 mb ODBC Driver.. This is the big limitation of using VFP as an ODBC Backend..
>
>>Is there a way to return a VFP cursor from a stored procedure in a dbc through odbc?

Thanks,

I thought as much, I had to confirm. I can get close by writing a stored procedure that will return parameters for a query, when invoked with the "select sp() from n-rows_table" technique. Then I can do the final query from the client.
Previous
Reply
Map
View

Click here to load this message in the networking platform