Subject | IBOTable complains about generator for another table |
---|---|
Author | ifitsx |
Post date | 2008-02-10T19:09:03Z |
First, Thanks to Helen for your reply about the "Generator not defined
mystery." At some point in my app's evolution I forgot that I reversed
my generator naming convention to what seemed the more usual form.
I'm evolving an app. The initial misnamed generators - NOTEID_GEN
renamed to GEN_NOTEID and FOLDERID_GEN to GEN_FOLDERID - have all been
corrected as far as I can find.
I'm using D7 and IBO 4.2d, with an IBODatabase, an IBOTable, and
IBOQuerys.
I now get an error with the IBOTable.Insert, whose key is NOTEID and
whose generator is GEN_NOTEID, complaining:
invalid request BLR at offset 70
generator FOLDERID_GEN is not defined
The IBOQuerys which generated new folder records have all had there
GeneratorLinks corrected to GEN_FOLDERID.
My Table definitions are as follows:
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 )
FOLDERSNOTES:
FOLDERID INTEGER NOT NULL
, TEMPLATEID INTEGER
, FOLDERCAPTION VARCHAR( 120 ) NOT NULL
, CONSTRAINT INTEG_7
UNIQUE ( FOLDERCAPTION )
, CONSTRAINT INTEG_5
PRIMARY KEY ( FOLDERID )
My IBOTable whose TABLE is DBNOTES and which is calling
IBOTable.Insert has no Master relations of any kind, at least none
that I have intentionally constructed, and I can not find any
properties in any components which now list "FOLDERID_GEN".
How can I begin to find where this "FOLDERID_GEN" might exist which is
causing the complaint? Can Generator information - however misnamed or
otherwise - be found in some component field other than GeneratorLinks?
mystery." At some point in my app's evolution I forgot that I reversed
my generator naming convention to what seemed the more usual form.
I'm evolving an app. The initial misnamed generators - NOTEID_GEN
renamed to GEN_NOTEID and FOLDERID_GEN to GEN_FOLDERID - have all been
corrected as far as I can find.
I'm using D7 and IBO 4.2d, with an IBODatabase, an IBOTable, and
IBOQuerys.
I now get an error with the IBOTable.Insert, whose key is NOTEID and
whose generator is GEN_NOTEID, complaining:
invalid request BLR at offset 70
generator FOLDERID_GEN is not defined
The IBOQuerys which generated new folder records have all had there
GeneratorLinks corrected to GEN_FOLDERID.
My Table definitions are as follows:
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 )
FOLDERSNOTES:
FOLDERID INTEGER NOT NULL
, TEMPLATEID INTEGER
, FOLDERCAPTION VARCHAR( 120 ) NOT NULL
, CONSTRAINT INTEG_7
UNIQUE ( FOLDERCAPTION )
, CONSTRAINT INTEG_5
PRIMARY KEY ( FOLDERID )
My IBOTable whose TABLE is DBNOTES and which is calling
IBOTable.Insert has no Master relations of any kind, at least none
that I have intentionally constructed, and I can not find any
properties in any components which now list "FOLDERID_GEN".
How can I begin to find where this "FOLDERID_GEN" might exist which is
causing the complaint? Can Generator information - however misnamed or
otherwise - be found in some component field other than GeneratorLinks?