At 11:27 PM 9/09/2004 +0000, you wrote:

>I am trying to use a generator through a trigger but it returns me the
>following mistake:
>" Cannot commit transaction:
>Invalid token.
>invalid request BLR at offset 25.
>generator gen_id_mygen is not defined ".
>
>I already got to reinstall Firebird 1.5, but of anything it is fast...
>
>Can anybody help myself?

Before you try to prepare the trigger, create the generator:

CREATE GENERATOR GEN_ID_MYGEN;
COMMIT;

Note that, if you are using a tool that enforces double-quotes (not nice!!)
then the names of your objects will (1) be case-sensitive and (2) require
the double-quotes whenever you refer to them.

So, if you do
CREATE GENERATOR "GEN_ID_MYGEN";

then the generator's name is "GEN_ID_M7GEN" and NOT "gen_id_mygen".

./heLen

>