Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Update operation attempted on a read-only cursor Next Page

Update operation attempted on non-updatable query

Item

Value

Constant

SQLE_NON_UPDATEABLE_VIEW

ODBC 2 State

42000

ODBC 3 State

42000

Severity

15

SQLCODE

-192

SQLSTATE

42W31

Sybase error code

7301

Probable cause

You attempted an insert, update, or delete operation on a query that is implicitly read-only. Queries that contain DISTINCT, GROUP BY, HAVING, EXCEPT, INTERSECT or UNION, or that contain aggregate functions, or that involve a join, are implicitly read only. If the query references a view then the view may be non-updatable.