At 09.12 16/01/2002 +0200, you wrote:

>I do now know very vell, but I may help you if you send detailed information
>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.

Yes but if the trigger is an AFTER UPDATE
and the procedure inserts in the view this should not happen.
Also I solved the problem simply modifying the procedure so that
it will insert in the base tables instead that on the view and all works
correctly.
The only "AFTER INSERT" trigger that I have on the view simply makes the
insert in the tables.

>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

If I have been cleaner now, tell me...
Regards
Marco