June 29, 2009

Disabling a Trigger

If you have a trigger and you want to quickly disable him, then just use the "_"-technique :



In this case we have a Key-Create-Record-Trigger which should be disabled. Rename the "-" to "_" in the name of the trigger and from that point on the trigger is a user-named-trigger, which won't fire through an event.



Important: You can't rename the trigger to "KEY-CREREC2" or something else. The hyphen is in forms reserved for event-triggers.

To activate the trigger rename it back to "-" and that's all.

Have fun
Gerd

3 comments:

  1. AnonymousJuly 14, 2009

    Nice idea, but probably a hard to find issue if you are working in an unknwon module and wondering why things don't work as wanted.

    ReplyDelete
  2. Gerd VolbergJuly 14, 2009

    This is only a very fast trick to disable a trigger, while developing or debugging. For testing purposes only.

    In a productive environment it is totally useless and counterproductive

    ReplyDelete
  3. JohnOctober 13, 2009

    Simple - yet effective. I also like to add a 'zz' prefix to make it more visual. eg. ZZKEY_CREREC

    ReplyDelete