Re: [sqlite] About select records from table

2008-10-29 Thread Simon Davies
Hi yoky, 2008/10/29 yoky <[EMAIL PROTECTED]>: > Hi all, >I create a table with 250 columns and this table has 3 records, I > want to select the records from the table which satisfy certain conditions. > the SQL statement like this: >select * from tablename where (conditions); >

[sqlite] About select records from table

2008-10-29 Thread yoky
Hi all, I create a table with 250 columns and this table has 3 records, I want to select the records from the table which satisfy certain conditions. the SQL statement like this: select * from tablename where (conditions); Then use sqlite3_get_table() function to get the