Android Question SearchView For SQL?

[ronovar]

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?

 

[DonManfred]

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...

You need to build the functionality by yourself.

 

[ronovar]

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:

'SET - Type
    InputDialog1.InputType = InputDialog1.INPUT_TYPE_PHONE           
    'SETTINGS - InputDialog
    InputDialog1.Input = ""
    InputDialog1.HintColor = Colors.ARGB(196, 255, 140, 0)
    ParentReturn = DialogResponse.POSITIVE
   
    'SHOW - InputDialog1
    ParentReturn = InputDialog1.Show(CRLF&"Search:", "SearchBOX", "OK", "Cancel", "", LoadBitmapSample(File.DirAssets, "logo.png", 36, 36))

 

[DonManfred]

you get the result from inputdialog when you close it. I dont think this is the way you want to go. Not comfortable

 

[ronovar]

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?

 

[DonManfred]

use the ime library

 

[ronovar]

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?

 

[DonManfred]

check the keyevent and hide the edittext when user presses back button
Search the forum

 

[ronovar]

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.

 

[DonManfred]

Can you please write here example of event?

You are REALLY LAZY, right? USE THE FORUM SEARCH. There are HUNDRETS of similar issues.

http://www.b4x.com/android/help/views.html#activity

For me you´ve lost. Dont exprect to get more help from me.