Never mind, altering triggers work with Flame Robin. The issue must be
with Database Workbench.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Tuesday, December 11, 2012 12:25 PM
To: firebird-support@yahoogroups.com
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: firebird-support@yahoogroups.com
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