📢 SMT模治具未上模报错：“模治具型号编码

未上模，不允许操作!”

1、症状及原因

2、方法

SQL
-- WP_MTLD_STAT	NUMBER(4,0)	否	工序上模治具校验
-- 0:未上模
-- 1:已上模
-- 2:部分上模
-- 10:无需上模

SELECT
	* 
FROM
	BS_MO
WHERE
	MO_CODE = 'GD5108-202412290095-SMT-B'
-- 	AND ROWNUM <= 1000;
or MO_CODE = 'GD5108-202412140080-SMT-B'
or MO_CODE = 'GD5101-202412290006-SMT-B'

or MO_CODE = 'GD5108-202412240082-SMT-B';

SELECT
	*
FROM
	BS_MO_PROG_WP 
WHERE
	(MO_ID = 'R1058416351099822080'
	or 
	MO_ID = 'R1053592338099937280'
	or 
	MO_ID = 'R1058417407867297792'
	or
	MO_ID = 'R1056980030405812224')
	AND ( SEQ = 1 or SEQ = 11);
	
UPDATE 	BS_MO_PROG_WP 
SET WP_MTLD_STAT = 10,
remark = 'SMT-郭元芳：2025/01/19' 
WHERE
	(MO_ID = 'R1058416351099822080'
	or 
	MO_ID = 'R1053592338099937280'
	or 
	MO_ID = 'R1058417407867297792'
	or
	MO_ID = 'R1056980030405812224')
-- 	AND SEQ = 1;
AND ( SEQ = 1 or SEQ = 11)

3、修改后

More info call： 微信/企业微信/钉钉/QQ/手机号（都没有 就不给）