On Thu, Dec 17, 2009 at 1:43 PM, P Kishor <punk.k...@gmail.com> wrote: > On Thu, Dec 17, 2009 at 11:05 AM, Martin Kirsche <martin.kirs...@gmx.net> > wrote: >> Hi, >> is it possible in SQLite to find out which row had been modified by an >> UPDATE statement? > > just SELECT with the same params that you used in your UPDATE.
Unless the params were modified by the update. For example, sqlite> update foo set bar=1 where bar=2; sqlite> select rowid from foo where bar=2; Regards, - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
