CHAPTER 10 Database Error Messages
861
Row has changed since last read -- operation cancelled
Item Value
SQLCODE -208
Constant SQLE_ROW_UPDATED_SINCE_READ
SQLSTATE 22W02
Sybase error code 554
ODBC 2 State ERROR
ODBC 3 State ERROR
You attempted an UPDATE (positioned) or DELETE (positioned) operation
on a cursor declared as a SCROLL cursor, and the row you are changing has
been updated since you read it. This error prevents the ’lost update’ problem.
Row in table ’%1’ was modified or deleted in BEFORE trigger
Item Value
SQLCODE -833
Constant SQLE_ROW_REMODIFIED_OR_DELETED
SQLSTATE 42W62
Sybase error code 13839
ODBC 2 State 37000
ODBC 3 State ERROR
Parameter 1 Name of the table.
A BEFORE trigger has updated or deleted the row which 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.
Probable cause
Probable cause
To Next Page
Loading...