After a bit of trying I found that without WHEN the Modified column is updated when the INSERT trigger is run. But after adding **WHEN OLD.Modified != DATETIME('NOW','localtime')** there is never any update to the Modified column! Any clue what's wrong?