金蝶kis旗舰版账套管理登录提示下标越界?

售后技术专线：4006-6500-28

新购有特价、金蝶老客户升级金蝶云产品可以享受5折优惠，送手机、送话费，好礼不断！

上传图片

use AcctCtl_KEE

--备份

select * into t_ad_kdAccount_gl_bak from t_ad_kdAccount_gl

--查看这几个数据有没有重复的值，这三个字段需要均为1，非1的，修改到不重复为止

select COUNT(FAcctName),FAcctName from t_ad_kdAccount_gl group by FAcctName

select COUNT(FAcctNumber),FAcctNumber from t_ad_kdAccount_gl group by FAcctNumber

select COUNT(FAcctID),FAcctID from t_ad_kdAccount_gl group by FAcctID

--把缺少信息单元格填充

select FVersion，* from t_ad_kdAccount_gl where FVersion=null

select FNodeID，* from t_ad_kdAccount_gl where FNodeID=0

update t_ad_kdAccount_gl set FNodeID=1 where FNodeID=0

update t_ad_kdAccount_gl set FVersion=‘5.0.01.23 where FVersion=null

--5.0.01.23替换为实际的版本号