Carl,

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

probably IBConsole does not let you insert the record because it is
missing a not nullable field (the auto-incrementing one), so the trigger
doesn't even get the chance to fire because the insert statement is not
leaving the client.
Just a thought...
--
____
_/\/ando