You are not calling sqlite3_step
, which performs the update. After the sqlite3_prepare
and before the sqlite3_finalize
, you need something like:
if (sqlite3_step(compiledStatement) != SQLITE_DONE)
NSLog(@"%s: step error: %s", __FUNCTION__, sqlite3_errmsg(database));
0
solved Sqlite3 update query not working in ios app