How to insert any string in sqlite3 in c

Posted by ashishtripathi.hcu on Stack Overflow See other posts from Stack Overflow or by ashishtripathi.hcu
Published on 2010-05-31T08:46:21Z Indexed on 2010/05/31 8:52 UTC
Read the original article Hit count: 156

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about c

    Related posts about sqlite3