SQLite metadata?

LiveCode is the premier environment for creating multi-platform solutions for all major operating systems - Windows, Mac OS X, Linux, the Web, Server environments and Mobile platforms. Brand new to LiveCode? Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
WorldWizards
Posts: 3
Joined: Wed Feb 25, 2015 4:06 am

SQLite metadata?

Post 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.
Attachments
Screen Shot 2015-02-24 at 10.14.15 PM.png
Simon
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3901
Joined: Sat Mar 24, 2007 2:54 am

Re: SQLite metadata?

Post 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
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!
WorldWizards
Posts: 3
Joined: Wed Feb 25, 2015 4:06 am

Re: SQLite metadata?

Post by WorldWizards »

Thats all I need for the moment.

Thanks!
Klaus
Posts: 14325
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: SQLite metadata?

Post by Klaus »

The errordialog is pointing to an error in your getDataBaseID() function and has nothing to do with PRAGMA etc.!
Post Reply