Wiki Home

SQL Server SPOUTPUT


Namespace: VFP
I have tried to execute a stored procedure in the following way and it doesn't work

cOutParam = ''
SQLExec(nConHand,[exec MySp 'SomeValue', [email protected]])
? cOutParam

I want to return a value from a stored procedure

because it doesn't work?


check the following link for examples
http://www.tek-tips.com/faqs.cfm?fid=70

Cheers
Rajani

What code did you use for your Stored Procedure? The Calling-code isn't identical to the example either. The example uses the CALL keyword, whereas you're using EXEC instead Tim Hustler


Thanks ... Work fine
( Topic last updated: 2004.10.11 10:07:31 AM )