Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

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

Error 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.