Hi,

I have some problem with filtering records using IB_SearchPanel

There is a query:

SELECT STANOWISKA.NUMER, KARNETY.NUMER, KLIENCI.NUMER
FROM SESJE
INNER JOIN STANOWISKA
ON(STANOWISKA.ID = SESJE.ID_STANOWISKA)
LEFT OUTER JOIN KLIENCI
ON(KLIENCI.ID = SESJE.ID_KLIENTA)
LEFT OUTER JOIN KARNETY
ON(KARNETY.ID = SESJE.ID_KARNETU)


Three tables has the same filed name (NUMER)
When i try to search dataset from IB_SearchPanel for KARNETY.NUMER = 6 or
KLIENCI.NUMER = 12 (example values) then the generated query is as follow:
SELECT STANOWISKA.NUMER, KARNETY.NUMER, KLIENCI.NUMER
FROM SESJE
INNER JOIN STANOWISKA
ON(STANOWISKA.ID = SESJE.ID_STANOWISKA)
LEFT OUTER JOIN KLIENCI
ON(KLIENCI.ID = SESJE.ID_KLIENTA)
LEFT OUTER JOIN KARNETY
ON(KARNETY.ID = SESJE.ID_KARNETU)
WHERE STANOWISKA.NUMER = 6

What's wrong?

There is also another issue with the same filed names trying to put
FieldProperties (Alignment, CharCase...... Visible). The property editor
does not recognize NUMER fileds to be from different tables. When I change
(for example) DisplayLabel for KARNETY.NUMER, STANOWISKA.NUMER,
KLIENCI.NUMER is also changed.
In FieldsProperties tabsheet of property editor, list of fileds from query
is with table name. Why in IB_StringList of DisplayLabel for example field
names are without table name like KARNETY.NUMER? When I typ in this fileds
(with table name) directly to IB_StringList every thing is ok.

Any help

Thanks,
Yagi