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

Item	Value
SQLCODE	-815
Constant	SQLE_UPDATE_NOT_IN_SELECT
SQLSTATE	42W38
Sybase error code	7740
ODBC 2 State	42000
ODBC 3 State	42000
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.