SQLClient.SQLConnection

  • Thread starter Thread starter Dimitris D
  • Start date Start date
D

Dimitris D

Well here is my problem
a have a store procedure in example like this one

create procedure dbo.proc
as
set nocount on
declare @x
// do some actions here
// and finally return multiple recordset
select * from tbl1 where ....
select * from tbl2 where ....
select * from tbl3 where ....
set nocount of

now if i drop table tbl3 and exec the store procedure from
Query analyzer i sure get an error that table tbl3 does
not exists.
But when i call the procedure from an SQLCommand object
from .Net i get nothing!!!!!!

This error i created by mistake but that's not the problem.
How gan i get the error??
i use this connection string
server=MyServer;uid=sa;pwd=;database=MyDatabase
And i also have a question.
If i call an insert into a table witch has a trigger that
makes an insert into an other table and the insert does
not succeed will i get the error code??
Or becose the nested levels are many i will not get an
error??
 
your sp returns three results sets. as the sp was precompiled, it will not
get an error until it has already returned two resultsets to the client
(error free). your code has to process all results set and check the errors
for each one.

-- bruce (sqlwork.com)
 
Back
Top