|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
升级到库存时候,提示:
--------------------------
UFAccST
---------------------------
INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK__RdRecords__cInvC__7988E3C9' 冲突。该冲突发生于数据库 'UFDATA_001_2001',表 'Inventory', column 'cInvCode'。
---------------------------
确定
---------------------------
我跟踪的语句是:
INSERT INTO RdRecords(AutoID,ID,cInvCode,iNum,iQuantity,iUnitCost,iPrice,iAPrice,iPUnitCost,iPPrice,cBatch,cItemCode,cVouchCode,cFree1,cFree2,iFlag, dSDate,iTax,iSQuantity,iSNum,iMoney,iSOutQuantity,iSOutNum,iFNum,iFQuantity,dVDate,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,iDLsID) SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','d:\WINNT\system32\UFSYSTEM\ZT001\2001\UFDATA.MDB';'admin';'', ' SELECT RdRecords.AutoID, RdRecords.ID, RdRecords.cInvCode, RdRecords.iNum, RdRecords.iQuantity, RdRecords.iUnitCost, RdRecords.iPrice, RdRecords.iAPrice, RdRecords.iPUnitCost, RdRecords.iPPrice, RdRecords.cBatch,RdRecords.cObjCode AS cItemCode, RdRecords.cVouchCode, RdRecords.cFree1, RdRecords.cFree2, RdRecords.iFlag, RdRecords.dSDate, RdRecords.iTax, RdRecords.iSQuantity, RdRecords.iSNum, RdRecords.iMoney, RdRecords.iSOutQuantity,RdRecords.iSOutNum, RdRecords.iFNum, RdRecords.iFQuantity, RdRecords.dVDate, RdRecords.cDefine22, RdRecords.cDefine23, RdRecords.cDefine24, RdRecords.cDefine25, RdRecords.cDefine26, RdRecords.cDefine27, RdRecords.cDisID FROM RdRecord INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID WHERE NOT (cSource = "采购" OR cBillCode IS NOT null OR cDLCode IS NOT null )') AS ARdRecords |
|