>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement