Subject Generator not defined mystery
Author ifitsx
Every year or so I seem to encounter strange problems with my IBO
4.2Hd/D7/win2k/SP4.

Some errors are obviously due to coming back to programming with IBO
after some many months or even years away on my research, and
forgetting stuff.

Some, however, seem to me to be related to side effects somewhere in
the D7/IBO environment.

I have a D7/IBO app which I use in house to store and study documents.

I decided to update this app, so I saved my app.dpr/app.pas as a
newapp.dpr/newapp.pas in a new directory, and then proceeded to
redesign some of the interface.

These is one of my tables:

CREATE TABLE DBNOTES (
NOTEID INTEGER NOT NULL
, FOLDERID INTEGER NOT NULL
, SUBJECT VARCHAR( 120 )
, AUTHOR VARCHAR( 120 )
, KEYWORDS VARCHAR( 80 )
, NOTES BLOB( 65535, 1 )
, CREATEDATESTMP DATE
, CREATETIMESTMP TIME
, EDITDATESTMP DATE
, EDITTIMESTMP TIME
, CONSTRAINT INTEG_2
PRIMARY KEY ( NOTEID )

...and its generator:

GEN_NOTEID

...and it's trigger:

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.