Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return of a stored procedure
Message
From
20/12/2002 09:51:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Return of a stored procedure
Miscellaneous
Thread ID:
00734869
Message ID:
00734869
Views:
47
hello *.*

I'm working with SQL SERVER 2000 and VFP7, using ADO.
I created a stored procedure with a return, like this:
CREATE PROCEDURE Contador
@Valor1 int,
@Valor2 int,
@nRetorno int output
AS
SET @nRetorno = @valor1 + @valor2
If I run it from query analyser such as:
declare @resposta int
exec contador 1,2, @resposta output
select @resposta
It's run without problems, but how do I do to return the value to VFP ?
If I do a select and run I can get the fields with this command:
recordset.fields.("name_of_my_field").value
or
recordset.fields.(0).value
But it don't run ok when I run the stored procedure. Why ?

Thank you all!
Next
Reply
Map
View

Click here to load this message in the networking platform