I have created Tables A & AS_FTS "create table A (id integer primary key, string Text);"
"create virtual table AS_FTS (Name);" and a trigger "insert into A_FTS (rowid,Name) values (New.%@,New.%@);" (and a not shown delete trigger). Now, I enter two strings into tue table: one and two. I delete table entry one and insert afterwrds two times one again. Finally I check the last inserted rowid using "sqlite_last_insert_rowid". Unfortunately, this is wrong. BTW: other non-FTS insert triggers seem to work. I am using 3.6.14. Any ideas? Hartwig _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users