Subject | incremental search on multiple column sort |
---|---|
Author | Rick Roen |
Post date | 2004-12-04T21:35:51Z |
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
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