Hi,
Can someone please explain how to obtain the values for all the columns of the single record/Result as list obtained in SQLite? Trying to get a list of the results and put on a tableview... one column with the Column names of the SQlite and another column from the SQLite results.
1. "select * from DATABASE where key="2.3754.60"
2. I get the following from the SQLite command above.
KEY COL1 COL2 COL3 COL4 COL5 COL6 COL7 ---> names of columns
"2.3754.60" "value1" "value2" "value3" "value4" "value5" "value6" "value7" ---> single row of values
3. Not sure how to set up the code
Do While ResultSet4.NextRow
Dim Row(ResultSet4.ColumnCount) As Object
Loop
4. In the TableView, I would like to see the Results as
KEY 2.3754.60
COL1 Value1
COL2 Value2
COL3 Value3
COL4 Value4
so on...
any help is appreciated