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