Oliver Schneider <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
