Subject Re: Do Nothing in triggers
Author iblogmanager
Roger,

in fact that your trigger shouldn't do anything, why not deactivate
the trigger?

Regards,
Thomas

--- In ib-support@y..., Roger Vellacott <rvellacott@p...> wrote:
> During development it is very useful to be able to create
procedures which
> do nothing by having only EXIT in the body of the procedure. I
would like
> to be able to do the same with triggers.
>
> EXIT is illegal and is obviously inappropriate. The shortest
command I have
> found is:-
>
> declare variable a integer;
> begin
> a = 1;
> end
>
> Is there a better way? If not, how about adding a DoNothing
command for use
> in triggers?
>
> Roger Vellacott