Error 833

"Row in table '%1' was modified or deleted in BEFORE trigger"

Item Description

SQLCode

-833L

Constant

ROW_REMODIFIED_OR_DELETED

SQLState

42W62

ODBC 2 State

37000

ODBC 3 State

ERROR

Sybase Error Code

2480

Severity Code

16

Parameter 1

Name of the table.

Probable cause

A BEFORE trigger has updated or deleted the row that caused the trigger to fire, preventing the original operation from completing. The trigger must be re-written so that it does not attempt to change the row via UPDATE or DELETE statements.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com