Hi Jason,

Maybe i'm missing something. I try to put it in another way.

1. First problem/error (but not a big one) is with FiledsXXX properties in
the query properites editor and query with the same filed names from
different tables for example

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)

The query properties editor for FieldsXXX properties use only the filed name
without table name prefix. So for FieldsDisplayLabel i got only NUMER=Numer
wich reflects the last modification of this properties for STANOWISKA.NUMER
or KARNETY.NUMER or KLIENCI.NUMER.
But when I manually put in
STANOWISKA.NUMER=Nr stanowiska
KARNETY.NUMER=Nr karnetu
KLIENCI.NUMER=Nr klienta
into FieldsDisplayLabel everything starting to work OK.
It is not a big problem for me and I only wander if this works the right
way.
You can also say to use aliases using fields with the same name, but there
is an another problem with using IB_SearchPanel.

Let's put more light on this. I set FieldsDisplayLabel for
STANOWISKA.NUMER=Nr stanowiska
KARNETY.NUMER=Nr karnetu
KLIENCI.NUMER=Nr klienta

I activate IB_searchPanel from TIB_SearchBar (like in your query properties
editor). I get three fields to search for on the panel
Nr stanowiska ___________
Nr karnetu ___________
Nr klienta ___________

and the bug is that all this fields are for STANOWISKA.NUMBER. So if i try
to search for 'Nr karnetu' or 'Nr klienta' and run the srearch criteria the
query is always:

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 = .......
^^^^^^^^^^^^^^^^^^^^^^^
(searching is always for STANOWISKA.NUMER)

If I set FieldsReadOnly for STANOWISKA.NUMER=NOSEARCH then all three fileds
in IB_searchPanel are readonly

Jason, I hope that my problem is now more clearer. What do you think about
it?

Yagi

----- Original Message -----
From: Jason Wharton <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, May 18, 2001 8:24 PM
Subject: Re: [IBO] Re: TIB_SearchPanel and searching problem and another...


> IBO should work either way.
> I'm not seeing what your problem is. Is it because I am using the
AliasName
> instead of the SQLName (meaning the actual name of the column instead of
the
> alias name you gave it).
>
> I wish InterBase would accept that alias name because this would make it
> work even if you were using self joins.
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com