hello,Bart Can you try this?
not "Action",but "action" 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 (2011/11/15 17:38), Bart Smissaert wrote: > > 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 > > -- /////ﾉﾍﾞﾙｯﾄ/////////////////////////////////////////////// 株式会社 ノベルット ソフトウェア インダストリー 代表取締役 渡辺 伸雄 〒144-0043 東京都 大田区 羽田２－１２－３ Tel:03-5705-2595 mobile-phone:080-3430-2595 070-5582-6540 Email:[email protected] ///////////////////////////////////////////////ﾉﾍﾞﾙｯﾄ///// [Non-text portions of this message have been removed]
