|
Posted by Good Man on 01/03/08 17:52
Bre-x <cholotron@hotmail.com> wrote in news:c714902a-93d8-49a8-b862-
f8e4ad6d8bcb@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!
Navigation:
[Reply to this message]
|