Subject | SearchPanel Problem with Same Field Name |
---|---|
Author | Jeff Clement |
Post date | 2001-05-28T12:08:12Z |
Hi there,
I have a problem with the SearchPanel in IBO which concerns
having two field names with the same name, but from different
tables using a join.
ie.
SELECT table1.code, table2.code
FROM table1
LEFT OUTER JOIN table2 ON table1.id = table2.id
The SearchPanel displays the two field labels correctly, but the two
edit boxes would be both related to table1.code.
I would have rathered use aliases in my select statement but I get
an error when I try to post my search. So instead I tried using the
full field name (as above) and I have the problem with the edit
boxes in the SearchPanel both relating to the first field which share
the same field name, but the field labels which I configured to
display different names display correctly.
Can anyone offer any suggestions? Am I going about my problem
the wrong way?
I hope soneone can help.
Thanks,
Jeff.
I have a problem with the SearchPanel in IBO which concerns
having two field names with the same name, but from different
tables using a join.
ie.
SELECT table1.code, table2.code
FROM table1
LEFT OUTER JOIN table2 ON table1.id = table2.id
The SearchPanel displays the two field labels correctly, but the two
edit boxes would be both related to table1.code.
I would have rathered use aliases in my select statement but I get
an error when I try to post my search. So instead I tried using the
full field name (as above) and I have the problem with the edit
boxes in the SearchPanel both relating to the first field which share
the same field name, but the field labels which I configured to
display different names display correctly.
Can anyone offer any suggestions? Am I going about my problem
the wrong way?
I hope soneone can help.
Thanks,
Jeff.