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

Cannot update column '%1' since it does not appear in the SELECT clause Next Page

Cannot update materialized view because option '%1' has an inappropriate setting


Item

Value

Constant

SQLE_CANNOT_UPDATE_MATVIEW

ODBC 2 State

42000

ODBC 3 State

ERROR

Parameter 1

Name of the option with the incorrect setting.

Severity

14

SQLCODE

-1052

SQLSTATE

42WB7

Sybase error code

13461

Probable cause

You attempted to update/refresh a materialized view but one of the database options is currently set to a value that is not permitted while updating a materialized view, or, the option's setting does not match the value when the view was created.