Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call a Stored Procedure via Select-SQL by ODBC
Message
 
 
À
28/03/2001 10:57:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00489455
Message ID:
00489473
Vues:
8
>I created a Stored Procedure in my VFP database. The SP return
>the age when the parameter date of birth is passed. I tried to
>call the SP in a Select-SQL (using ODBC) like this:
>
>Select distinct fcGetAge("02/11/1966") from AnyTableOfDatabase
>... the query returns 35. Everything works fine... yesterday.
>
>But today, I tried the same query and I got the following message:
>[Microsoft][ODBC Visual FoxPro Driver]Feature is not available
>
>What is the problem with ODBC today?

It shouldn't work either day. SP calls are not supported using the ODBC driver. The only SPs that are run when you use ODBC are ones called in triggers.

FWIW, the OLE-DB provider that comes with VFP 7 can execute SPs.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform