"David" <dlchase@lifetimeinc.com> wrote in message
news:OyelTbWRHHA.1000@TK2MSFTNGP05.phx.gbl...
>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
>

"David" <dlchase@lifetimeinc.com> wrote in message
news:uf39oVXRHHA.3440@TK2MSFTNGP03.phx.gbl...
>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@lifetimeinc.com> wrote in message
> news:OyelTbWRHHA.1000@TK2MSFTNGP05.phx.gbl...
>>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
>>
>
>

"RobinS" <RobinS@NoSpam.yah.none> wrote in message
news:NeednVBqNoosglzYnZ2dnUVZ_vqpnZ2d@comcast.com...
> 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" <dlchase@lifetimeinc.com> wrote in message
> news:uf39oVXRHHA.3440@TK2MSFTNGP03.phx.gbl...
>>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@lifetimeinc.com> wrote in message
>> news:OyelTbWRHHA.1000@TK2MSFTNGP05.phx.gbl...
>>>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
>>>
>>
>>
>
>