i just want to know if a record was modified or not,i get the answer by other post.
in the situation:
begin;
1:sqlite3_exec("insert statement...");
2:sqlite3_exec("update table set xx=abc where id=911");
3:sqlite3_exec("insert statement...");
commit;
if step 1,2,3 all success,invoke commit,otherwise rollback.
in step 2 ,because of 911 is a invalid value,so update statement can't find a record which id equal to 911 in table ,i think update fail.so step 3 in skipped. the transaction rollback.but sqlite3_exec still return sqlite_ok.so i want to check a record was modified or not.
thank you all the same.:)