Contents Index Cannot update an expression Cannot update column '%1' since it does not appear in the SELECT clause.

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

Cannot update column '%1' since it appears in the ORDER BY clause.


Item Value
SQLCODE -814
Constant SQLE_CANNOT_UPDATE_ORDER_BY_COLUMN
SQLSTATE 42W37
Sybase error code 6267
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 Name of the column that appears in the ORDER BY clause.
Probable cause 

You attempted to update a column that appears in the ORDER BY clause. The ANSI_UPDATE_CONSTRAINTS option controls whether this update is allowed.


Contents Index Cannot update an expression Cannot update column '%1' since it does not appear in the SELECT clause.