SQLite Forum

how to check update statement really modify a record
hi,when i use sqlite3_exec() to do "update table set column_name=value where id=911;".
but if no sql syntax,the sqlite3_exec() always return SQLITE_OK even if 'where' clause is not true (no record that id equal to 911).

is there any method to check the update statement is really modify a record ?