Ok, I'll log this as a bug to look at. Feel free to go into the sources a do
some snooping around. If you can suggest a fix in the code I'd gladly
consider that too. Trustware is supposed to foster this type of
interaction...

Thanks for your patience.

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

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


> The problem is with IB_SearchPanel. If you will get more free time try to
> create statement with selecting two different tables with the same field
> names (maybe you've got some project with such tables) and do searching
with
> IB_SearchPanel for these fields.
> IB_SearchPanel always search for the first field even if you type some
> criteria into another field (with the same name but from another table).
>
> (as in my 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)
> )
>
> Regards
> Yagi
>
> ----- Original Message -----
> From: Jason Wharton <jwharton@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Friday, May 25, 2001 10:14 PM
> Subject: Re: [IBO] TIB_SearchPanel and searching problem and another...
>
>
> > 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/
> > >
> > >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>