Update and Select Statement

[hngo01]

Hi to all, I have VB application calling a SP.

It works when:

--return this to application
SELECT *
FROM tblVariance
WHERE VarianceID = @VarID

--update table
UPDATE tblVariance
SET NetworkID=@NetworkID
WHERE VarianceID = @VarID

return 0

I would like to see update values: I placed the update
statement first. It doesnt work:

--update table
UPDATE tblVariance
SET NetworkID=@NetworkID
WHERE VarianceID = @VarID

--return this to application
SELECT *
FROM tblVariance
WHERE VarianceID = @VarID

return 0

any ideas. thanks

[Dan Guzman]

Try adding SET NOCOUNT ON to the beginning of your proc. If this
doesn't solve the problem, please specify details of your symptoms
rather than say 'it doesnt work'

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

[url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
[url]http://www.sqlserverfaq.com[/url]
[url]http://www.mssqlserver.com/faq[/url]
-----------------------

"hngo01" <hngo01@hotmail.com> wrote in message
news:0b9501c3417d$6f1d6260$a501280a@phx.gbl...

> Hi to all, I have VB application calling a SP.
>
> It works when:
>
> --return this to application
> SELECT *
> FROM tblVariance
> WHERE VarianceID = @VarID
>
> --update table
> UPDATE tblVariance
> SET NetworkID=@NetworkID
> WHERE VarianceID = @VarID
>
> return 0
>
> I would like to see update values: I placed the update
> statement first. It doesnt work:
>
> --update table
> UPDATE tblVariance
> SET NetworkID=@NetworkID
> WHERE VarianceID = @VarID
>
> --return this to application
> SELECT *
> FROM tblVariance
> WHERE VarianceID = @VarID
>
> return 0
>
> any ideas. thanks