On Fri, Oct 21, 2011 at 12:31 PM, Pavel Ivanov <paiva...@gmail.com> wrote:
> http://www.sqlite.org/c3ref/last_insert_rowid.html > > "If an INSERT occurs within a trigger or within a virtual table > method, then this routine will return the rowid of the inserted row as > long as the trigger or virtual table method is running. But once the > trigger or virtual table method ends, the value returned by this > routine reverts to what it was before the trigger or virtual table > method began." > I missed this. It answers my question. Thank you. I will try to be more thorough in reading before posting. > Why do you want to know last inserted rowid for something happened in > the trigger, i.e. for something you didn't explicitly requested to do? > Actually, I don't. The page you cited above points that scoping is intended/implemented such that triggers aren't meant to complicate what happens outside their purview. What happens in Vegas stays in Vegas. Thanks, again. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users