I see. I will give that a try, thank you.
>You cannot call VFP stored procedure thru ODBC. You have to use OLE DB provider for VFP that comes with VFP 7.
>
>>I am developing an n-tier application. For now, I'd like to have my VFP middle tier use ODBC to connect to a VFP datasource. The back-end data will have several stored procedures that my middle tier will need to call.
>>
>>How do I call a stored procedure in a VFP database via SQL Pass thru. As a work-around, I put a one-row-table, called SP, in the vfp database and use SQLEXEC to send a query to the DB with the stored procedure as a column. Like this:
>>
>>SQLEXEC(nHandle,'SELECT SP_TEST() AS result FROM SP','SPResult')
>>
>>Although this works, it seems kind of silly. There must be a better way.
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