Subject Re: PROBLEM WITH TRIGGERS AND VIEWS
Author prokhorovav
--- 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".

> and in this trigger I call a procedure
> everything goes well till when the procedure
> for an instance has an insert on the same view.
> In this last case FB puts treats the trigger as Readonly.
> Why is this happening??
> Can someone please answer me?
> Regards
> Marco
> P.S. I can post the code
This will be better.

Best regards
Andrey Prokhorov