Subject Re: [IBO] Generator not defined mystery
Author Helen Borrie
At 01:34 PM 10/02/2008, you wrote:


>AS
>BEGIN
> IF (NEW.NOTEID IS NULL) THEN
> NEW.NOTEID = GEN_ID(GEN_NOTEID, 1);
>END
>
>For this TABLE, I use an IBODatabase with an IBOTable to insert a new
>record, and the GeneratorLinks is defined as NOTEID=NOTEID_GEN.
>
>In the previous/currently working version of this setup, there are no
>problems, but now with the updated GUI, and the same - as far as I can
>see - IBO/Firebird script and properties, I'm getting the following error:
>
>invalid request BLR at offset 70
>generator NOTEID_GEN is not defined
>
>But I think it's defined, as far as I can understand, just the same as
>it is in the version that works.
>
>If there is something obvious which I've forgotten or misunderstood -
>which I hope is the reason - I'd be grateful for any help.

Well, the obvious first thing is to work out whether the generator's name is NOTEID_GEN or GEN_NOTEID.

Helen