Claudio,

I switched (back) to isql and everything works OK. That is the triggers are
all active (despite what IBConsole tells me) and I can insert a record using
isql. (When I insert the record the trigger fires and my primary key is
filled.)

When I try to append a record using IBConsole (leaving the primary key
null/blank) I cannot do so. I guess the trigger really *is* inactive as far
as IBConsole is concerned. (I suspect this knowledge is covered somewhere
so sorry for the time wasting).

Now back to the application which uses this database...

Thanks,
Carl

From: Claudio Valderrama C. <cvalde@...>
To: <IBDI@egroups.com>
Sent: Thursday, June 22, 2000 8:16 PM
Subject: RE: [IBDI] (In)active Triggers

> If you are using IBConsole, then you should know that it uses to report

all

> triggers as inactive under not very clear circumstances.
> Use isql.exe to check the REAL state of your triggers... otherwise,

chances

> are you are watching wrong info.