I don't know those values.
Not sure now how they are inserted, audit_id will be via a generator.

RBS

On Wed, Nov 16, 2011 at 9:15 AM, Thomas Steinmaurer <ts@...>wrote:

> **
>
>
> > Actually, I suppose I could do:
> >
> > CREATE TRIGGER EXTENDED_TEXT_DEL FOR EXTENDED_TEXT
> > ACTIVE BEFORE DELETE
> > POSITION 10
> > AS
> > begin
> > insert into audit_trail
> > values (null, null, null, 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, null
> > );
> > END
> >
> > replacing the missing fields with null.
> > Should that work?
>
> Why not providing real values if you know them instead of null?
>
>
> --
> With regards,
> Thomas Steinmaurer
>
> * Upscene Productions - Database Tools for Developers
> http://www.upscene.com/
>
> * My Blog
> http://blog.upscene.com/thomas/index.php
>
> * Firebird Foundation Committee Member
> http://www.firebirdsql.org/en/firebird-foundation/
>
>
>


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