sqlite pragma commands
The following returns null, but should be a valid sqlite command.
var rows = db.execute("pragma table_info(clients)");
is it not possible to get information using the pragma statement.
I am trying to get a list of column names from my table. I suppose i could interrogate the rows object to find this. Haven't tried that yet.
2 Answers
-
I don't know why pragmas are not supported, but you can obtain the same information by reading the sqlite_master table (albeit with some difficulty)
-
I just tried some pragma commands in 1.3.4 and they worked find.
var rows = db.execute('PRAGMA database_list');
I didn't not try table_info() though