drop-down combo box-like functionality for queries.

Posted by Frank Developer on Stack Overflow See other posts from Stack Overflow or by Frank Developer
Published on 2010-04-17T13:37:06Z Indexed on 2010/04/17 13:43 UTC
Read the original article Hit count: 196

Filed under:
|
|

Is it possible to provide the following type of fuctionality with informix client tools?

As the user types the first two characters of a name, the drop-down list is empty. At the third character, the list fills with just the names beginning with those three characters. At the fourth character, MS-Access completes the first matching name (assuming the combo's AutoExpand is on). Once enough characters are typed to identify the customer, the user tabs to the next field.

The time taken to load the combo between keystrokes is minimal. This occurs once only for each entry, unless the user backspaces through the first three characters again.

If your list still contains too many records, you can reduce them by another order of magnitude by changing the value of constant conSuburbMin from 3 to 4.

© Stack Overflow or respective owner

Related posts about informix

Related posts about Oracle