For some reason I just cannot get my head into your problem here. I think
I'm just too focused in other areas at the moment.

You are not doing a self join so I don't get what your problem could be. use
the full field name and preface column names with their table name (not the
alias you used) and you should be fine.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Yagi" <yagi@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Friday, May 25, 2001 11:33 AM
Subject: [IBO] TIB_SearchPanel and searching problem and another...


> 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
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>