K3WISE 14.2 GSP首营管理中的证照新增不显示
888次浏览
编辑于2016年06月29日 10:00:24
K3WISE 14.2 GSP首营管理中的证照新增不显示,并且在首营品种中也有一个证照,按F7还报错,如下图:
新增后的证照都不显示,这是产品问题.
产品的BUG啊,不是忽优人了.
跟踪后发现以下语句有误
select * from SELECT FDeleted, FTypeID,FInterID FItemID, FID FNumber,FName,FSpec FROM t_SubMessage Where FInterID>0 AND FDeleted=0 And FTypeID=421 AND (FInterID in(select t11.FCardTypeID from t_GSMP_CardControlLvl t11 inner join t_icitem t22 on t11.fsort=t22.ftypeid and t22.fitemid= where t11.FCtrlType=2 group by t11.FCardTypeID ) ) And (FInterID in(select t11.FCardTypeID from t_GSMP_CardControlLvl t11 inner join t_icitem t22 on t11.fsort=t22.ftypeid and t22.fitemid= where t11.FCtrlType=2 group by t11.FCardTypeID ) ) ORDER BY FID
推荐阅读