Android Question sqllite load all value into list

A

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
Sort by date Sort by votes
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Transpose Row Data to list
Replies
1
Views
578
stevel05
  • Article
Android Tutorial [B4X][B4XPages] SQL + xCLV Example
Replies
3
Views
5K
TILogistic
  • Question
Android Question [Solved] B4XTable - How to load data from SQLite?
Replies
1
Views
2K
Erel
  • Question
Android Question Sqlite Append And Populate New Column
Replies
1
Views
1K
DonManfred
  • Question
Android Question Reading data from a SQL table....
Replies
4
Views
2K
David Elkington
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…