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 (T-Z)


WITH CHECK OPTION violated for insert/update on base table '%1'

ODBC 2 State S1000
ODBC 3 State 44000
Parameter 1 Name of the base table being updated.
Severity 16
Sybase error code 550
Probable cause

You attempted an insert or update operation on the indicated base table through a view (possibly nested). However, one or more values in the modified row(s) triggered a WITH CHECK OPTION violation. This violation occurs when a modified value causes one or more rows to fall outside the range of the view by making the view's WHERE clause evaluate to FALSE or UNKNOWN for that row.