> Is there some chance that table/view data could have been updated without the trigger having been run, such that on the next update, it is not possible to specify correct old.values to delete?
Your first post contained triggers on views. e.g.
CREATE TRIGGER __item_search_ai INSTEAD OF INSERT ON item_view BEGIN
INSERT INTO item_search(rowid, title, series, creator, publisher, year, subject, description) VALUES(new.id, new.title, new.series, new.creator, new.publisher, new.year, new.subject, new.description);
END;
You know this trigger runs only when the client (or some other trigger) executes a statement that begins with "INSERT INTO item_view...", right?
More specifically, you're aware that triggers on views do not automatically run whenever the tables used by the view are modified such that the contents of the view changes?
Dan.