By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

TRIGGER Help

P: n/a
What's wrong with this script?
I got error:
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 'SET NEW.TSHP = 0' at line 5

CREATE TRIGGER shipumw01 BEFORE INSERT ON umw_ship_sol
FOR EACH ROW
BEGIN
IF NEW.L0 <0 THEN
SET NEW.TSHP = 0;
SET NEW.LSHP = 0;
SET NEW.NSHP = 0;
SET NEW.BO = NEW.OQTY;
SET NEW.ST = 'NS';
END IF;
END
Jan 3 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bre-x <ch*******@hotmail.comwrote in news:c714902a-93d8-49a8-b862-
f8**********@e23g2000prf.googlegroups.com:
What's wrong with this script?
I got error:
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 'SET NEW.TSHP = 0' at line 5

CREATE TRIGGER shipumw01 BEFORE INSERT ON umw_ship_sol
FOR EACH ROW
BEGIN
IF NEW.L0 <0 THEN
SET NEW.TSHP = 0;
SET NEW.LSHP = 0;
SET NEW.NSHP = 0;
SET NEW.BO = NEW.OQTY;
SET NEW.ST = 'NS';
END IF;
END
Answered in comp.databases.mysql over an hour ago. Where you been? And
don't multipost!
Jan 3 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.