B4J Question ComboBox or ChoiceBox add items from query result

[phangs]

Hello, I know this might be simple for others, but please I could not get it to work.

I am trying both combo and choice boxes but I could not make it work as I want. I the query result in variable rs (contains id and name), I can place the rs as list items either the id or the name but not both. I want to place the id and name in the combobox or choicebox so that when the selected index change is triggered, I can store the record's real id instead of the combobox or choicebox's id. I am trying to make additional methods to handle finding the record again when retrieving form it's table.

basically i want the combobox or choicebox to use the record's real id instead of the combobox or choicebox's id.

thanks in advance

 

[Sergio Haurat]

This is a question we all ask ourselves when coming to B4X with combos, especially waiting for a .net SelectedValue that doesn't exist. There are some alternatives to the standard ComboBox, you should use

[B4X] [XUI] SD_xComboBox

At the request of my friend @Mashiane , I created a combobox that has the graphics of my IconTextView that is Multiplatform (B4X, B4J, B4i) NOTE: You can use this library for personal and commercial use. Include it in your projects.. Attention, even if it is a B4XLib library, it is not allowed...

www.b4x.com

The development is by @Star-Dust, he is a trusted member in the operation of his libraries.

 

[walt61]

A couple of alternatives:

1. https://www.b4x.com/android/forum/threads/b4x-lmb4xcombobox.116767/#post-729765 created by @LucaMs to handle exactly what you want to do.

2. The DIY option: while populating the combobox/choicebox items with the text values, also populate a list with the ID values. When a text is clicked, use its index to fetch the appropriate ID from the list.

 

[phangs]

thank you very much for your replies. I will try your suggestions.

 

[Sergio Haurat]

created by @LucaMs

Another user who is a big contributor to the solutions.