I'm in need of a custom DBLookupComboBox for Delphi with search / Filter options. The original DBLookupComboBox that comes with Delphi Does not full fill my needs for searching and filtering. Key functionality is:
1. Behave like an original DBLookupComboBox (i.e show data when in Browse mode, etc.)
2. Once the user enters the combobox, either let the user drop it down and select an item, or let the user start writing some text in the combobox. (The input text has to be shown in the text area of the DBLookupComboBox). The drop down will then filter and show only items that matches the text that the user writes.
3. Non case sensitive filter / search
3. Allow partial match in any word in the list. Example if one item is "Donald Trump", then show that item if the user inputs "rump"
4. Show no items if the search the user inputs does not exists.
5. If the user inputs a text that does not exist in the list source, then fire an event when the user exits the control with the search / filter input as a parameter. Let's call this event "OnEmptyResult". This is so I can then insert the search / filter term as a new record in the list source, refresh it and select it in the combobox.
6. if the user inputs a search term that gives 3 results, let the user use the up / down key to navigate them and hit Enter to select it and close the combobox. At the same time, do not take focus away from the search area as the user can input more characters.
7. If the search results gives no hits and the user hits Enter, fire the "OnEmptyResult" event
Hi, I am interested in your project.
You need component inherit from DBLookupComboBox.
I can do that
I use Delphi & SQL for Account, CRM, ERP task form 1996 year.
I have exp on ERP & Account system include 1c: ERP and more.
I am a full time programmer with 20 year exp in Russia.
I have hi degree in information system in economics.
$198 USD in 7 days
4.8 (7 reviews)
3.1
3.1
11 freelancers are bidding on average $199 USD for this job
Hi, I am Delphi expert with more than 15 years of experience in various areas including development of new data aware components or adjustment to existing components. About your point 2) should control do something (for example auto show dropdown box) or user will do everything himself?
Hi,
I'm high rated Delphi coder.
I've high experience in developing DB applications.
Also I cn do your project in RAD Studion 10.1 Berlin.
Thanks, Andriy
Hello,
I wrote own TDBLookupCombo. My component has few thing what You need but few I must add.
It has build dataset base on IBQuery but I can change it.
If You want I can prepare some demo for You with some small database to show how this componets work.
in fact I have two components works like LookupCompo, first for small list [< 1000, 5000] and second form big data like 1 000 000 records.
Please, feel free to contact with me.
PS. This components was write in Delphi 2006 but it works in XE8 too.
I have more than 15 years expirience of Delphi Developer. I started with Delphi 5 and working with XE10.1 now.
Also I have expirience in WIndows API, Network API, Oracle Database (from 8i to 12c),
Oracle backup/restore, Oracle Import/Export (imp/exp and impdp/expdp),
Oracle SQL, T-SQL. Develop Multi-threaded application without any memory/resource leaks.
Also I have some experience in C++ and C# programming languages.