hi,
need help with very basic question.. More of C than SQLite.
have a very simple C program using sqlite DB.
..................
int i=0;
rc = sqlite3_exec(db, "create table emp (empid num);", callback, 0, &zErrMsg);
rc = sqlite3_exec(db, "insert into emp values(i);", 0, 0, &zErrMsg);
-------------------
the insert query fails with the message stating no such column i.
the aim is very simple to insert the value of i into empid column but not sure
how to achieve it.
pls note that value of i is dynamic and wont be hardcoded.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
