Ignore this. Have managed to create the triggers now and they are working fine.
RBS On Wed, Nov 16, 2011 at 2:20 PM, Bart Smissaert <[email protected]>wrote: > 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/
