增加用户时提示“名称或代码在系统中已被使用”
ç»ä½ ä¸ä¸²ä»£ç ï¼å¨æ°æ®åºä¸æ§è¡ä¸ä¸ï¼è®°å¾å
å¤ä»½å¸å¥ï¼
exec sp_cleanitemdetailv
go
update a set a.fdetailcount=b.Fcount
from t_itemdetail a join (select Fdetailid,count(*) as Fcount from t_itemdetailv
where fitemid=-1 group by Fdetailid) b
on a.fdetailid=b.fdetailid where a.fdetailcount<>b.Fcount
go
exec sp_cleanitemdetailv
go
update a set a.fdetailcount=b.Fcount
from t_itemdetail a join (select Fdetailid,count(*) as Fcount from t_itemdetailv
where fitemid=-1 group by Fdetailid) b
on a.fdetailid=b.fdetailid where a.fdetailcount<>b.Fcount
go
温馨提示:答案为网友推荐,仅供参考
第1个回答 2014-07-04
你换个代码或者名称再输入追问
换个名称也不行的
追答如果你用任意代码或者名称都不行,那就是数据库出问题了,建议联系金蝶客服解决
第2个回答 2014-07-10
你所使用的代码被禁用了吧