Hello! On Tuesday 30 March 2010 16:12:18 Pavel Ivanov wrote: > From http://www.sqlite.org/c3ref/last_insert_rowid.html: > > "If an INSERT occurs within a trigger, then the rowid of the inserted > row is returned by this routine as long as the trigger is running. But > once the trigger terminates, the value returned by this routine > reverts to the last value inserted before the trigger fired." > > Your insert definitely happens in the trigger, so no access to rowid outside.
Hm... yes, so it's not the problem, this is feature :-( Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users