Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MySQL Parameters with VFP9
Message
De
06/12/2011 18:42:53
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
06/12/2011 16:45:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01530474
Message ID:
01530483
Vues:
81
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform