Subject Re: [firebird-support] Please help me! invalid request BLR at offset 25.?
Author Helen Borrie
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:


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

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