商贸高级版6.0结账时提示结账错误,违反了 PRIMARY KEY 约束

hcl1986620

1,444次浏览编辑于2015年09月11日 16:20:11

商贸高级版6.0结账时提示结账错误,违反了 PRIMARY KEY 约束，执行以下语句select fyear,fperiod,fstockid,fitemid,fbatchno from t_cc_bal group by fyear,fperiod,fstockid,fitemid,fbatchno having count(*)>1