列名'ginvpicture'无效

千签恋

T63.3版本，已更新最新补丁和脚本。
查询采购入库单列表爆错，提示：列名'ginvpicture'无效。确定后，表体内容为空，表头位置显示记录总数。


用事件探查器跟踪后有。。。无非因为是跟这个字段有关系
  这个是执行后的结果，跟软件提示一样。。

我把语句贴上。。。
大家帮忙讨论下。。。
Select '' as SelCol,ID,bRdFlag,cVouchType,cBusType,cSource,cBusCode,cWhCode,cWhName,dDate,cCode,cRdCode,cRdName,cDepCode,cDepName,cPersonCode,cPersonName,cPTCode,cPTName,cVenCode,cVenAbbName,cOrderCode,cARVCode,cBillCode,cMemo,cMaker,cHandler,cAccounter,AutoID,ID_1,cInvCode,cInvAddCode,cInvName,cInvStd,cInvM_Unit,cInvA_Unit,(case when bService=1 then '是' else '否' end) as bService,cInvCCode,iInvExchRate,(case when bInvBatch=1 then '是' else '否' end) as bInvBatch,cItemCode,iNum,iQuantity,cItem_class,cName,iUnitCost,iPrice,cItemCName,iAPrice,iPUnitCost,iPPrice,cBatch,ipresent,iavanum,iavaquantity,cVouchCode,iFlag,dSDate,iMoney,iSOutQuantity,iSOutNum,iFNum,iFQuantity,dVDate,cReplaceItem,cPosition,dVeriDate,ipurorderid,ipurarriveid,iproorderid,iarriveid,isalebillid,iMPoIds,imassdate,cInVouchCode,iId,VT_ID,dARVDate,cAssUnit,iNNum,iNQuantity,cposname,gspcheck,cbarcode,dmadedate,facost,isquantity,iarrsid,cDefine1,cDefine2,cDefine3,cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10,cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,cInvDefine1,cInvDefine2,cInvDefine3,cInvDefine4,cInvDefine5,cInvDefine6,cInvDefine7,cInvDefine8,cInvDefine9,cInvDefine10,cInvDefine11,cInvDefine12,cInvDefine13,cInvDefine14,cInvDefine15,cInvDefine16,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,ufts,ccheckcode,ccheckpersoncode,ccheckpersonname,dcheckdate,crejtext,cqmintype,iTaxRate,iTaxCost,iTaxPrice,iSum,cvendefine1,cvendefine2,cvendefine3,cvendefine4,cvendefine5,cvendefine7,cvendefine8,cvendefine6,cvendefine9,cvendefine10,cvendefine11,cvendefine12,cvendefine13,cvendefine14,cvendefine15,cvendefine16,cbvendefine1,cbvendefine2,cbvendefine3,cbvendefine4,cbvendefine5,cbvendefine7,cbvendefine8,cbvendefine6,cbvendefine9,cbvendefine10,cbvendefine11,cbvendefine12,cbvendefine13,cbvendefine14,cbvendefine15,cbvendefine16,caccountpname,caccountpdate,cPayName,ginvpicture,cveninvcode,cveninvname,(NULL) as cAccountPID From zpurRkdList WHERE isnull(bPuFirst,0)<> 1 AND dDate >= '2009-01-01' AND (dDate>='2009-05-22' and  dDate<='2009-05-22') and (AutoId  In (407374,407375,407741,407742,407743,407744,407753,407754,407755,407756,407757,407759,407760,407761,407762,407768,407769,407770,407771,407772,407773,407774,407775,407776,408043,408049)) Order by AutoId

sexman

处理的完整过程:
公司没有T6 3.3的货到，只好装个3.2plus顶一顶，改下版本号一样用，反正只是看部分功能啦
1、虽然是有错误提示，但是仍然可以打开单据列表的窗体，点开“栏目”，可以看到“图片”这个被加深颜色的列
想一想就觉得有问题啦，怎么可能在单据列表里有图片嘛！


2、小千版主跟踪没注意到这一条，这才是要找的表！AA_ColumnDic，在T3系列里面叫vouchlist，哈哈，我以为T6和T3是一样的，这是所有单据列表的字段表。
并且我们可以发现ckey=24,就是采购单列表的字段清单


3、找到它就好办了，打开sql查询器，干掉这个记录


4、进T6看看，正常了


小千MM快来个飞吻，哈哈

oklala

sexman 发表于 2009-9-28 22:05
如果找不到
那证明该字段不存在
或只是个别名或临时表的字段

如果找不到怎么办呢 到相应的表去删除？

zhj8152002

头晕

千秋雅

...........楼主问题我也遇到。。。期待答复

千签恋

...........楼主问题我也遇到。。。期待答复
千秋雅 发表于 2009-9-28 13:36

                               
登录/注册后可看大图

我说这位。。。这个问题你也遇到过？？看来你遇到这个问题比我早嘛，说来听听 那你怎么解决的。。
不要说你没给客户解决。

hanuff

我遇到的也是查询单据报列名，但跟你这个列名名字不一样。后来又打了个3.3plus1的补丁，没用升级脚本，用的系统管理里面的升级sql2000数据解决的，楼主要不试下

zhj8152002

zpurRklist 是入库单列表视图  找个正常帐套你对比一下 ginvpicture 字段别名的属性

千签恋

视图运行正确，没爆错。

千签恋

我遇到的也是查询单据报列名，但跟你这个列名名字不一样。后来又打了个3.3plus1的补丁，没用升级脚本，用的系统管理里面的升级sql2000数据解决的，楼主要不试下
hanuff 发表于 2009-9-28 15:27

                               
登录/注册后可看大图

我也打了3.3PLUS1的补丁，不过很可惜，我执行了脚本。然后就报这个错了。
而且没备份。十来套帐各个年度。。。都执行了脚本

我是给我同事去收场的。。。。。

千签恋

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO




ALTER     VIEW dbo.zpurrkdlist  
AS  
SELECT dbo.zpurrkdhead.id, dbo.zpurrkdhead.brdflag, dbo.zpurrkdhead.cvouchtype,   
      dbo.zpurrkdhead.cbustype, dbo.zpurrkdhead.csource, dbo.zpurrkdhead.cbuscode,   
      dbo.zpurrkdhead.cwhcode, dbo.zpurrkdhead.cwhname, dbo.zpurrkdhead.ddate,   
      dbo.zpurrkdhead.ccode, dbo.zpurrkdhead.crdcode, dbo.zpurrkdhead.crdname,   
      dbo.zpurrkdhead.cdepcode, dbo.zpurrkdhead.cdepname,   
      dbo.zpurrkdhead.cpersoncode, dbo.zpurrkdhead.cpersonname,   
      dbo.zpurrkdhead.cptcode, dbo.zpurrkdhead.cptname,
      dbo.zpurrkdhead.cvencode, dbo.zpurrkdhead.cvenabbname,
      dbo.zpurrkdhead.cvendefine1,dbo.zpurrkdhead.cvendefine2,dbo.zpurrkdhead.cvendefine3,
      dbo.zpurrkdhead.cvendefine4,dbo.zpurrkdhead.cvendefine5,dbo.zpurrkdhead.cvendefine6,
      dbo.zpurrkdhead.cvendefine7,dbo.zpurrkdhead.cvendefine8,dbo.zpurrkdhead.cvendefine9,
      dbo.zpurrkdhead.cvendefine10,dbo.zpurrkdhead.cvendefine11,dbo.zpurrkdhead.cvendefine12,
      dbo.zpurrkdhead.cvendefine13,dbo.zpurrkdhead.cvendefine14,dbo.zpurrkdhead.cvendefine15,
      dbo.zpurrkdhead.cvendefine16,  
      dbo.zpurrkdtail.cordercode,   
      dbo.zpurrkdtail.carvcode, dbo.zpurrkdhead.cbillcode, dbo.zpurrkdhead.cmemo,   
      dbo.zpurrkdhead.chandler, dbo.zpurrkdhead.caccounter, dbo.zpurrkdhead.cmaker,   
      dbo.zpurrkdhead.cdefine1, dbo.zpurrkdhead.cdefine2, dbo.zpurrkdhead.cdefine3,   
      dbo.zpurrkdhead.cdefine4, dbo.zpurrkdhead.cdefine5, dbo.zpurrkdhead.cdefine6,   
      dbo.zpurrkdhead.cdefine7, dbo.zpurrkdhead.cdefine8, dbo.zpurrkdhead.cdefine9,   
      dbo.zpurrkdhead.cdefine10, dbo.zpurrkdhead.bpufirst, dbo.zpurrkdhead.biafirst,   
      dbo.zpurrkdhead.gspcheck, dbo.zpurrkdhead.dveridate, dbo.zpurrkdhead.ipurorderid,   
      dbo.zpurrkdhead.ipurarriveid, dbo.zpurrkdhead.iproorderid,   
      dbo.zpurrkdhead.iarriveid, dbo.zpurrkdhead.isalebillid, dbo.zpurrkdhead.cauthid,  
        zpurrkdhead.caccountpdate,zpurrkdhead.caccountpname,
      dbo.zpurrkdtail.autoid, dbo.zpurrkdtail.id AS id_1, dbo.zpurrkdtail.cinvcode,   
      dbo.zpurrkdtail.cinvaddcode, dbo.zpurrkdtail.cinvname, dbo.zpurrkdtail.cinvstd,   
      dbo.zpurrkdtail.cinvm_unit, dbo.zpurrkdtail.cinva_unit, dbo.zpurrkdtail.bservice,   
      dbo.zpurrkdtail.cinvccode, dbo.zpurrkdtail.iinvexchrate, dbo.zpurrkdtail.binvbatch,   
      dbo.zpurrkdtail.inum, dbo.zpurrkdtail.iquantity, dbo.zpurrkdtail.iunitcost,   
      dbo.zpurrkdtail.iprice, dbo.zpurrkdtail.iaprice, dbo.zpurrkdtail.ipunitcost,   
      dbo.zpurrkdtail.ipprice, dbo.zpurrkdtail.cbatch, dbo.zpurrkdtail.cvouchcode,   
      dbo.zpurrkdtail.cfree1, dbo.zpurrkdtail.cfree2, dbo.zpurrkdtail.iflag,   
      dbo.zpurrkdtail.dsdate, dbo.zpurrkdtail.itax, dbo.zpurrkdtail.isquantity,   
      dbo.zpurrkdtail.isnum, dbo.zpurrkdtail.imoney, dbo.zpurrkdtail.isoutquantity,   
      dbo.zpurrkdtail.isoutnum, dbo.zpurrkdtail.ifnum, dbo.zpurrkdtail.ifquantity,   
      dbo.zpurrkdtail.dvdate, dbo.zpurrkdtail.creplaceitem, dbo.zpurrkdtail.cposition,   
      dbo.zpurrkdtail.cinvdefine1, dbo.zpurrkdtail.cinvdefine2, dbo.zpurrkdtail.cinvdefine3,   
      dbo.zpurrkdtail.cdefine22, dbo.zpurrkdtail.cdefine23, dbo.zpurrkdtail.cdefine24,   
      dbo.zpurrkdtail.cdefine25, dbo.zpurrkdtail.cdefine26, dbo.zpurrkdtail.cdefine27,   
      dbo.zpurrkdtail.citem_class, dbo.zpurrkdtail.citemcode, dbo.zpurrkdtail.iposid,   
      dbo.zpurrkdtail.facost, dbo.zpurrkdtail.cname, dbo.zpurrkdtail.citemcname,   
      dbo.zpurrkdhead.vt_id, dbo.zpurrkdhead.bisstqc, dbo.zpurrkdhead.cchkperson,   
      dbo.zpurrkdhead.cdefine11, dbo.zpurrkdhead.cdefine12, dbo.zpurrkdhead.cdefine13,   
      dbo.zpurrkdhead.cdefine14, dbo.zpurrkdhead.cdefine15, dbo.zpurrkdhead.cdefine16,   
      dbo.zpurrkdhead.imquantity AS expr1, dbo.zpurrkdhead.ufts, dbo.zpurrkdtail.cfree3,   
      dbo.zpurrkdtail.cfree4, dbo.zpurrkdtail.cfree5, dbo.zpurrkdtail.cfree6,   
      dbo.zpurrkdtail.cfree7, dbo.zpurrkdtail.cfree8, dbo.zpurrkdtail.cfree9,   
      dbo.zpurrkdtail.cfree10, dbo.zpurrkdtail.inquantity, dbo.zpurrkdtail.innum,   
      dbo.zpurrkdtail.dmadedate, dbo.zpurrkdtail.iinvmpcost, dbo.zpurrkdtail.cdefine28,   
      dbo.zpurrkdtail.cdefine29, dbo.zpurrkdtail.cdefine30, dbo.zpurrkdtail.cdefine31,   
      dbo.zpurrkdtail.cdefine32, dbo.zpurrkdtail.cdefine33, dbo.zpurrkdtail.cdefine34,   
      dbo.zpurrkdtail.cdefine35, dbo.zpurrkdtail.cdefine36, dbo.zpurrkdtail.cdefine37,   
      dbo.zpurrkdtail.impoids, dbo.zpurrkdtail.icheckids, dbo.zpurrkdtail.cinvdefine4,   
      dbo.zpurrkdtail.cinvdefine5, dbo.zpurrkdtail.cinvdefine6, dbo.zpurrkdtail.cinvdefine7,   
      dbo.zpurrkdtail.cinvdefine8, dbo.zpurrkdtail.cinvdefine9, dbo.zpurrkdtail.cinvdefine10,   
      dbo.zpurrkdtail.cinvdefine11, dbo.zpurrkdtail.cinvdefine12,   
      dbo.zpurrkdtail.cinvdefine13, dbo.zpurrkdtail.cinvdefine14,   
      dbo.zpurrkdtail.cinvdefine15, dbo.zpurrkdtail.cinvdefine16, dbo.zpurrkdtail.iid,   
      dbo.zpurrkdtail.binvtype, dbo.zpurrkdhead.dkeepdate, dbo.zpurrkdhead.dchkdate,   
      dbo.zpurrkdhead.cchkcode, dbo.zpurrkdhead.darvdate, dbo.zpurrkdhead.ccuscode,   
      dbo.zpurrkdhead.cstcode, dbo.zpurrkdtail.cbarcode, dbo.zpurrkdtail.cassunit,   
      dbo.zpurrkdtail.cbvencode, dbo.zpurrkdtail.cvenname,
      dbo.zpurrkdtail.cvendefine1 as cbvendefine1,dbo.zpurrkdtail.cvendefine2 as cbvendefine2,
      dbo.zpurrkdtail.cvendefine3 as cbvendefine3,dbo.zpurrkdtail.cvendefine4 as cbvendefine4,
      dbo.zpurrkdtail.cvendefine5 as cbvendefine5,dbo.zpurrkdtail.cvendefine6 as cbvendefine6,
      dbo.zpurrkdtail.cvendefine7 as cbvendefine7,dbo.zpurrkdtail.cvendefine8 as cbvendefine8,
      dbo.zpurrkdtail.cvendefine9 as cbvendefine9,dbo.zpurrkdtail.cvendefine10 as cbvendefine10,
      dbo.zpurrkdtail.cvendefine11 as cbvendefine11,dbo.zpurrkdtail.cvendefine12 as cbvendefine12,
      dbo.zpurrkdtail.cvendefine13 as cbvendefine13,dbo.zpurrkdtail.cvendefine14 as cbvendefine14,
      dbo.zpurrkdtail.cvendefine15 as cbvendefine15,dbo.zpurrkdtail.cvendefine16 as cbvendefine16,  
      dbo.zpurrkdtail.imassdate,   
      dbo.zpurrkdtail.cgspstate, dbo.zpurrkdtail.iarrsid, dbo.zpurrkdtail.cinvouchcode,   
      dbo.zpurrkdtail.cposname, dbo.zpurrkdtail.ccheckcode, dbo.zpurrkdtail.icheckidbaks,   
      dbo.zpurrkdtail.crejectcode, dbo.zpurrkdtail.irejectids,   
      dbo.zpurrkdtail.ccheckpersoncode, dbo.zpurrkdtail.ccheckpersonname, dbo.zpurrkdtail.dcheckdate,  
dbo.zpurrkdtail.ichkautoid,   
dbo.zpurrkdtail.irejid,  
dbo.zpurrkdtail.crejtext,  
dbo.zpurrkdtail.cqmintype,  
dbo.zpurrkdtail.iarrptrintype,  
dbo.PayCondition.cPayName,
dbo.zpurrkdtail.itaxrate,dbo.zpurrkdtail.itaxprice,dbo.zpurrkdtail.itaxcost,dbo.zpurrkdtail.isum,
zpurrkdtail.cveninvcode,zpurrkdtail.cveninvname

        ,' ' as ipresent                --为了在数据权限中添加现存量字段，需要修改对应的列表视图 ForSupportQuestion_20136 huangwx 2009-1-19 17.02
   ,' ' as iavaquantity,' ' as iavanum
FROM dbo.zpurrkdhead LEFT OUTER JOIN  
      dbo.zpurrkdtail ON dbo.zpurrkdhead.id = dbo.zpurrkdtail.id  LEFT OUTER JOIN
      dbo.PayCondition ON dbo.zpurrkdhead.cpaycode = dbo.PayCondition.cPayCode




GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
这是视图，呵呵，我查过了。没问题。。然后不知道要往哪查了

sexman

从字面上理解---我没耐心看这么长的代码哈
这个是“商品图片”的字段
inventory picture

sexman

第一楼的语句粗看了下
上面的语句根本没提到ginvpicture
既然是单据列表出的错，这个就容易了---单据没问题吧，我是说是否能正常打开？
我们进入单据列表相关的表
把这个ginvpicture做掉就行了
理论上应该如此
小千千给点好处
我帮你远远瞧瞧怎么样？
比如发点点数吧

千签恋

给个飞吻行不。哈哈。
累死人了。。刚回来。我都没来得及看数据

千签恋

其实sexman说的我也不是没考虑过。。。不过嘛。。
执行的结果又是让我很失误。。。
use UFDATA_001_2009
alter table RdRecord drop column ginvpicture
除了RdRecord 表，我还试了RdRecords 、INVENTORY都是令人失误的勒。。。

sexman

晕
哪有这样找字段的
你应该这样找：
select * from   syscolumns
where name='ginvpicture'
得到ID号

然后再找
select * from sysobjects
where id=....

写成一句也行哈

sexman

如果找不到
那证明该字段不存在
或只是个别名或临时表的字段