Subject | RE: [ib-support] PROBLEM WITH TRIGGERS AND VIEWS |
---|---|
Author | KURSAT TASKIN |
Post date | 2002-01-16T07:12:09Z |
Marco Wrote;
about your view, trigger and procedure.
I guess something (if I am wrong please correct me)
If you have a view, and a trigger (after update) and then a procedure
called by trigger, and this procedure updates wiew then the I think there
will be a loop.
view calls trigger, then trigger calls procudure and procedure inserts a new
record, then since view updated trigger will be called again and procedure
will be called again bla bla bla....
If I understand you, I think you should change the syntax
sorry for my bad english
Kursat
> Hello All,I do now know very vell, but I may help you if you send detailed information
> 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
> 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.
about your view, trigger and procedure.
I guess something (if I am wrong please correct me)
If you have a view, and a trigger (after update) and then a procedure
called by trigger, and this procedure updates wiew then the I think there
will be a loop.
view calls trigger, then trigger calls procudure and procedure inserts a new
record, then since view updated trigger will be called again and procedure
will be called again bla bla bla....
If I understand you, I think you should change the syntax
sorry for my bad english
Kursat
> 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