Subject Re: [IBO] incremental search on multiple column sort
Author Helen Borrie
At 02:38 PM 5/12/2004 +0000, you wrote:


>Thanks Helen,
>
>That does clarify some information about how to setup the ordering
>information in the query, however I still do not have results like
>what I expect.
>
>Regardless of how I order the result set, I cannot "find" anything
>with a NON_SEED_ITEM = 1.
>
>I have this for the OrderingItems now:
>
>ITEMNAME=NON_SEED_ITEM,ITEMNAME;NON_SEED_ITEM DESC,ITEMNAME
>
>with OrderingItemNo=-1 the NON_SEED_ITEMS are sorted first like I
>expect, but in the IB_LISTBOX the row never moves when I type in
>search. Using my results from below for example: when I type
>in "Ba" nothing is found. I expect the row would move to "Bag".
>
>When I use OrderingItemNo=1, the results are again sorted like I
>expect AND I can find "Tom" for Tomato, but I can find nothing when
>I type in "Bag".
>
>Do I need to set something that tells the control that I ONLY want
>to search in the ITEMNAME field for the incremental search.
>
>I've set the search to be case insensitive, so that's not an issue.

You would need THIS:
>
> NAMEONLY=ITEMNAME;ITEMNAME DESC
>
> and OrderingLinks to:
> NAMEONLY=ITEM=2 (or -2, if you want the default to be descending).
>
and the lookuplist SearchKeyByKey property set true.

Helen