Erel B4X founder Staff member Licensed User Longtime User Jul 3, 2019 #2 Worth posting a link to the relevant thread: https://www.b4x.com/android/forum/threads/102364 B4X: Sub Button1_Click Dim res As ResultSet = B4XTable1.sql1.ExecQuery("SELECT rowid FROM data") Do While res.NextRow SelectedRows.Add(res.GetLong("rowid")) Loop res.Close B4XTable1.Refresh End Sub Upvote 0
Worth posting a link to the relevant thread: https://www.b4x.com/android/forum/threads/102364 B4X: Sub Button1_Click Dim res As ResultSet = B4XTable1.sql1.ExecQuery("SELECT rowid FROM data") Do While res.NextRow SelectedRows.Add(res.GetLong("rowid")) Loop res.Close B4XTable1.Refresh End Sub
I ian2410 Member Licensed User Jul 3, 2019 #3 i'm loading data to the b4xtable from mysql using jrdc2. is there any way to Loop entire row in the table ? Upvote 0
i'm loading data to the b4xtable from mysql using jrdc2. is there any way to Loop entire row in the table ?
DonManfred Expert Licensed User Longtime User Jul 3, 2019 #4 https://www.b4x.com/android/forum/threads/b4x-b4xtable-load-data-from-sql-database.102520/ Upvote 0