Subject incremental search on multiple column sort
Author Rick Roen
Delphi D7
IB_LookupList populated by an IB_Query

I am unable to search properly when I sort on multiple columns...

The SQL is:

SELECT ITEMNUM
, ITEMNAME
, PRICE
, NON_SEED_ITEM
FROM ITEMS

The Ordering Items information is:

ITEMNAME=NON_SEED_ITEM,ITEMNAME

The Ordering Links is:

ITEMNAME=ITEM=1

My result rows are something like this:

123 Basil 0
456 Tomato 0
789 Watermelon 0
012 Pallet 1
013 Bag 1

This puts all the "Non-Seed" items at the bottom of the list.

When I do an incremental search in the Listbox, it works fine for
all items with a "NON_SEED_ITEM" = 0, but I get nothing on the items
for "NON_SEED_ITEM" = 1.

Is there any way to tell the search to ONLY look in ITEMNAME field?

TIA,

Rick