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