Hi ! --- In [email protected], 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(...)
