Column names and types can be found with the following calls :
sqlite3_column_name(ppStmt,x);
sqlite3_column_decltype(ppStmt,x);
sqlite3_column_type(ppStmt,x);
Where ppStmt is the structure you get back from the prepare/step
functions.
Listing the tble names I am not sure about, I would assume there is some
sort of 'select * from master' type query. Take a look at the code for
the sqlite2.exe console executable, I bet it is in there somewhere.
DType=AnsiString(sqlite3_column_decltype(ppStmt,x)).UpperCase();-----Ori
ginal Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of c.panel
Sent: Tuesday, June 24, 2008 3:04 PM
To: [email protected]
Subject: [sqlite] Accessing to database informations
Hello,
I'm a new user of SQLite, (and SQL too). I'm trying to find how can I
access to tables names, column names and types, from a database, using C
API. I found this from a result set but what about resident tables ?.
Perhaps must I use a SELECT statement for this ? But If I do, does
SQLLite generate a file from database (so time consuming...) or Is there
a method I missed ?
thanks for your answers.
--
View this message in context:
http://www.nabble.com/Accessing-to-database-informations-tp18098876p1809
8876.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
