Dennis Cote wrote:
What happens to the ROWID when the transaction is rolled back? Is it
as if the record with that ROWID was deleted?
Yes
If I understand it correctly, connection C1 can do an INSERT, get
ROWID 4, C2 does an INSERT, gets 5, and commits, and then C1 commits,
with its 4; if C
Michael Ekstrand wrote:
[EMAIL PROTECTED] wrote:
The ROWID is generated after the BEFORE triggers fire and
before the row is inserted.
OK, I think I'm getting it. The INSERT statement generates the ROWID,
fires triggers, then inserts the row. When the transaction is
committed, all that
[EMAIL PROTECTED] wrote:
The ROWID is generated after the BEFORE triggers fire and
before the row is inserted.
OK, I think I'm getting it. The INSERT statement generates the ROWID,
fires triggers, then inserts the row. When the transaction is
committed, all that is committed; when the tran
Michael Ekstrand <[EMAIL PROTECTED]> wrote:
> Will Leshner wrote:
> > On 4/17/06, Michael Ekstrand <[EMAIL PROTECTED]> wrote:
> >
> >> So, if someone could enlighten me as to the defined behavior of
> >> sqlite3_last_insert_rowid with regards to transactions, I would be most
> >> grateful.
> >
>
On 4/18/06, Michael Ekstrand <[EMAIL PROTECTED]> wrote:
> Now, who got the "next" ROWID? Conn 1 or Conn 2? What did
> sqlite3_last_insert_rowid() return to Conn 1?
sqlite3_last_insert_rowid() can only return the last rowid of the
current connection. It can't return the last rowid of some other
c
Will Leshner wrote:
On 4/17/06, Michael Ekstrand <[EMAIL PROTECTED]> wrote:
So, if someone could enlighten me as to the defined behavior of
sqlite3_last_insert_rowid with regards to transactions, I would be most
grateful.
The last insert id is a property of a connection. So there is no way
th
On 4/17/06, Michael Ekstrand <[EMAIL PROTECTED]> wrote:
> So, if someone could enlighten me as to the defined behavior of
> sqlite3_last_insert_rowid with regards to transactions, I would be most
> grateful.
The last insert id is a property of a connection. So there is no way
that one connection
I'm trying to figure out how sqlite3_last_insert_rowid() interacts with
transactions.
I've read the thread at
http://www.mail-archive.com/sqlite-users@sqlite.org/msg13393.html
However, the concern raised in the last message of that thread is
exactly my concern, and was never addressed in the cont
8 matches
Mail list logo