This should work: CREATE TRIGGER EXTENDED_TEXT_ADD FOR EXTENDED_TEXT ACTIVE BEFORE INSERT POSITION 10 AS begin insert into audit_trail values (null, null, null, 45, 0, new.Extended_Text_Type||"|"|| new.Foreign_Id||"|"|| new.Extended_Text_Sequence_No, null, null ); END
But sofar not managed to do it via Database WB. If I do this with the trigger editor I can't set the trigger name to EXTENDED_TEXT_ADD and if I do with the SQL editor and run the statement as above I get: unsuccessful metadata update DEFINE TRIGGER failed attempt to store duplicate value (visible to active transactions) in unique index RDB$INDEX_8. Trigger editor allows me to create the trigger, but the trigger name then will be EXTENDED_TEXT_ How to set the trigger name? Any suggestions? RBS On Wed, Nov 16, 2011 at 9:27 AM, Bart Smissaert <[email protected]>wrote: > 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/
