Penman wrote: How to find which keys have been updated from this query? There is sqlite3_update_hook() function that returns rowid of changed record.
Regards, Yongil Jang. On Jan 24, 2013 11:10 PM, "Igor Tandetnik" <i...@tandetnik.org> wrote: > 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<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
