SQLite and Introspection : Answer.

Hello,

syc> I think I didn't made myself clear in my earlier email: even though I
syc> can access all my tables through SQLITE_MASTER, I cannot access the 
syc> columns for a particular table.

Yes, it's true.

syc> Where are the names of the columns stored for the user tables?

I've had the same problem, and someone answered that question. In
fact, you have to use the PRAGMA statement :

                  PRAGMA TABLE_INFO(tableName)

Returns the detail about the columns and their types.
                  


-- 

   Antoine Boegli

   Département informatique

Frequence Laser SA

Place Bel-Air 1
1002 Lausanne
t +41 21 311 61 52
f +41 21 311 61 82
e antoine.boegli-cLID57s+nw4+IpU6O8WCWA@xxxxxxxxxxxxxxxx

www.talkmusic.ch 

0848 848 898


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/CBxunD/vN2EAA/xGHJAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/