Tim,

I have 2 Before Insert Triggers defined on a table.  One should be disabled and the other enabled.

Firstly, when a row is inserted for the trigger, the disabled trigger is fired.

Secondly, if I click the Disable / Enable Trigger link in the Task panel, the enabled status is changed in the Details panel, but the Enabled status is not changed in the Details view.  Pressing F5 does not refresh the display - it disables the trigger.

Richard Harding

Richard,

<< I have 2 Before Insert Triggers defined on a table.  One should be
disabled and the other enabled.

Firstly, when a row is inserted for the trigger, the disabled trigger is
fired.

Secondly, if I click the Disable / Enable Trigger link in the Task panel,
the enabled status is changed in the Details panel, but the Enabled status
is not changed in the Details view.  Pressing F5 does not refresh the
display - it disables the trigger. >>

I think you're simply seeing a mismatch between the display/information
schema table and the actual status of the trigger.  I'll check out what is
going on and make sure that it's corrected.

--
Tim Young
Elevate Software
www.elevatesoft.com