Código sql:
Ver originaldelimiter &&
CREATE TRIGGER tvp_scon BEFORE INSERT ON pos_tpv
FOR EACH ROW BEGIN
IF NEW.did = 0 THEN
UPDATE pos_stock SET cta =cta-NEW.cta WHERE (pid, LOCAL) = (NEW.pid, NEW.LOCAL);
ELSEIF NEW.did = 1 THEN
UPDATE pos_stock SET cta =cta+NEW.cta WHERE (pid, LOCAL) = (NEW.pid, NEW.LOCAL);
END IF;
END&&
delimiter ;
así?