Contents Index Update operation attempted on a read-only cursor Update operation attempted on non-updatable remote query

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

Update operation attempted on non-updatable query


Item Value
SQLCODE -192
Constant SQLE_NON_UPDATEABLE_VIEW
SQLSTATE 42W31
Sybase error code 7301
ODBC 2 State 42000
ODBC 3 State 42000
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.


Contents Index Update operation attempted on a read-only cursor Update operation attempted on non-updatable remote query