SQLite Forum

how to check update statement really modify a record
i just want to know if a record was modified or not,i get the answer by other post.

in the situation:


1:sqlite3_exec("insert statement...");

2:sqlite3_exec("update table set xx=abc where id=911");

3:sqlite3_exec("insert statement...");


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.:)