Subject | TIB_LookupCombo search buffering? |
---|---|
Author | Tim Meneely |
Post date | 2003-07-02T13:56:46Z |
<Sorry, long - feel free to skip down to THE QUESTION>
Greetings,
After doing several applications successfully using iboTDataset, I'm working
on porting one to the native IBO components.
I've got a grid where the user is entering contributions, using
TIB_LookupCombo's embedded in the grid for the donor's name, what the
contribution is for, etc. A grid is the best format; the query has a where
clause to limit display to the current batch of stuff being entered.
The (current <grin>) problem is, donors can be identified either by name or by
company. The table has fields "fname, lname, company" where from one to
three can be filled in. The way I've handled this before is with a single
lookup table (essentially "select id, lname || fname as name, company from
people") and two grid-embedded lookup combos; the user clicks on whichever
grid column is appropriate, and the other goes along for the ride. It's a
slightly odd user interface, but it works.
<THE QUESTION>
I've now done this with a single TIB_Query and two TIB_LookupCombo's. The
OnEnter event of each combo sets the appropriate OrderingItem, to search for
either lname or company. It all works great, except: If the user starts
typing in the lname grid column first and then realizes he wants to pick by
company and moves to the company grid column, the previously typed stuff
isn't cleared and it screws up the company search.
Thus, say I'm entering a check from John Smith, ACME Inc. I start typing
"smi" in lname. I then realize the company is under the company name, and
tab to the company column and type "a". What comes up in the search field is
"smia". I have to hit backspace four times, and then retype "a".
Is there any way to clear this typing buffer?
Thanks - sorry for all the background; I tend toward verbosity.
Tim Meneely
Pittsburgh PA USA
Greetings,
After doing several applications successfully using iboTDataset, I'm working
on porting one to the native IBO components.
I've got a grid where the user is entering contributions, using
TIB_LookupCombo's embedded in the grid for the donor's name, what the
contribution is for, etc. A grid is the best format; the query has a where
clause to limit display to the current batch of stuff being entered.
The (current <grin>) problem is, donors can be identified either by name or by
company. The table has fields "fname, lname, company" where from one to
three can be filled in. The way I've handled this before is with a single
lookup table (essentially "select id, lname || fname as name, company from
people") and two grid-embedded lookup combos; the user clicks on whichever
grid column is appropriate, and the other goes along for the ride. It's a
slightly odd user interface, but it works.
<THE QUESTION>
I've now done this with a single TIB_Query and two TIB_LookupCombo's. The
OnEnter event of each combo sets the appropriate OrderingItem, to search for
either lname or company. It all works great, except: If the user starts
typing in the lname grid column first and then realizes he wants to pick by
company and moves to the company grid column, the previously typed stuff
isn't cleared and it screws up the company search.
Thus, say I'm entering a check from John Smith, ACME Inc. I start typing
"smi" in lname. I then realize the company is under the company name, and
tab to the company column and type "a". What comes up in the search field is
"smia". I have to hit backspace four times, and then retype "a".
Is there any way to clear this typing buffer?
Thanks - sorry for all the background; I tend toward verbosity.
Tim Meneely
Pittsburgh PA USA