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.
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