I've just pasted that into an sqlite3 prompt and tried: ``` update a1 set a1_stock_min=222 where a1_index=12 ; ``` which gives: ``` Error: no such column: A1_STATUS ``` leading me to suspect: ``` WHEN (A1_STATUS = 2) AND (A1_REF ISNULL) ``` should have `OLD.` or `NEW.` added to `A1_STATUS` and `A1_REF`. Adding either allows the update to work (though I've no idea whether the trigger is doing what it's meant to do). I don't know what "all sorts of errors" you're seeing, but a good starting point if there are lot (whether it's SQL or compiler errors) is to ignore everything except the first one. Fix that then try again.