Error 814

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

Item Description

SQLCode

-814L

Constant

CANNOT_UPDATE_ORDER_BY_COLUMN

SQLState

42W37

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2461

Severity Code

15

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.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com