Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call a Stored Procedure via Select-SQL by ODBC
Message
 
 
To
28/03/2001 10:57:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00489455
Message ID:
00489473
Views:
9
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform