Solved

Typing help (autocompletion) in DBComboBox

Posted on 1998-07-05
6
199 Views
Last Modified: 2010-04-04
I have a database app. in which one of the fields is "author". When the user starts entering the author name I want to be able to give "typing help" (eg IE4 address bar). That is as they type the author name it will compare it to the items in the combobox and bring up the nearest match as they continue to type - autocompletion style.

Thanks

John
0
Comment
Question by:JohnE
6 Comments
 

Expert Comment

by:SOLHJOO
ID: 1357105
Please check DBlookupcombo or DBlookuplist....
0
 
LVL 3

Accepted Solution

by:
Matvey earned 200 total points
ID: 1357106
Freeware Edit and ComboBox components that work this way:

http://bes.trendline.co.il/torry/vcl/lbcb/lucombo.zip

Chreers, bosism@netvision.net.il
0
 
LVL 2

Expert Comment

by:kjteng
ID: 1357107
All the list box and combobox has the "autocompletion" feature if the list is sorted. However if you are using delphi 1, the autocompletion works only when the (16bits) program is running under windows95. When delphi 1 program runs under win3.11, the listbox/combobox works differently: if you continuously press a character, the next items beginning with that character will be selected. eg If you press B repeately, you may get Ball, followed by Bell, Bill, Bull ... etc.

0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 3

Expert Comment

by:Matvey
ID: 1357108
I think I've even seen some control like this as a db-aware. Lookup of some kind with this option. I'll try to find it again...
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1357109
OK, I found it, but it's not what I thought. Close, but not better than the one I posted above. If you still want to take a look: http://bes.trendline.co.il/torry/vcl/packs/accomp.zip

Anyway, what I'd do if I was on your place, is get the list of all the names like
SELECT DISTINCT Name FROM Authors;
And then post them all to the autocompletion list (in the first pair of components I posted).
0
 

Author Comment

by:JohnE
ID: 1357110
Thanks Matvey, I used the component from your first answer and worked my code around it and it works fine!

John
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This video discusses moving either the default database or any database to a new volume.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now