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 appears in the ORDER BY clause Next Page

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

Item

Value

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.