Re: [sqlite] number of columns in a table

Hi, see http://www.sqlite.org/capi3ref.html#sqlite3_column_count. Do this: sqlite3_stmt *pStmnt; sqlite3_prepare(YourDbHandle, "select * from YourTable limit 1", -1, , 0); int NumberOfColumns = sqlite3_column_count(pStmnt); sqlite3_finalize(pStmnt) Martin baxy77bax wrote: > hi, > > my

Re: [sqlite] number of columns in a table

hi, my question is how to get the number of columns in an existing table. example if i can retrieve the number of rows with SELECT count(*) FROM table , is there also some simple query to do the same thing for counting the number of columns == Hello, "r" You can use sql to query

[sqlite] number of columns in a table

hi, my question is how to get the number of columns in an existing table. example if i can retrieve the number of rows with SELECT count(*) FROM table , is there also some simple query to do the same thing for counting the number of columns thnx r -- View this message in context: