Collection Contents Index Computed columns are not supported in this database Next PDF

SQL Anywhere® 10 - Error Messages  > Database Error Messages  > Alphabetic list of error messages

Conflicting INSTEAD OF trigger and WITH CHECK OPTION on view '%1'


Item

Value

Constant

SQLE_CHECK_TRIGGER_CONFLICT

ODBC 2 State

42000

ODBC 3 State

42000

Parameter 1

Name of the view with an INSTEAD OF trigger

Severity

15

SQLCODE

-1125

SQLSTATE

42W39

Sybase error code

13388

Probable cause

You attempted an operation that involves a WITH CHECK OPTION clause that conflicts with an INSTEAD OF trigger. A view defined with the WITH CHECK OPTION clause cannot refer to a view (possibly nested) with an INSTEAD OF trigger.


Collection Contents Index Computed columns are not supported in this database Next PDF