On Thu, Dec 17, 2009 at 1:43 PM, P Kishor <[email protected]> wrote: > On Thu, Dec 17, 2009 at 11:05 AM, Martin Kirsche <[email protected]> > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
