Update operation attempted on non-updatable query
Item |
Value |
|---|---|
SQLCode |
-192 |
Constant |
SQLE_NON_UPDATEABLE_VIEW |
SQLState |
42W31 |
ODBC State |
42000 |
You have attempted an insert or delete operation on a query that is implicitly read-only. An updatable query may not contain DISTINCT, GROUP BY, HAVING, or UNION, nor may it contain aggregate functions or involve a join. If the query references a view then the query expression that defines the view must itself be updatable.
