| Subject | Re: [firebird-support] When do triggers take effect? |
|---|---|
| Author | Nick Upson |
| Post date | 2016-06-06T15:41:17Z |
you need to commit the trigger creation / modification & then have any other relevant transaction commit
Nick Upson,
Principal Operations Engineer, Telensa Ltd.
Direct
+44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
On 6 June 2016 at 15:59, Tim Ward tdw@... [firebird-support] <firebird-support@yahoogroups.com> wrote:Using Database Workbench I added a trigger to a table, but it didn't
seen to do anything (in particular didn't throw an exception which it
should have done when I deliberately created an invalid record).
After restarting DBWB the trigger behaved as expected.
Do triggers not take effect on existing connections, or something?
--
Tim Ward