Re: [sqlite] Detecting changes/last insert rowid question

Keith Herold wrote: Well, yeah, I was hoping to get it out of a succession of queries. SQLite's API is hidden behind a wrapper, and most of it is masked out, so getting access to the API is problematic. Unfortunately, the semantics of the return code on that API call mean that the execute took p

Re: [sqlite] Detecting changes/last insert rowid question

Well, yeah, I was hoping to get it out of a succession of queries. SQLite's API is hidden behind a wrapper, and most of it is masked out, so getting access to the API is problematic. Unfortunately, the semantics of the return code on that API call mean that the execute took place, not necessari

[sqlite] Detecting changes/last insert rowid question

I know I can recover the last_insert_rowid() in SQLite in the SQL query itself; is there an equivalant SQL function to sqlite_changes or sqlite_last_statement_changes (from 2.8.15)? If, for example, an insert doesn't take place, I get the last id of the insert *before* this one. What I would real