>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only