Subject Re: [IBO] Re: IB_Grid SearchKeyByKey
Author Helen Borrie
At 11:02 PM 18/11/2007, you wrote:
>--- In, "Alan McDonald" <alan@...> wrote:
>> Have you set the searchinglinks property in the query?
>> Alan
> Thanks for the responce Alan.
>I hadn't, but have just tried entering various things but that didn't
>work. My table name is Disc & the column name is Tag_No, what should I
>enter in the querySearchingLinks StringList

You need to line up 3 ducks, not one. :-)

1. Set an OrderingItems entry for the column Tag_No, e.g.,
<another ordering item>

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

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:

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.