Error 815

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

Item Description

SQLCode

-815L

Constant

UPDATE_NOT_IN_SELECT

SQLState

42W38

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2462

Severity Code

15

Parameter 1

Name of the column that does not appear in the SELECT clause.

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.


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