Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Output Parameter and SQL PassThru ??
Message
De
18/08/2004 07:29:57
 
 
À
18/08/2004 07:19:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00934057
Message ID:
00934058
Vues:
32
This message has been marked as the solution to the initial question of the thread.
Angie,

Try something like this:
*-- initialize output memvar
lnOutput = 0
*-- pass lnOutput by reference
SQLEXEC(lnSql, "EXEC YourSproc ?@lnOutput")
*-- should now contain the updated output value
?lnOuput
HTH

>Hello everyone,
>
>I would like to use a SQL passthru call to execute a SQL server 2000 sproc that updates an output parameter. Obviously, I want to be able to access/read the output parameter value in VFP.
>
>Could anyone please share some sample code showing how to do this in VFP?
>
>Thank you so much!
>
>Angie
Daniel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform