| 問題現(xiàn)象: |
在結(jié)轉(zhuǎn)上年購銷存時，畫面停留在存貨價格表，提示銷售系統(tǒng)結(jié)轉(zhuǎn)失敗，用事件查看器觀察，在執(zhí)行如下語句時提示錯誤INSERT 語句與 FOREIGN KEY 約束"FK_InvUPrice_Inventory"沖突。該沖突發(fā)生于數(shù)據(jù)庫"UFDATA_001_2012"，表"dbo.Inventory", column 'cInvCode'。
Insert into SA_InvUPrice(cInvCode,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,iUPrice1,iUPrice2,iUPrice3,iInvSCost,iInvSaleCost,cMemo,dStartDate,dEndDate,ISalePrice1,ISalePrice2,ISalePrice3,IUPrice4,ISalePrice4,IUPrice5,ISalePrice5,IUPrice6,ISalePrice6,IUPrice7,ISalePrice7,IUPrice8,ISalePrice8,IUPrice9,ISalePrice9,IUPrice10,ISalePrice10,cDesc) Select cInvCode,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,iUPrice1,iUPrice2,iUPrice3,iInvSCost,iInvSaleCost,cMemo,dStartDate,dEndDate,ISalePrice1,ISalePrice2,ISalePrice3,IUPrice4,ISalePrice4,IUPrice5,ISalePrice5,IUPrice6,ISalePrice6,IUPrice7,ISalePrice7,IUPrice8,ISalePrice8,IUPrice9,ISalePrice9,IUPrice10,ISalePrice10,cDesc From UFDATA_001_2011..SA_InvUPrice
|
| 原因分析: |
在結(jié)轉(zhuǎn)上年購銷存時，畫面停留在存貨價格表，提示銷售系統(tǒng)結(jié)轉(zhuǎn)失敗，用事件查看器觀察，在執(zhí)行如下語句時提示錯誤INSERT 語句與 FOREIGN KEY 約束"FK_InvUPrice_Inventory"沖突。該沖突發(fā)生于數(shù)據(jù)庫"UFDATA_001_2012"，表"dbo.Inventory", column 'cInvCode'。
Insert into SA_InvUPrice(cInvCode,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,iUPrice1,iUPrice2,iUPrice3,iInvSCost,iInvSaleCost,cMemo,dStartDate,dEndDate,ISalePrice1,ISalePrice2,ISalePrice3,IUPrice4,ISalePrice4,IUPrice5,ISalePrice5,IUPrice6,ISalePrice6,IUPrice7,ISalePrice7,IUPrice8,ISalePrice8,IUPrice9,ISalePrice9,IUPrice10,ISalePrice10,cDesc) Select cInvCode,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,iUPrice1,iUPrice2,iUPrice3,iInvSCost,iInvSaleCost,cMemo,dStartDate,dEndDate,ISalePrice1,ISalePrice2,ISalePrice3,IUPrice4,ISalePrice4,IUPrice5,ISalePrice5,IUPrice6,ISalePrice6,IUPrice7,ISalePrice7,IUPrice8,ISalePrice8,IUPrice9,ISalePrice9,IUPrice10,ISalePrice10,cDesc From UFDATA_001_2011..SA_InvUPrice
|
