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. > > > > The last insert id is a property of a connection. So there is no way > > that one connection can accidently get the last row inserted by > > another connection. > > But when is the ROWID generated? Is it generated when the INSERT is > evaluated/executed, or when it is committed? >
The ROWID is generated after the BEFORE triggers fire and before the row is inserted. -- D. Richard Hipp <[EMAIL PROTECTED]>