金蝶KIS专业版提示“违反primary key 约束,不能插入重复键”
总账反结账后重新结账时提示“违反primary key 约束,不能插入重复键”
执行语句: delete from t_balance where (fperiod>当前期间 and fyear=当前年度) or fyear>当前年度 delete from t_quantitybalance where (fperiod>当前期间 and fyear= 当前年度) or fyear>当前年度 delete from t_profitandloss where (fperiod>当前期间 and fyear= 当前年度) or fyear>当前年度
|