Re: Getting double count of updated records

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" <dlchase@xxxxxxxxxxxxxxx> wrote in message
news:OyelTbWRHHA.1000@xxxxxxxxxxxxxxxxxxxxxxx
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



.