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]