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 using sqlite3_exec() > and 'create table' and 'insert into' > then again if i use sqlite3_exec() with select like > my sql statement is : select * from my_table where > Primarykey="google.com" > where google.com primary key and its related information is not already > in my table but it is returning > SQLITE_OK...even it must be return some error as that primary key is not > in my table. > .how should i get the error...when using select and if primary key will > not be there ..after creating table with using sqlite3_exec() function + > select sql statemant. > > Thanks in advance for any ideas > Harioum > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
