CHAPTER 10 Database Error Messages
749
Cannot update an expression
Item Value
SQLCODE -190
Constant SQLE_NON_UPDATEABLE_COLUMN
SQLSTATE 53W02
Sybase error code 230
ODBC 2 State 37000
ODBC 3 State 42000
You tried to update a column in a query that is a database expression rather
than a column in a table.
Cannot update column ’%1’ since it appears in the ORDER BY
clause.
Item Value
SQLCODE -814
Constant SQLE_CANNOT_UPDATE_ORDER_BY_COLUMN
SQLSTATE 42W37
Sybase error code 6267
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 Name of the column that appears in the ORDER BY
clause.
You attempted to update a column that appears in the ORDER BY clause.
The ANSI_UPDATE_CONSTRAINTS option controls whether this update
is allowed.
Probable cause
Probable cause
To Next Page
Loading...