Thanks, Ann! The "dummy table" scheme worked great!

-Joe

At 11:40 AM 3/13/2005, you wrote:

>Joe Martinez wrote:
> > A couple questions...
> >
> > 1) Is there a way to do an insert/update/delete and bypass a trigger
> > (prevent it from firing), other than deactivating the trigger?
>
>Ordinarily this is done with a logical test - for example, a particular
>user or role is used for inserts and the trigger tests for that
>user/role before firing. Alternately, you can store some value in a
>dummy table that the trigger tests before firing.
>
>Regards,
>
>
>Ann
> >
>
>
>
>
>Yahoo! Groups Links
>
>
>
>