Search Persits Software Knowledge Base

 

Article PS041020146

Row cannot be located for updating error when triggers are in use

Problem Description

When using AspGrid with SQL Server, and the database table uses triggers, the following errors may occur:

AspGrid Update Error. Row cannot be located for updating. Some values may have been changed since it was last read.

AspGrid Insert Error. Row cannot be located for updating. Some values may have been changed since it was last

Solution

Modify your trigger(s) as follows:

Set nocount on

(rest of trigger)

Set nocount off

Created: 10/20/2004 1:46:34 PM
Last Modified: 10/20/2004 1:46:34 PM

Copyright © Persits Software, Inc. 1998 - 2018
For technical support, write to support@persits.com.