Getting double count of updated records

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have an SQL statement that uses the Command method ExecuteNonQuery and it
is returning twice the number of rows (24) actually updated. When I run the
same statement using SQL SELECT I get 12 rows. Below is my ASP.NET SQL
code:

strSQL = "UPDATE File_Mst" & _

" SET CheckedOut = 12345" & _

" WHERE ([BoxNum] Like N'%41644%')" & _

" AND ([CheckedOut] = 0)"


cmdSelect = New SqlCommand(strSQL, conFileData)

intRecsProcessed = cmdSelect.ExecuteNonQuery()

The variable intRecsProcessed is returning a count of 24 but only 12 rows
are affected. Can someone help with this? Thank you.

David
 
I think I found out why. I have an update trigger on the table that updates
another field on that same table. Does this affect the returned count?
Thanks.

David
 
Yes. If you add "SET NOCOUNT ON" for the update trigger's procedure, I
think it will then *not* return those updated rows in your rowcount.

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-------------------------------
David said:
I think I found out why. I have an update trigger on the table that
updates another field on that same table. Does this affect the returned
count? Thanks.

David

David said:
I have an SQL statement that uses the Command method ExecuteNonQuery and
it is returning twice the number of rows (24) actually updated. When I
run the same statement using SQL SELECT I get 12 rows. Below is my
ASP.NET SQL code:

strSQL = "UPDATE File_Mst" & _

" SET CheckedOut = 12345" & _

" WHERE ([BoxNum] Like N'%41644%')" & _

" AND ([CheckedOut] = 0)"


cmdSelect = New SqlCommand(strSQL, conFileData)

intRecsProcessed = cmdSelect.ExecuteNonQuery()

The variable intRecsProcessed is returning a count of 24 but only 12
rows are affected. Can someone help with this? Thank you.

David
Click to expand...
Click to expand...
 
Thanks. I'll try that. That makes sense.

David

RobinS said:
Yes. If you add "SET NOCOUNT ON" for the update trigger's procedure, I
think it will then *not* return those updated rows in your rowcount.

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-------------------------------
David said:
I think I found out why. I have an update trigger on the table that
updates another field on that same table. Does this affect the returned
count? Thanks.

David

David said:
I have an SQL statement that uses the Command method ExecuteNonQuery and
it is returning twice the number of rows (24) actually updated. When I
run the same statement using SQL SELECT I get 12 rows. Below is my
ASP.NET SQL code:

strSQL = "UPDATE File_Mst" & _

" SET CheckedOut = 12345" & _

" WHERE ([BoxNum] Like N'%41644%')" & _

" AND ([CheckedOut] = 0)"


cmdSelect = New SqlCommand(strSQL, conFileData)

intRecsProcessed = cmdSelect.ExecuteNonQuery()

The variable intRecsProcessed is returning a count of 24 but only 12
rows are affected. Can someone help with this? Thank you.

David
Click to expand...
Click to expand...
Click to expand...
 
Back
Top