Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to run store procedures in VFP database from ODBC?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00579038
Message ID:
00579073
Vues:
27
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform