Thanks for the quick reply.
I forgot to say that other users who have exactly the same setup do have
this trigger,
so somehow it must have been possible to create it.
No idea though how.

RBS

On Tue, Nov 15, 2011 at 8:41 AM, Martijn Tonies <m.tonies@...>wrote:

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


[Non-text portions of this message have been removed]