[sqlite] insert in C

[mrobi002]

Good Morning,

I would like to write in C the equivalent code for:

   insert into table1 values('Hello');

using a variable  char temp[20]= "Hello";

instead of the literal Hello


I have used multiple variations of the following, but no luck

    char temp[20]= "Hello";
    sql = "INSERT INTO probes VALUES('%s', :temp)";
    rc = sqlite3_exec(db, sql, NULL, NULL, &zErr);

Thank you

Michael

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users