Невозможность использовать Update, если в View есть поле типа Blob

← →
Malder (2002-03-11 17:18) [4]

A view is updatable if:

It is a subset of a single table or another updatable view.
All base table columns excluded from the view definition allow NULL values.
The view"s SELECT statement does not contain subqueries, a DISTINCT predicate, a HAVING clause, aggregate functions, joined tables, user-defined functions, or stored procedures.

If the view definition does not meet these conditions, it is considered read-only.

Note Read-only views can be updated by using a combination of user-defined referential constraints, triggers, and unique indexes.

вроде здесь нет противоречий с использованием Blob...

Невозможность использовать Update, если в View есть поле типа Blob Найти похожие ветки