That should work. Are you doing a commit after that?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <mikus@...>
To: <IBObjects@yahoogroups.com>
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