I have apk that uses SQL database that is saved on android debice (database.db), and it uses to filter items by buttons (order by title, year....).
I would like to add searchView when user press RED button to show SearchView....and when user is typing letters it refresh listview with items that sql is found,
How is this possible with SearchView and SQL?
To be simple question: how can i use SearchView input to search SQL database on device and then refresh listview that is holding items from database correcsponding to SearchView input?
Use a edttext and a button (or textchanged event)
Do a database search when pressing the button and display the results in a listview.
There is no Searchview for sql in b4a...
Ok thanks..i got the idea...just more one question... can i use inputdialog (this is android dialog that i use for pin input) and when keyup is pressed in inputdialog to fire up sub that takes input string from inputdialog and then do sql query and clear and show items in listview...i think about this inputdialog:
Ok i successfully show edittext using visible = True but i need to press button OK on remote control to show softkeyboard...how can i do this automatically when i put EditText.Visible=True and EditText.RequestFocus to show automatically softkeyboard?
Great it now shows softkeyboard when i show edittext but when softkeyboard is show and i press on remote control back key it hides softkeyboard (which is what i need) and edittext is show, so i need to press one more time back button on remote control to hide edittext. How can i automatically hide edittext when softkeyboard is hiden when user press back key?
Can you please write here example of event? I could not hide edittext when softkeyboard is hidden..so i nee to press one more tme back button on remote control to hide edittext...i use IME to show softkeyboard and softkeyboard is automatically focused...on press back key i im focused back to textedit and textedit is not hidden.