On Tue, Jun 19, 2012 at 11:02 AM, Baruch Burstein <bmburst...@gmail.com> wrote: > If I have a column that has unique values, and the ON CONFLICT clause is > IGNORE, is there a way to get the rowid of the last insert (on > success) *or*the last conflict (on conflict). I would like to just > keep adding to the > table without worrying if there is a duplicate, but after each insert I > need to know the row of the inserted item (whether it was inserted now or > previously)
No, anything that was inserted previously can be accessed only via SELECT. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
