In this blog post, you’ll learn more about the Sybase Error Cannot update column ‘%1’ since it appears in the ORDER BY clause and the reason for receiving this error
Sybase SQL Error Message
Cannot update column ‘%1’ since it appears in the ORDER BY clause
Reason for this Error
You attempted to update a column that appears in the ORDER BY clause. The ansi_update_constraints option controls whether this update is allowed.