> You gave no details. > > Did you open the database first? All right, I'm sorry, here is a more complete code snip to illustrate my problem:
sqlite3 * db; rc = sqlite3_open("test.db", &db); if(rc) { fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); exit(1); } rc = sqlite3_exec(db, "update usertable set last_access = 1234 where id_user = 1234", 0, 0, 0); rc is 14 after these lines. As I said, I can do all kind of "Select" Queries from the database in the very same program without any problems. The Query "select id_user, last_access from usertable" returns id_user = 1234 and last_access = 1128425315, so the table and the columns exist - the update statement just does not get executed.