Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access stored procedure
Message
 
To
03/01/1999 04:21:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00172117
Message ID:
00172259
Views:
21
>>Bui Chi,
>>
>>The issue is not the ODBC driver but what code is in the stored procedure. What is the code that causes the error (from the stored procedure in VFP)?
>
>Jim,
>
>I used a simple function as follow:
>
>function plus(a,b)
> return a+b

Bui Chi,

That code should not cause the error, but other code will. There is a help file with the VFP ODBC driver that lists all of teh commands that are NOT supported through ODBC.

Is this ode being called by one of the rules on a field or table, or are you trying to execute it with SQLExec()? I don't kow that the VFP stored procedures are available to be called with SQLExec, but hey do work when they are called from a database rule and they don't contain any of the disallowed commands.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform