以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  [求助]分页加载列名无效  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=14935)

--  作者:许给谁的一世欢颜
--  发布时间:2011/12/7 13:48:00
--  [求助]分页加载列名无效

分页加载,点击下一页,为什么会报:列名“编号”无效呢?

初始加载语句如下:

select DRId as N\'编号\',drmonth+N\'月\'+drDate+N\'日\' as \'日期\',DRInputer as \'录入者\',case when DRIfRemote IS Null then N\'未开始维修\' else case when SUBSTRING(DRIfRemote,DATALENGTH(DRIfRemote)-1,1) = 0 then N\'远程\' else N\'现场\' end end as \'现场/远程\',DRErrorMainModule as \'主模块\',DRErrorAttachModule as \'附属模块\',DRErrorSpecific as \'具体故障\',DRErrorType as \'故障类型\',DRCauseFinal as \'最终原因\',case when DRIfSolvedPro is null then N\'未填写\' else case when SUBSTRING(DRIfSolvedPro,DATALENGTH(DRIfSolvedPro)-1,1) = \'1\' then N\'已解决\' else N\'未解决\' end end as N\'是否解决(处理)\',case when DRIfSolved is null then N\'未填写\' else case when SUBSTRING(DRIfSolved,DATALENGTH(DRIfSolved)-1,1) = 1 then N\'已解决\' else N\'未解决\' end end as N\'是否解决(回访)\',DRServiceEngieer as \'服务工程师\',case when DRCustomAppraise Is null then N\'未开始回访\' else case when SUBSTRING(DRCustomAppraise,DATALENGTH(DRCustomAppraise)-1,1) = 0 then N\'不满意\' when DRCustomAppraise = 1 then N\'一般\' else N\'满意\' end end as \'用户评价\',DRReturnVisitTime as \'回访时间\',DRSuggestion as \'用户建议\',case when DRIfSatisfied Is null then N\'未开始回访\' when DRIfSatisfied = 1 then N\'满意\' else N\'不满意\' end as \'是否满意\',DRDesc as \'备注\' ,BankName as \'银行名称\',ProName as \'省份\',CityName as \'地区\',SerStationName as \'服务站\',case when DROrderStatus = 0 then N\'未开始维修\' when DROrderStatus = 1 then N\'正在进行,正常\' when DROrderStatus = 2 then N\'等待改派\' when DROrderStatus = 3 then N\'维修完成,等待回访\' when DROrderStatus = 4 then N\'完成\' end as N\'任务状态\' from {DailyReport} inner join {EquipInfo} on DRAtmId = EquipAtmId inner join {BankInfo} on BankId = EquipBank inner join {CityInfo} on EquipCity = CityId inner join {ProvinceInfo} on CityPro = ProId inner join {SerStationInfo} on SerStationId = EquipSerStation


--  作者:狐狸爸爸
--  发布时间:2011/12/7 14:24:00
--  

分页加载对于查询表无效:

http://www.foxtable.com/help/topics/2328.htm