Código PHP:
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;
Aqui les dejo el error:
Código PHP:
Error
consulta SQL:
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 ) ;
MySQL ha dicho:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4