"FOR UPDATE has been incorrectly specified for a READ ONLY cursor"
| Item | Description |
|---|---|
|
SQLCode |
-813L |
|
Constant |
NON_UPDATEABLE_CURSOR |
|
SQLState |
42W36 |
|
ODBC 2 State |
42000 |
|
ODBC 3 State |
42000 |
|
Sybase Error Code |
2460 |
|
Severity Code |
You attempted to declare a cursor FOR UPDATE on a query that is not updatable. Queries that contain DISTINCT, GROUP BY, HAVING, INTERSECT, EXCEPT, or UNION, or that contain aggregate functions are read-only. If the ansi_update_constraints option is on, then queries that contain a join are read-only. If the query references a view then the view may be non-updatable.