sqlite - Do WITH statements work inside a trigger definition? -

i trying create trigger adds parts stock in lots table when work order deleted workorders table. should delete references work order in workorderlots table. trigger definition came with.

create trigger delete_wo before delete on workorders begin  info      (select (part.qnty * wo.qnty) qnty, lot.lotnumber lotnum      wo_qntys part      join workorders wo on part.name = wo.build      natural join workorderlots lot      wonumber = old.wonumber) update lots set stock = stock +                      (select qnty info                          lotnum = lotnumber)                      lotnumber in (select lotnum info);      delete workorderlots wonumber = old.wonumber;  end 

when attempt run query, error: near "update": syntax error. i'm suspicious with statement what's giving me problems, can't why.

the documentation says:

common table expression not supported statements inside of triggers.