Subject RE: [IBO] Re: IB_Grid SearchKeyByKey
Author Alan McDonald
> --- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> >
> > You need to line up 3 ducks, not one. :-)
> >
> > 1. Set an OrderingItems entry for the column Tag_No, e.g.,
> <another
> > ordering item> ByTagNo=RelationOrAliasName.Tag_No
> >
> > So here, if ByTagNo (user-friendly name) is the second entry in
> OrderingItems, it is OrderingItem # 2 (we count OrderingItems from 1,
> not 0, just to be confusing!)
> >
> > 2. For when you want the Tag_No column to be the searched column,
> set the OrderingLinks to be
> > RelationOrAliasName.Tag_No=2
> >
> > 3. ...and set a SearchingLinks entry so that, when that column is
> the OrderingLink, the component will know which field its search
> parameter has to match up to:
> > RelationOrAliasName.Tag_No=:Tag_No
> >
> > I'm using "RelationOrAliasName" as a placeholder for the table
> qualifier - the relation name or the alias name, in case you've got a
> joined set. You'll need to use whichever one you used in the SELECT
> statement. Not needed for a single-table query.
> > As Alan advised, pull up the SearchingLinks example and see how
> it's done.
> >
> > Helen
> >
>
> Thanks Helen.
> I'm starting to make progress, but not quite getting there
> yet. Following your guide I can get the grid to search on
> Tag_No but not
> on the other 2 columns, Code & Name all 3 columns are in the Disc
> table.
> If I want to search on say Code what are the setting for the 3 ducks
> (I'm just entering directly into the StringList at the moment)I've
> tried various combinations but will only search on Tag_no.
> I notice that I must press enter after the number entered i.e the
> grid doesn't scroll to the 1st number entered, is this the way it
> works?
>
> Jack

For integer fields, that's correct, there's no incremental (doesn't make
sense), for string fields there is incremental, but you need to click the
column before you type.
I usually put the keyboard buffer on the status bar so users can see what
they're typing
Alan