Page 1 of 1
SQLite metadata?
Posted: Wed Feb 25, 2015 4:09 am
by WorldWizards
How do I retrieve SQLite table metadata in LiveCode?
SQLite has a PRAGMA statement for this but just sending it to the DB the way I would send a query
appears to generate an error.
Re: SQLite metadata?
Posted: Wed Feb 25, 2015 4:29 am
by Simon
Hi WorldWizards,
Welcome to the forum!
If it's the column names you are after look up "revDatabaseColumnNames" in the dictionary.
If it's something else just say.
Simon
Re: SQLite metadata?
Posted: Wed Feb 25, 2015 4:49 am
by WorldWizards
Thats all I need for the moment.
Thanks!
Re: SQLite metadata?
Posted: Wed Feb 25, 2015 4:10 pm
by Klaus
The errordialog is pointing to an error in your getDataBaseID() function and has nothing to do with PRAGMA etc.!