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?

Thanx once a'ain.
Regards,
Mahesh.




---------------------------------
Yahoo! Plus - For a better Internet experience


[Non-text portions of this message have been removed]