Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Row has changed since last read -- operation canceled Next Page

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

Item

Value

Constant

SQLE_ROW_REMODIFIED_OR_DELETED

ODBC 2 State

37000

ODBC 3 State

ERROR

Parameter 1

Name of the table.

Severity

16

SQLCODE

-833

SQLSTATE

42W62

Sybase error code

13839

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.