I want to use DButils to list multicolumn contents from a SQLite database in a tableview.
However so far I can only list the query into the first column, even though I initialize with mylist = tableview.items to associate the list data with the tableview columns. My db holds 7 columns, so how to work with lists with a 7 column database contents through dbutils? This keeps my busy.
Parts of my code
Any clues are very appreciated, thanks.
However so far I can only list the query into the first column, even though I initialize with mylist = tableview.items to associate the list data with the tableview columns. My db holds 7 columns, so how to work with lists with a 7 column database contents through dbutils? This keeps my busy.
Parts of my code
B4X:
Dim tableView1 As TableView
Dim mylist As List
Private SQL1 As SQL
mylist.Initialize
mylist = tableView1.Items
SQL1.InitializeSQLite("c:\", "test.sqlite", False)
DBUtils.ExecuteTableView(SQL1, "SELECT DocName FROM UserTable", Null, 0, tableView1)
For Each i As String In mylist
Log(i)
NextAny clues are very appreciated, thanks.
The image shows my SQLite database which I've used with a prototype code snippets tool that I wrote 3 years ago in C sharp, so I am porting that application to B4J. It does not look so good and have to be tweaked, but it's a milestone that I've come this far with my work. Actually it helped me to study your code earlier today. I'm impressed by how well you've understood B4J and how you organize your code in code modules. Nice and tidy code, well done.
