dan.winslow wrote:
>
> 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.
>
I have found too these functions, but I don't want to prepare a statement
but just query the database. I think preparing a statement could be time
consuming (isn't it?). If not, I should have to prepare a statement like
this : "select * from sometable;" ?
> 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 sqlite3.exe console executable, I bet it is in there somewhere.
>
yes! I have found "select * from sqlite_master". Please confirm...
I have not look at seriously the code (beginning), but I ask me what has
SQLite to do when preparing a statement (perhaps not time consuming, because
executing statement must be ?).
thanks a lot
--
View this message in context:
http://www.nabble.com/Accessing-to-database-informations-tp18098876p18100508.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
