Hi,

I create empty triggers/procedures too :)

Often I'm just commenting stuff out and would like to have an empty one, but
this isn't possible... Afterwards, just un-commenting stuff and testing
again...



Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com



----------------
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


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]