Mahesh Ishwar wrote:

>Thanx for ur prompt response.
>In my existing Oracle database, I've to write a statement level trigger becoz of th eproblem of mutating table restriction describe as under :
>
>".... the mutable table restriction on row level triggers (which says records in the table originating the trigger or or as a part of cascade delete can not be mutated by the tigger."
>
>I just wanted to know is this possible in Firebird that a trigger which is evoked after an insert in a row does some calculation on some other tables and then deletes this row itself?
>

Yes, though more commonly that is done with view triggers.

Regards,


Ann