Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run store procedures in VFP database from ODBC?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00579038
Message ID:
00579073
Views:
28
>Hi all,
>
>1) I have a VFP Database with store procedures. I need to run to a stor procedure to get some values from the ADO through VFP ODBC driver.
>
>How to do it??

You can't. In order to run VFP SPs, you need to use the new OLE-DB provider for VFP that comes with VFP 7.

The only SPs that are executed by the ODBC driver are SPs that are executed via a trigger.

>
>2) How to open a view with parameter in VFP database from ADO ???

See Message#555818.

>
>Thanks in advance!
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform