Re: [sqlite] problem with sqlite3_exec() and select sql statemant

2008-10-14 Thread John Stanton
Use the correct SQL delimiter for a literal - single quotes, e.g. 'google.com'. Hari wrote: > Hi as i am new to sqlite. > I have problem when i am using sqlite3_exec() function with select > as i am using sqlite3_open() to opening database > then creating table and inserting some information

Re: [sqlite] problem with sqlite3_exec() and select sql statemant

2008-10-14 Thread Martin.Engelschalk
Hello Hariom, - use single quotes around text constants: select * from my_table where Primarykey='google.com' - use sqlite3_prepare and sqlite3_step to select data. First call sqlite3_prepare for your statement and then sqlite3_step in al loop until it returns SQLITE_DONE - It is not an error

[sqlite] problem with sqlite3_exec() and select sql statemant

2008-10-14 Thread Hari
Hi as i am new to sqlite. I have problem when i am using sqlite3_exec() function with select as i am using sqlite3_open() to opening database then creating table and inserting some information using sqlite3_exec() and 'create table' and 'insert into' then again if i use sqlite3_exec() with select