Hello Bart,

Dialect 1 doesn't do delimited identifiers - so "action" is out.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

> 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
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>