Error 192

"Update operation attempted on non-updatable query"

Item Description

SQLCode

-192L

Constant

NON_UPDATEABLE_VIEW

SQLState

42W31

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2123

Severity Code

15

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com