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 <[email protected]>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] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
