On 1/24/2013 12:47 AM, Richard Baron Penman wrote:
How to find which keys have been updated from this query?
You can't, really. If you need a list of keys (or in fact a list of anything from the database), you need to run a SELECT statement. At which point you are back where you started and might as well keep the original design.
If you really don't want to do that for some reason, you could create an AFTER UPDATE trigger on the table, which would call a custom function, passing each key to it as the status is being updated.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
