sql - SQLite not finding field in trigger -

sql - SQLite not finding field in trigger -

i have 2 tables. 1 deductions , other deducttrans. iddeductions key field in deductions, , foreign key in deducttrans. i've got couple of things want automatically in deductions when deducttrans inserted. have trigger, compiles.

create trigger trig_deducttrans after insert on deducttrans begin update deductions set remainingct = remainingct - 1 iddeductions = new.iddeductions ; end;

when insert record, receive next error: "no such column iddeductions"

i'm @ loss. i've tried changing deductions.iddeductions = new.iddeductions doesn't help. ideas?

sqlite claims deductions table has no column named 'iddeductions'. haven't given means check, it's right. observe trigger on different table (deducttrans), apparently expect have column iddeductions.

most corresponding column in deductions named differently. example, perhaps named id.

sql sqlite triggers