Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to call stored procedure from remote VFP database.
Message
From
29/12/2000 09:06:19
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
29/12/2000 03:04:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457686
Message ID:
00457719
Views:
24
>I have an application which uses VFP database through ODBC so that in future the Bacend can be changed.
>How to call stored procedure from remote VFP database ?
>Rajesh

Rajesh,

This was posted by Chad Bourque on the ProFox list recently:
    AFAIK it is possible. Simply call the function by its name: 
 
    mySPF() 
 
    or 
 
    retVal = mySPF() 
 
    I know you can do it through ODBC within SQL statements: 
 
    sqlExec(lnHandle, [select mySPF() from table], [curResult])
I have not tried it.
Previous
Reply
Map
View

Click here to load this message in the networking platform