At 09.08 16/01/2002 +0000, you wrote:

>--- In ib-support@y..., Marco Lauria <mslauria@t...> wrote:
> > Hello All,
> > I ended up isolating the problem for which I already posted 3
>messages
> > without answers.
> > I can understand that here no one here is interested in views with
>triggers,
> > but someone can tell this to me.....
> > however here it is the problem:
> > if I have a "after update" trigger on VIEW A
>I think that you must to have "before update" triggers for making
>your view "updatable".

I have a BEFORE INSERT/ BEFORE UPDATE/BEFORE DELETE that make the view
updateable.
Also I have an AFTER UPDATE that does some things on other tables and calls
a procedure
that can insert a record in this same view.
NOTE the trigger is an after update and the procedure makes INSERT so there
should be no LOOP.
I solved changing the procedure so that insert in the base tables instead
of inserting on the view,
but this isn't the right solution.

Regards
Marco