数据库实体 : AIS20200408093514

执行文件E:\KISUpdradeWISE V1.5\KISUpdradeWISE V1.5\SqlSrv\SP_KSEV12.1ICData_Public.sql出错。

错误描述:子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。

错误语句:

--TEAM=SCM,DBA=PanFeng_Yu,PM=yqmou,DC=zhgcui,TEL=8315

/**************************************************************************************

* BUG/REQUIREMENT ID: 补丁同步 PT024845 *

* DESCRIPTION: 医药版从收料通知单关联生成的外购入库单上的基本单位实收数量错误 *

* BY: Gosie *

* DATE: 2009-09-05 14:05 *

**************************************************************************************/

IF (SELECT FVALUE From t_SystemProfile Where FKEY='AcctType')='YYHY'

UPDATE ICSelBills SET FAction = 'CASE (SELECT FGSPUseQualityCheck FROM t_icitem WHERE FItemID=u1.FItemID) WHEN 0 THEN CASE (SELECT FValue FROM t_SystemProfile Where FCategory=''IC'' and FKey=''MaterialReturnDirect'') WHEN ''1'' THEN CASE WHEN (u1.FQty - isnull(u1.FCommitQty, 0)-u1.FBackQty)<0 THEN 0 ELSE (u1.FQty - isnull(u1.FCommitQty, 0)-u1.FBackQty) END ELSE CASE WHEN (u1.FQty - isnull(u1.FCommitQty, 0))<0 THEN 0 ELSE (u1.FQty - isnull(u1.FCommitQty, 0)) END END ELSE CASE (SELECT FValue FROM t_SystemProfile Where FCategory=''IC'' and FKey=''MaterialReturnDirect'') WHEN ''1'' THEN CASE WHEN (u1.FGSPEligibleQty_Base - isnull(u1.FCommitQty, 0))>(u1.FQty - isnull(u1.FCommitQty, 0)-u1.FBackQty) THEN CASE WHEN (u1.FQty - isnull(u1.FCommitQty, 0)-u1.FBackQty)<0 THEN 0 ELSE (u1.FQty - isnull(u1.FCommitQty, 0)-u1.FBackQty) END ELSE CASE WHEN (u1.FGSPEligibleQty_Base - isnull(u1.FCommitQty, 0))<0 THEN 0 ELSE (u1.FGSPEligibleQty_Base - isnull(u1.FCommitQty, 0)) END END ELSE CASE WHEN (u1.FGSPEligibleQty_Base - isnull(u1.FCommitQty, 0))<0 THEN 0 ELSE (u1.FGSPEligibleQty_Base - isnull(u1.FCommitQty, 0)) END END END'

WHERE FID='A01' AND FFieldName='FSCBillInterID' AND FColName IN('FQty','FQtyMust')

产品问题旗舰版迁K3WISE日志报错

产品问题 旗舰版迁K3WISE日志报错

恭喜您！

产品问题
旗舰版迁K3WISE日志报错

产品问题旗舰版迁K3WISE日志报错