Subject Re: [firebird-support] acces on old field value on after delete
Author Helen Borrie
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

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