SQLite Primary Key

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
phaworth
Posts: 592
Joined: Thu Jun 11, 2009 9:51 pm

SQLite Primary Key

Post by phaworth » Tue Jul 14, 2009 6:19 pm

Anyone know of a way to get the name of the primary key of an SQLite table? I see a function that lists the type of each field but doesn't look like it includes the primary key property. Maybe there's an SQLite command rather than a Revolution one?
Thanks,
Pete
Top
Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Contact:
Contact Janschenkel

Post by Janschenkel » Tue Jul 14, 2009 9:53 pm

You'll have to use an SQL query: see http://www.sqlite.org/faq.html#q7

Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com
Top
phaworth
Posts: 592
Joined: Thu Jun 11, 2009 9:51 pm

Post by phaworth » Tue Jul 14, 2009 10:15 pm

Thanks, will look into that.
Pete
Top
Post Reply

Return to “Getting Started with LiveCode - Complete Beginners”