Re: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Nachricht- Von: Odekirk, Shawn [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Oktober 2007 14:04 An: sqlite-users@sqlite.org Betreff: RE: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() The sqlite3_last_insert_rowid function is completely, 100% reliable in your

AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

ve > known beforehand that it is not reliable if used with ON CONFLICT clauses. > > Mike > > -Ursprüngliche Nachricht- > Von: Odekirk, Shawn [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 29. Oktober 2007 14:04 > An: sqlite-users@sqlite.org > Betreff: RE: AW: AW: [sqlite]

AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

This does look like a solution indeed. I'll try this one later. Thank you! Mike -Ursprüngliche Nachricht- Von: Simon Davies [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Oktober 2007 16:40 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] INSERT OR IGNORE and

RE: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

PM To: sqlite-users@sqlite.org Subject: AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() I'd suggest putting this into the documentation of sqlite3_last_insert_rowid(), that the call is not reliable in scenarios such as this one. -Ursprüngliche Nachricht- Von: D

Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

On 10/28/07, Michael Ruck <[EMAIL PROTECTED]> wrote: > I'd suggest putting this into the documentation of > sqlite3_last_insert_rowid(), that > the call is not reliable in scenarios such as this one. It might be appropriate to just stress it only works for successful INSERTs. I'd just assumed

AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Betreff: Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() On Oct 28, 2007, at 10:59 AM, Michael Ruck wrote: > Yes, I am well aware of this possibility as I've written in my > initial mail. > It just doesn't fit with the > description of sqlite3_last_insert_r

AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Good point. Thanks. -Ursprüngliche Nachricht- Von: D. Richard Hipp [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 28. Oktober 2007 17:48 An: sqlite-users@sqlite.org Betreff: Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() On Oct 28, 2007, at 10:59 AM, Michael Ruck

Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

On Oct 28, 2007, at 10:59 AM, Michael Ruck wrote: Yes, I am well aware of this possibility as I've written in my initial mail. It just doesn't fit with the description of sqlite3_last_insert_rowid() in my understanding. I think this is a bug - either in the documentation or in the

AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

] Gesendet: Sonntag, 28. Oktober 2007 15:36 An: sqlite-users@sqlite.org Betreff: Re: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() [Default] On Sun, 28 Oct 2007 10:00:52 +0100, "Michael Ruck" <[EMAIL PROTECTED]> wrote: >Hi, > >I did specify UNIQUE for cate

Re: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

[Default] On Sun, 28 Oct 2007 10:00:52 +0100, "Michael Ruck" <[EMAIL PROTECTED]> wrote: >Hi, > >I did specify UNIQUE for category. The id is also kept, so everything is >working >*except* that I don't get the id of the record ignored from >sqlite3_last_insert_rowid(). > >Mike You could simply

AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Hi, I did specify UNIQUE for category. The id is also kept, so everything is working *except* that I don't get the id of the record ignored from sqlite3_last_insert_rowid(). Mike -Ursprüngliche Nachricht- Von: Kees Nuyt [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 27. Oktober 2007