Android Question Spinner item click

[RobRock92]

Sub Spinner1_ItemClick (Position As Int, Value As Object)
Dim m As Map
    m = dbutils.ExecuteMap(Main.SQL, "SELECT * FROM azienda WHERE id = ?", _
        Array As String(Value))
    If m.IsInitialized = False Then 'Null will return if there is no match
        ragioedit.Text = ""
        Else
        ragioedit.Text = m.Get("ragione")
        indiedit.Text = m.Get("indirizzo")
    proedit.Text = m.Get("provincia")
    capedit.Text = m.Get("cap")
    teledit.Text = m.Get("telefono")
    ivaedit.Text = m.Get("iva")
    locedit.Text = m.Get("localita")
    End If
end sub

with this code in the log says no records found but I tried to read the database with sqlite viewer B4a and records do exist!!!

 

[klaus]

You should check, in debug mode, the content of Value.

 

[RobRock92]

You should check, in debug mode, the content of Value.

klaus I'm sorry I did not understand how I can do

 

[klaus]

In debug mode you can:
- set a breakpoint in the routine, and check the content of Value either in the window at bottom or hovering with the mouse over the variable name.
- add this line Log(Value) and you'll see the the result in the Log tab.

 

[RobRock92]

In debug mode you can:
- set a breakpoint in the routine, and check the content of Value either in the window at bottom or hovering with the mouse over the variable name.
- add this line Log(Value) and you'll see the the result in the Log tab.

Now klaus i see the element that i clicked in the spinner on the log..and now?

 

[klaus]

Your error message says ... no records found ...
So you should check if Value contains a concrete ID value.

 

[RobRock92]

Ah great klaus...i found my error!! Thanks