Re: [sqlite] last_insert_rowid() with conflict

[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 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

[sqlite] last_insert_rowid() with conflict

[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 to know the row of the inserted item (whether it was inserted now or
previously)

-- 
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users