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 » Wed Feb 25, 2015 4:09 am

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
Top
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 » Wed Feb 25, 2015 4:29 am

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!
Top
WorldWizards
Posts: 3
Joined: Wed Feb 25, 2015 4:06 am

Re: SQLite metadata?

Post by WorldWizards » Wed Feb 25, 2015 4:49 am

Thats all I need for the moment.

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

Re: SQLite metadata?

Post by Klaus » Wed Feb 25, 2015 4:10 pm

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

Return to “Getting Started with LiveCode - Experienced Developers”