--- In firebird-support@yahoogroups.com, Bart Smissaert <bart.smissaert@...> wrote:
>
> Running Firebird 1.5, classic, dialect 1 on Windows and trying to
> create a trigger like this:
>
> CREATE TRIGGER EXTENDED_TEXT_DEL FOR EXTENDED_TEXT
> ACTIVE BEFORE DELETE
> POSITION 10
> AS
> begin
> insert into audit_trail
> (Table_Id,"Action",Primary_Key,data)
> values (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
> );
> END

if you know all fielda (structure) and provide values
insert into audit_trail values(...)