Never mind, altering triggers work with Flame Robin. The issue must be with Database Workbench.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rick Debay Sent: Tuesday, December 11, 2012 12:25 PM To: [email protected] Subject: [firebird-support] RE: FB 2.5.2 trigger doesn't fire Creating a new test table with triggers, the trigger fires. Adding triggers to existing tables (restored from 1.5.6), nothing fires. Perhaps I need to backup using the 2.5.2 gbak??? -----Original Message----- From: Rick Debay Sent: Tuesday, December 11, 2012 12:01 PM To: [email protected] Subject: FB 2.5.2 trigger doesn't fire CREATE EXCEPTION E ''; CREATE TRIGGER T_TEST_BEFORE FOR T ACTIVE BEFORE INSERT POSITION 0 AS begin EXCEPTION E 'TEST BEFORE'; End CREATE TRIGGER T_TEST_AFTER FOR T ACTIVE AFTER INSERT POSITION 0 AS begin EXCEPTION E 'TEST AFTER'; End Inserting into the table T does not throw an exception. The database was restored from a backup from a 1.5.6 database. ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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
