> 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?

You can't with dialect 1. Delimited identifiers are supported by dialect
3. Use non-reserved keywords as object names in a dialect 1 database.


--
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/