In this blog post, you’ll learn more about the Sybase Error Cannot update column ‘%1’ since it does not appear in the SELECT clause and the reason for receiving this error
Sybase SQL Error Message
Cannot update column ‘%1’ since it does not appear in the SELECT clause
Reason for this Error
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.