存货核算结算成本处理提示“运行时错误13,类型不匹配”

半度空间

运行环境：windows XP SP3+sql2000sp4
求解决办法！

原因分析：
经跟踪代码发现，存货表inventory数据中存在tab键，可能是存货名称中有问题。

解决办法：
请使用附件工具“非法字符检测工具”对存货表inventory尾部的控制字符进行检测，修复即可。

zhanghucupite

需要跟踪下

半度空间

回复 2# zhanghucupite
跟踪结果，高手帮看看！
SET NO_BROWSETABLE ON
go
SELECT MAX(iPeriod) AS CurMonth FROM GL_mEnd WHERE bFlag_IA=1
go
SET NO_BROWSETABLE ON
go
declare @P1 int
set @P1=1
exec sp_prepare @P1 output, NULL, N'SELECT * FROM GL_mEnd', 1
select @P1
go
exec sp_reset_connection
go
Select dBegin,dEnd from UA_Period where cAcc_ID='006' and iYear=2010 and iID=8
go
SET NO_BROWSETABLE ON
go
SELECT MAX(iPeriod) AS CurMonth FROM GL_mEnd WHERE bFlag_IA=1
go
SET NO_BROWSETABLE ON
go
declare @P1 int
set @P1=1
exec sp_prepare @P1 output, NULL, N'SELECT * FROM GL_mEnd', 1
select @P1
go
SELECT  IA_EstiSettle.PSVID, IA_EstiSettle.ID, IA_EstiSettle.iRdID,IA_EstiSettle.iRdsid, ' ' AS 表达式1,IA_EstiSettle.cSVCode, IA_EstiSettle.cWhCode, IA_EstiSettle.cWhName,IA_EstiSettle.cPIVCode, IA_EstiSettle.DDATE, IA_EstiSettle.cInvCode,IA_EstiSettle.cInvName, IA_EstiSettle.cInvM_Unit, LTRIM(STR(IA_EstiSettle.iSVQuantity,20,2)),LTRIM(STR((Case When IsNull(IA_EstiSettle.iRdsid,0)<>0 then(case when isnull(ia_subsidiary.iainquantity,0)=0 then 0 else (isnull(ia_subsidiary.iainprice,0)+-1*isnull(ia_subsidiary.iCreditDifCost,0))/ia_subsidiary.iainquantity end)else ia_estisettle.isvacost end),20,6)), LTRIM(STR((Case When Isnull(IA_EstiSettle.iRdsid,0)<>0 then IsNull(IA_EstiSettle.iSVQuantity,0)*(case when isnull(ia_subsidiary.iainquantity,0)=0 then 0 else (isnull(ia_subsidiary.iainprice,0)+-1*isnull(ia_subsidiary.iCreditDifCost,0))/ia_subsidiary.iainquantity end) Else ISNULL(IA_EstiSettle.iSVAPrice,0) End),20,2)), LTRIM(STR((case when ( isnull(IA_EstiSettle.iSVCost,0)=0 and isnull(IA_EstiSettle.iSVPrice,0)<>0) then 0 else (isnull(IA_EstiSettle.iSVQuantity,0)) end),20,2)),LTRIM(STR((case when isnull(IA_EstiSettle.iSVQuantity,0)=0 then 0 else (isnull(IA_EstiSettle.iSVPrice,0)/isnull(IA_EstiSettle.iSVQuantity,0)) end),20,6)),LTRIM(STR(IA_EstiSettle.iSVPrice,20,2)),IA_EstiSettle.ibsid,IA_EstiSettle.cRdCode, IA_EstiSettle.cRdName,IA_EstiSettle.cFree1,IA_EstiSettle.cFree2,IA_EstiSettle.cFree3, IA_EstiSettle.cFree4,IA_EstiSettle.cFree5, IA_EstiSettle.cFree6,IA_EstiSettle.cFree7, IA_EstiSettle.cFree8,IA_EstiSettle.cFree9, IA_EstiSettle.cFree10   FROM (((((IA_EstiSettle INNER JOIN Inventory ON IA_EstiSettle.cInvCode = Inventory.cInvCode) left Join PurBillVouchs On IA_EstiSettle.iBSid=PurBillVouchs.Id) Left JOIN RdRecords ON IA_EstiSettle.iRdsID = RdRecords.AutoID)left join ia_subsidiary on rdrecords.autoid=ia_subsidiary.id)left join rdrecord on rdrecords.id=rdrecord.id) WHERE (((Purbillvouchs.bExBill=1 and isnull(IA_EstiSettle.iRdsid,0)=0)  or (Purbillvouchs.bExBill=1 and isnull(IA_EstiSettle.iRdsid,0)<>0 and (ia_subsidiary.cvoutype='01' or ia_subsidiary.cvoutype='33'))) or (isnull(IA_EstiSettle.iRdsid,0)<>0 and (ia_subsidiary.cvoutype='01' or ia_subsidiary.cvoutype='33'))) and IA_EstiSettle.dSVDate<='2010-08-31'  AND (IA_EstiSettle.bAccount=0) and (isnull(IA_EstiSettle.iSVQuantity,0)<>0 or isnull(IA_EstiSettle.iSVPrice,0)<>0)  AND ((Purbillvouchs.bExBill=1) or (rdrecord.cbustype='受托代销' or (rdrecord.cbustype<>'受托代销' and rdrecords.dsdate<='2010-08-31')))   AND ((RIGHT(IA_EstiSettle.cMonth,2)<'08') OR (IA_EstiSettle.cMonth is null)) and ia_subsidiary.bflag<>2  AND IA_EstiSettle.cWhCode IN ('001') order by IA_EstiSettle.PSVID,IA_EstiSettle.ID,ia_subsidiary.bflag desc,IA_EstiSettle.cWhCode,IA_EstiSettle.cCode
go

dengxh

这个要具体看select 语句了。细心看。

zkang0206

这个问题暂时没有遇到过

  以后会留意的  呵呵

半度空间

晕，客户的单据是从自己的ERP导入的，不知道会不会是这个问题。数据已经传集团，集团电话回复说检查了没问题，现在把问题转由开发了，期待处理结果！

afeimizhou

下载附件 回家研究

afeimizhou

为啥我下载回复了之后还金币-1呢  无语了

小呆瓜

路过进来学习下。。。

jfjxb

路过的看不懂
经常听追踪
追踪是怎么回事？？
谁解释下 ！

jfjxb

不好意思 是跟踪 ！！

s05142113

有人解释下跟踪是怎么操作的吗

jfjxb

和同事了解了一下
是SQL 里面的事件探查器
看来寻求论坛不如现场求教啊

zzllk

谢谢提供！！！！

clier

呵呵，这个处理应该是数据问题。只要确保演示账能用，则是数据问题。