SQLite get the old value after update

Question

For my Android app i'd need to make uptades in some rows of a table and show the to the user the old and the new value. Is there any way of doing that with a single query to the db (with a method that returns the updated rows or similar? )? or I must use two query: fetch old values and then update with the new ones?

Thanks in advance

Answer 1

You need to do that with two queries. You can begin a transaction prior to the read if you want to be assured that its value doesn't change before you write -- just be sure to commit the transaction to enable your change.

Answer 2

As far as I know SQLite doesn't support the fetch-from-update clause like other DBs so you're best to run two queries.