From 79eeff95e10b3d3d4b9de04dbb0a5a3a64d3cc20 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 15 Feb 2016 11:47:39 +0100 Subject: [PATCH] Missing semicolon in UPDATE instruction. --- sql/alter2.4rc1.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/alter2.4rc1.sql b/sql/alter2.4rc1.sql index 4091f80a..d49e498a 100644 --- a/sql/alter2.4rc1.sql +++ b/sql/alter2.4rc1.sql @@ -39,7 +39,7 @@ UPDATE `0_sys_prefs` SET `name`='default_wip_act' WHERE `name`='default_assembly UPDATE `0_wo_issue_items` i, `0_stock_moves` m SET i.unit_cost=m.standard_cost - WHERE i.unit_cost=0 AND i.stock_id=m.stock_id AND m.trans_no=i.issue_id AND m.`type`=28 AND m.qty=-i.qty_issued + WHERE i.unit_cost=0 AND i.stock_id=m.stock_id AND m.trans_no=i.issue_id AND m.`type`=28 AND m.qty=-i.qty_issued; UPDATE `0_wo_requirements` r, `0_stock_moves` m SET r.unit_cost=m.standard_cost -- 2.30.2