Thanks, did try your suggestion, but gives the same error: Dynamic SQL Error SQL error code = -817 Metadata update statement is not allowed by the current database SQL dialect 1
Have also tried "ACTION" with same result. RBS On Tue, Nov 15, 2011 at 10:36 AM, 渡辺 <[email protected]> wrote: > ** > > > 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] > > > [Non-text portions of this message have been removed]
