[firebird-support] problem creating trigger FB 1.5

[Bart Smissaert]

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

which will give the following error:

Dynamic SQL Error
SQL error code = -817
Metadata update statement is not allowed by the current database SQL dialect 1.

Note the double quotes around the field name Action.

Any idea how I can run this statement?


RBS