Re: trigger on view

Tinks, if the error message Ianal posted isn't clear then what the error is telling you is that an instead of trigger basically converts an insert, update, or delete against a view into an action against base tables that are used in the view.

Instead of triggers only work on views that are updated and the view you are working with is declared as READ ONLY so it cannot be updated hence an instead of trigger makes no sense at all.

You need to re-create the view without the READ ONLY subquery restriction clause. See the CREATE VIEW statement in the SQL manual.

HTH -- Mark D Powell -- Received on Fri Sep 09 2005 - 08:57:36 CDT