Android Question Have NULL as first element of an spinner loaded with SQL

FERNANDO SILVEIRA said:

1st spinner element as NULL (or space) and give the chance the user to pick

Click to expand...

Dim spn As Spinner
    Dim txt As String
    Dim cursor1 As Cursor
    spn.Add(" ")  '1st spinner record
    txt="SELECT COUNTRY FROM mytable ORDER BY COUNTRY"
    cursor1=SQL1.ExecQuery(txt)
    For i=0 To cursor1.RowCount-1
        cursor1.Position=i
        spn.Add(cursor1.GetString("COUNTRY") )
    Next
    cursor1.close

Mahares said:

In this case add the first element of the spinner as a space, followed by the cursor resultset to continue to populate the spinner.

B4X:

Dim spn As Spinner
    Dim txt As String
    Dim cursor1 As Cursor
    spn.Add(" ")  '1st spinner record
    txt="SELECT COUNTRY FROM mytable ORDER BY COUNTRY"
    cursor1=SQL1.ExecQuery(txt)
    For i=0 To cursor1.RowCount-1
        cursor1.Position=i
        spn.Add(cursor1.GetString("COUNTRY") )
    Next
    cursor1.close

Click to expand...

'Executes the query and fills the Spinner with the values in the first column
Sub ExecuteSpinner(SQL As SQL, Query As String, StringArgs() As String, Limit As Int, Spinner1 As Spinner, firstNull As Boolean)
    Spinner1.Clear
    If firstNull Then Spinner1.Add(" ")    ' <== Fernando Silveira: Leave 1st element EMPTY
    Dim Table As List
    Table = ExecuteMemoryTable(SQL, Query, StringArgs, Limit)
    Dim Cols() As String
    For i = 0 To Table.Size - 1
        Cols = Table.Get(i)
        Spinner1.Add(Cols(0))
    Next
End Sub