Sqlite - database.tablecolumns still not fixed?

Getting Started
1

Can someone confirm that this is still not fixed? It is supposed to return the column (fields) information for the table passed to it, but I’m getting something that’s not even close.

In the past, I think I used a pragma statement to get table columns. Is that still an option?

2

It seems to work here:

image
image686×435 12.8 KB

image
image880×471 15.9 KB

var db as new SQLiteDatabase

db.Connect

db.ExecuteSQL("create table tab1 (f11, f22, f33)")

var rs As RowSet = db.TableColumns("tab1")

var list() As Variant

for each row As DatabaseRow in rs
  list.add row
Next

break
1 Like
3

Put this down to user error! Just didn’t recognize the first column it returned but after browsing through them… it’s working.

1 Like