Subject | Re: PROBLEM WITH TRIGGERS AND VIEWS |
---|---|
Author | prokhorovav |
Post date | 2002-01-16T09:08:13Z |
--- In ib-support@y..., Marco Lauria <mslauria@t...> wrote:
your view "updatable".
Best regards
Andrey Prokhorov
> Hello All,messages
> I ended up isolating the problem for which I already posted 3
> without answers.triggers,
> I can understand that here no one here is interested in views with
> but someone can tell this to me.....I think that you must to have "before update" triggers for making
> however here it is the problem:
> if I have a "after update" trigger on VIEW A
your view "updatable".
> and in this trigger I call a procedureThis will be better.
> 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
Best regards
Andrey Prokhorov