Android Question sqllite load all value into list

arsalan945

New Member
In sqllite how to load all column value into list

Example
id___Name___P.Code
1___Howard__24
2___Roberts__64
3___Jack______74
4___Edwards__64
5___Daniel___ 33

Output
Log(Name) 'All Name In Column

Howard
Roberts
Jack
Edwards
Daniel

Thanks.
 
Solution
Check DBUtils.ExecuteMemoryTable

Or:
B4X:
Dim rs As ResultSet = sql.ExecQuery("SELECT name FROM table1")
Do While rs.NextRow
 Log(rs.GetString("name"))
Next
rs.Close
Top