Hi,

At April 22, 2003, 16:11, Lucas Franzen wrote:

> Daniel,

> Daniel Rail schrieb:


> [snip]

>>
>> When reading the query that is automatically generated by IBO:
>> SELECT First NAME PARENTS.FAMILY_ID
>> FROM PARENTS
>> WHERE PARENTS.FAMILY_ID=?
>>
>> I can see why the error occurs. What I'm finding odd, is that there
>> is no field called NAME in that table, or any table in the database.
>> I do have fields containing NAME in them(PG1_FIRSTNAME, PG1_LASTNAME,
>> PG2_FIRSTNAME and PG2_LASTNAME), and those fields do have display and
>> grid labels(i.e. "Parent/Guardian No.1 - First Name").
>>
>> Is there an explanation why the above query might be generated as it
>> is?

> What about the OrderingItems - how are they defined?

I know what you're thinking, I've encountered the same problem before
when using display labels in the Ordering Items. Thanks for reminding
me that I forgot something in my message. Any ideas are welcomed.

Ordering Items:
PG1_FIRSTNAME=PG1_FIRSTNAME;PG1_FIRSTNAME DESC
PG1_LASTNAME=PG1_LASTNAME;PG1_LASTNAME DESC
PG1_HOME_PHONE=PG1_HOME_PHONE;PG1_HOME_PHONE DESC
PG2_FIRSTNAME=PG2_FIRSTNAME;PG2_FIRSTNAME DESC
PG2_LASTNAME=PG2_LASTNAME;PG2_LASTNAME DESC
PG2_HOME_PHONE=PG2_HOME_PHONE;PG2_HOME_PHONE DESC
FAMILY_ID=FAMILY_ID;FAMILY_ID DESC

Ordering Links:
PG1_FIRSTNAME=ITEM=1;POS=0
PG1_LASTNAME=ITEM=2;POS=0
PG1_HOME_PHONE=ITEM=3;POS=0
PG2_FIRSTNAME=ITEM=4;POS=0
PG2_LASTNAME=ITEM=5;POS=0
PG2_HOME_PHONE=ITEM=6;POS=0
FAMILY_ID=ITEM=7;POS=0

Search Links:
PG1_FIRSTNAME=PG1_FIRSTNAME
PG1_LASTNAME=PG1_LASTNAME
PG1_HOME_PHONE=PG1_HOME_PHONE
PG2_FIRSTNAME=PG2_FIRSTNAME
PG2_LASTNAME=PG2_LASTNAME
PG2_HOME_PHONE=PG2_HOME_PHONE
FAMILY_ID=FAMILY_ID

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)