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

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

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

Error constant SQLE_UPDATE_NOT_IN_SELECT
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 Name of the column that does not appear in the SELECT clause.
Severity 15
SQLCODE –815
SQLSTATE 42W38
Sybase error code 7740
Probable cause

You attempted to update a column that does not explicitly appear in the select list. The ansi_update_constraints option controls whether this update is allowed.