Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Output Parameter and SQL PassThru ??
Message
From
18/08/2004 07:29:57
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00934057
Message ID:
00934058
Views:
31
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform