Very Computer

I have a procedure that executes an UPDATE and after, some output variables
are set with determined values.

The problem is, after the UPDATE statment, all following variables are
reseteds to null value!
If I remove/comment the UPDATE code, the output variables are returned OK to
my application (uses ADO 2.5/2.6, via command object).

Anyone knows happen?

The code is look like this:

AS

(...)

-- get resultset

--set the variables

Tks in advance!

Cesar

1. You want to add 'set nocount on' to the begining of the procedure.
2. It's by design that SQL Server does not send back the values for the
return code or output parameters until the end of all result sets for the
procedure. So, you want to adjust your code accordingly.
3. I do not see the update code. You might want to post a complete text so
we can see.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net

I did not posted the entire code because I was think no relevant.

But, I use another way to return my responses, through

My code already so changed!

Tks for response.

Cesar,

1. You want to add 'set nocount on' to the begining of the procedure.
2. It's by design that SQL Server does not send back the values for the
return code or output parameters until the end of all result sets for the
procedure. So, you want to adjust your code accordingly.
3. I do not see the update code. You might want to post a complete text so
we can see.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net