找回密码
 注册账号

QQ登录

只需一步,快速开始

手机号码,快捷登录

手机号码,快捷登录

初学者课程:T3自学|T6自学|U8自学软件下载课件下载工具下载资料:通资料|U8资料|NC|培训|年结积分规则 | 使用常见问题Q&A
知识库:U8 | | NC | U9 | OA | 政务U8|U9|NCC|NC65|NC65客开|NCC客开新手必读 | 任务 | 快速增金币用友QQ群[微信群]
查看: 2484|回复: 0

[求助] u812升级U852时,库存出错

[复制链接]
发表于 2010-1-6 17:20:55 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?注册账号

×
升级到库存时候,提示:

--------------------------
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
您需要登录后才可以回帖 登录 | 注册账号

本版积分规则

QQ|站长微信|Archiver|手机版|小黑屋|用友之家 ( 蜀ICP备07505338号|51072502110008 )

GMT+8, 2024-11-29 02:55 , Processed in 0.057618 second(s), 9 queries , Gzip On, Redis On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表