Oliver Schneider <oli...@f-prot.com> wrote: > Hmm, strange. These are the triggers I used: > > CREATE TRIGGER IF NOT EXISTS file_change AFTER UPDATE OF hash,name,path > ON file > BEGIN > UPDATE file SET modified=julianday('now'); > END;
This updates all the rows in the table, not just the one for which the trigger was fired. You want something along the lines of UPDATE file SET modified=julianday('now') where file.rowid = new.rowid; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users