[pssquirrel]

I feel like a complete idiot. After successfully figuring out how to create the trigger using MesaSQLite, I decided to try it using SQLite Manager (which I wasn't aware of before, and after taking a look, I rather like it). Should be simple, right? Well, I've tried for over an hour, and every time I try, I get an error -- most commonly "near UPDATE: syntax error"

J.L.C., would it be possible for you to upload a screenshot of what you did?

The closest I get without an error is attached. When I remove the quote marks from the WHEN clause, I get an error message. But the resulting trigger with quote marks isn't exactly the same as Kolenka's original code, and I don't know enough about this stuff to know if it makes a difference. Help!