SQLite Forum

create trigger
Login
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?