> Actually, I suppose I could do:
>
> CREATE TRIGGER EXTENDED_TEXT_DEL FOR EXTENDED_TEXT
> ACTIVE BEFORE DELETE
> POSITION 10
> AS
> begin
> insert into audit_trail
> values (null, null, null, 45, 1,
> old.Extended_Text_Type||"|"||
> old.Foreign_Id||"|"||
> old.Extended_Text_Sequence_No,
> old.Extended_Text_Type||"|"||
> old.Foreign_Id||"|"||
> old.Extended_Text_Sequence_No||"|"||
> old.Free_Text, null
> );
> END
>
> replacing the missing fields with null.
> Should that work?

Why not providing real values if you know them instead of null?



--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/