At 02:41 AM 28/08/2004 +0000, you wrote:

>Hi friendly Firebird users,
>
>Supppose I write a after delete trigger for a table. Do I still have
>an access on the old.fieldname value? or better yet instead of after
>delete use the before delete?

old.* values are available in Update and Delete triggers.
new.* values are available in Insert and Update triggers.

>My reason I want to use the after delete is because I just want to
>write a single trigger for after insert, after update and after delete
>event.

Sure, but it will have to include conditional blocks according to the
states of the Updating, Inserting and Deleting context variables.

./heLen