On 6 Mar 2017, at 10:01pm, Richard Hipp <[email protected]> wrote: > On 3/6/17, Simon Slavin <[email protected]> wrote: >> >> This means that each TRIGGER is its own little story, right ? Triggers can >> make their own inserts. Which may themselves have triggers. SQLite >> maintains a happy stack of values for last_insert_rowid(), pushing and >> popping them each time you enter or exit a trigger ? > > Correct
Thank you. I wrote one piece of code which assumed this but wasn’t sure whether it was certain in future versions. What you wrote assures me that I can assume future versions of SQLite3 will work the same way. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

