On 4 Apr 2011, at 2:48pm, Enrico Thierbach wrote: > isn't last_insert_rowid defined as the ID of the last row inserted
Yes it is. But the FTS system does what it does by maintaining extra tables, and doing extra operations to them besides the ones that the programmer has asked for. Naturally this means that several things get done after each INSERT operation the programmer asked for, so last_insert_rowid() may as well be a random number. Just get used to the idea that last_insert_rowid() doesn't work for FTS tables and won't do unless someone rewrites FTS with that specifically in mind. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
