Android Question Adding Values Extracted from Sqlite Database to Autocomplete Edit Box

[Rajesh Gupta]

I want to show the drop down list of autocomplete with the values extracted from DB, but there is an error when i am adding it to autocomplete.

My code:-

Sub ShowList

Dim SQL1 As SQL
Dim tblMasters As Cursor
Private ddlaccname As AutoCompleteEditText
Dim List1 As List
List1.Initialize
SQL1.Initialize(File.DirInternal, "Masters.db", True)

Dim q As String="Select * From tblMasters WHERE MType=2"
tblMasters=SQL1.ExecQuery(q)

ddlaccname.SetItems(tblMasters)

End Sub

Please Suggest some idea about the same.

 

[LucaMs]

SetItems requires a List and you are passing a SQL cursor!

You have to read the data, ONE FIELD, using the cursor and put them in a List.

    Dim Cursor As Cursor
Dim lstData As List
lstData.Initialize
Dim q As String="Select * From tblMasters WHERE MType=2"
Cursor = SQL1.ExecQuery(q)
For i = 0 To Cursor.RowCount - 1
    Cursor.Position = i
    lstData.Add(Cursor.GetString("ChooseAFieldName"))
Next
ddlaccname.SetItems(lstData)

 

[Erel]

Tip: prefer to use ResultSet over Cursor. It is a bit simpler to use and it is cross platform:

Dim rs As ResultSet = SQL1.ExecQuery(q)
Do While rs.NextRow
lstData.Add(rs.GetString("ChooseAFieldName"))
Loop
rs.Close

 

[Rajesh Gupta]

Thanks to All..

 

[Mahares]

Do While rs.Next

I thought this is supposed to be:

Do While rs.NextRow

You also show it in the intellisense when you type it in the IDE:

I use SQL 1.50

 

[Rajesh Gupta]

I thought this is supposed to be:

Do While rs.NextRow

You also show it in the intellisense when you type it in the IDE:

I use SQL 1.50

Okay..

 

[LucaMs]

I thought this

... was for b4j only

 

[Erel]

I thought this is supposed to be:

That's true. Fixed the code example.