金蝶云·星空|生产订单执行开工报错
生产订单执行开工报错:
Divide by zero error encountered.
The statement has been terminated.
祥细信息:
发生时间: 2019-03-20 01:40:14
错误编号: BOS_ExecuteNonQuery
错误信息: Divide by zero error encountered.
The statement has been terminated.
Sql语句: MERGE INTO T_PRD_MOENTRY_A U1 USING(SELECT 3 fnewstatus, T1.FENTRYID FROM T_PRD_MOENTRY T1 WHERE T1.FENTRYID IN (158287) UNION ALL SELECT 3 fnewstatus, T2.FENTRYID FROM T_PRD_MOENTRY T1 INNER JOIN T_PRD_MOENTRY T2 ON T1.FROWID = T2.FPARENTROWID WHERE T1.FENTRYID IN (158287)) U2 ON (U1.FENTRYID = U2.FENTRYID) WHEN MATCHED THEN UPDATE SET U1.FStatus = U2.FNEWSTATUS;