Hi Jason,

A few days ago i posted the following message and got no answer. Could you
please tell me something about this?

Yagi

----- Original Message -----
From: Yagi <yagi@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, May 18, 2001 10:23 PM
Subject: Odp: [IBO] Re: TIB_SearchPanel and searching problem and another...


> 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
>
>