subject:"\[sqlite\] last_insert_rowid\(\) with conflict"

Re: [sqlite] last_insert_rowid() with conflict

2012-06-19 Thread Pavel Ivanov

On Tue, Jun 19, 2012 at 11:02 AM, Baruch Burstein 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

[sqlite] last_insert_rowid() with conflict

2012-06-19 Thread Baruch Burstein

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