B4J Question Searchbox - which one woulkd you use?

udg

Expert
Licensed User
Longtime User
Hi all,

I should implement a list (aboit 1200 items) bound to a searchbox to ease the retrieval of items by means of an incremental search.
Luckily, B4X offers many alternatives. I wish to hear from you prior to take a decision since there are good chances you were confronted with a very similar (if not identical problem).

The list is made up of ingredientes for a recipe. So I need to select one after the other all the ingredients for a specific recipe. The resulting recipe will be stored in a separate list, complete with quantities and other data.

B4xSearchTemplate
This was my first thought, but it works trough a dialog so each selection makes the dialog close.
One way to adapt it to my needs could be to derive a new template where I "intercept" the selection step to pass the info to the recipe list and close the dialog only when finished with all the selections

Table
Using one of the two most recent flavours of B4X tables would let me serach for an item, do a multiselection, etc

Input box + DB search
Since ingredients data are stored in a sqlite table, another option could be to read the New parameter for event, then make a SELECT and show the results in a list below the input box
This could be optimized skipping the searching if less than x chars are available in the input box

Did I forget other alternatives? What did you use and how good was performance? I'd like to make this step very quick and easy.

Thank you
 

MicroDrie

Well-Known Member
Licensed User
Longtime User
I modified just a little SearchView to use it easily with DBs (mad name: DBSearchView ?).

You could do the same or... I can send it to you.
Coud you be so kind to sent me also a copy of the DBSearchView? ☺
 
Upvote 0
Top