Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySQL Parameters with VFP9
Message
From
06/12/2011 18:42:53
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
 
To
06/12/2011 16:45:13
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01530474
Message ID:
01530483
Views:
75
since the second parameter is is out you might try and this.
lcsql = [call proctest(?abc,?@retv)]
?SQLEXEC(gnhandle,lcsql)
?retv

>What is wrong with this code?
>
>abc=0
>retv=0
>lcsql = [call proctest(?abc,?retv)]
>?SQLEXEC(gnhandle,lcsql)
>
>Trying to pass parameters to the following stored procedure in MySQL:
>create procedure proctest(IN retv int, OUT retoutv int)
>begin
>set retoutv = -999;
>
>end
>
>What is the correct syntax, I know in MS SQL Server it works, but can't get this to work in MySQL?
>Aerror:
> 1526 ( 1526.00000000)
> ( 1, 2) C "Connectivity error: [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]OUT or INOUT argument 2 for routine norco_sales.proctest is not a variable or NEW pseudo-variable in BEFORE trigger"
> ( 1, 3) C "[MySQL][ODBC 5.1 Driver][mysqld-5.5.8]OUT or INOUT argument 2 for routine norco_sales.proctest is not a variable or NEW pseudo-variable in BEFORE trigger"
> ( 1, 4) C "S1000"
>
>Any help is much appreciated.
>
>Thanks,
>Joy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform