How to insert any string in sqlite3 in c
- by ashishtripathi.hcu
Hi
I have to insert a string into a sqlite data base
my command ..
Err=sqlite_exec(DB, "create table tbl5(TEXT varchar(100));", xCallback, (void*)"First Test", &ErrMsg);
Err=sqlite_exec(DB, "insert into tbl5 values ('some string');", xCallback, (void*)"First Test", &ErrMsg);
works fine but when I want to put s="some string" ie
Err=sqlite_exec(DB, "insert into tbl5 values (s);", xCallback, (void*)"First Test", &ErrMsg);
then this is not working so how to add variable then It is not working so how to insert variable in sqlite database
thank u