Re: [firebird-support] When do triggers take effect?

2016-06-09 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Tim Ward 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 t

Re: [firebird-support] When do triggers take effect?

2016-06-06 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello Tim, Tuesday, June 7, 2016, 2:59:03 AM, you 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

Re: [firebird-support] When do triggers take effect?

2016-06-06 Thread Nick Upson n...@telensa.com [firebird-support]
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 t...@telensa.com [firebird-support] <

[firebird-support] When do triggers take effect?

2016-06-06 Thread Tim Ward t...@telensa.com [firebird-support]
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 exist