Subject | [ibo] tIBOquery Issue |
---|---|
Author | Jack Cane |
Post date | 2002-12-29T16:17:39Z |
My form has three tIBOqueries linked to an FB dataset through a tIboDataBase
and three tDataSources. All three queries are set active and the
tDbNavigators show appropriage buttons enabled.
One tIBOquery, qPages, is targeted on table TARGETURL. The form has tdbEdit
fields connected to fields TARGETNR (the primary key field), TARGETNAME and
CONFIGNUM. The latter field is linked to another table via a foreign key
constraint. All the tdbEdits are linked properly to existing fields in the
table, TARGETURL. I can see them in the dropdown for the field name
property.
When I run the app., the form stumbles over the following query:
'select TargetName from TARGETURL where CONFIGNUM = 1 order by TargetName'.
The error is exception class EDatabaseError with message 'edTargetNr: Field
'TARGETNR' not found'.
I have deleted and rebuilt the tIBOquery, with identical results.
Any assistance appreciated.
jwc
and three tDataSources. All three queries are set active and the
tDbNavigators show appropriage buttons enabled.
One tIBOquery, qPages, is targeted on table TARGETURL. The form has tdbEdit
fields connected to fields TARGETNR (the primary key field), TARGETNAME and
CONFIGNUM. The latter field is linked to another table via a foreign key
constraint. All the tdbEdits are linked properly to existing fields in the
table, TARGETURL. I can see them in the dropdown for the field name
property.
When I run the app., the form stumbles over the following query:
'select TargetName from TARGETURL where CONFIGNUM = 1 order by TargetName'.
The error is exception class EDatabaseError with message 'edTargetNr: Field
'TARGETNR' not found'.
I have deleted and rebuilt the tIBOquery, with identical results.
Any assistance appreciated.
jwc