U872年结，结转应付模块过程中报错

cheng1719

应收应付结转 : 结转收付款单时失败，原因为[INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_Ap_CloseBills_Ap_CloseBill' 冲突。该冲突发生于数据库 'UFDATA_001_2014'，表 'Ap_CloseBill', column 'iID'。]

cheng1719

数据库 用的是sql2000

bjchenxun

插入的iid字段值有重复，建议跟踪一下语句

cheng1719

bjchenxun 发表于 2014-1-7 10:58
插入的iid字段值有重复，建议跟踪一下语句

insert into ap_closebill(iID,ID,iType,bPrePay,cCusVen,iAmt_f,iAmt,iRAmt_f,iRAmt,cKm,cXmClass,cXm,cDepCode,cPersonCode,cOrderID,cItemName,cConType,cConID,iAmt_s,iRAmt_s,iOrderType,cDLCode,ccItemCode,RegisterFlag,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,cStageCode,cCoVouchID) select iID,ID,iType,bPrePay,cCusVen,iAmt_f,iAmt,iRAmt_f,iRAmt,cKm,cXmClass,cXm,cDepCode,cPersonCode,cOrderID,cItemName,cConType,cConID,iAmt_s,iRAmt_s,iOrderType,cDLCode,ccItemCode,RegisterFlag,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,cStageCode,cCoVouchID from UFDATA_001_2013..ap_closebills where id not in (select id from ap_closebills)

VictorCl112

我们这里马上年结啦。  学习了。

bjchenxun

select * from ufdata_001_2013..ap_closebills where iID in ( select iid from ufdata_001_2013..ap_closebills where id not in (select id from ufdata_001_2014..ap_closebills) group by iid having count(iid)>1)
这个语句就可以找出你要插入的记录的重复iid字段的数据行

你发的语句我看不懂要干啥，为啥要将2013年的收付款子表中不包含2014年收付款子表id的记录插入到2014年的收付款主表记录中呢？？？

cheng1719

bjchenxun 发表于 2014-1-9 22:39
select * from ufdata_001_2013..ap_closebills where iID in ( select iid from ufdata_001_2013..ap_clos ...

这是年结中的报错内容。。u872 版本的

hangbing5560

应当是数据有重复