No I am not doing a commit.

Is that necessary?

Let me try that...

Augey

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> That should work. Are you doing a commit after that?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <mikus@d...>
> To: <IBObjects@y...>
> Sent: Friday, June 29, 2001 11:17 AM
> Subject: [IBO] Unable to disable trigger with IBO Script
>
>
> > I have a small SQL script to insert a bunch of things into a database
> > with a trigger that I use to keep a unique key for each value.
> > However, when I put that working script into IB_Script it works fine
> > but the trigger is never disabled (so the key has a funkey number from
> > the generator)
> >
> > Is there something I am missing?
> >
> > Heres the SQL I am using to disable the trigger:
> >
> > alter trigger TRIG_DIAGNOSIS_CATS_BI inactive;
> >
> > Thanks,
> >
> > Augey Mikus