I don't think that can work as the receiving table has other fields:

CREATE TABLE AUDIT_TRAIL(
AUDIT_ID INTEGER NOT NULL,
AUDIT_TIME TIMESTAMP,
USER_ID VARCHAR(12),
TABLE_ID SMALLINT,
ACTION SMALLINT,
PRIMARY_KEY VARCHAR(128),
DATA VARCHAR(5000),
PATIENT_ID INTEGER)


RBS

On Wed, Nov 16, 2011 at 6:58 AM, Pavle <pavle.grebenar@...> wrote:

> **
>
>
>
> Hi !
>
> --- In firebird-support@yahoogroups.com, Bart Smissaert <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
>
> if you know all fielda (structure) and provide values
> insert into audit_trail values(...)
>
>
>


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