Subject Odp: [IBO] TIB_SearchPanel and searching problem and another...
Author Yagi
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/
>
>
>