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, 渡辺 <watanove@...> 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:watanove@...
> ///////////////////////////////////////////////ノベルット/////
>
>
> [Non-text portions of this message have been removed]
>
>
>


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