Foxtable(狐表)用户栏目专家坐堂 → [求助]分页加载列名无效


  共有9248人关注过本帖树形打印复制链接

主题:[求助]分页加载列名无效

帅哥哟,离线,有人找我吗?
许给谁的一世欢颜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:婴狐 帖子:5 积分:130 威望:0 精华:0 注册:2011/11/22 12:15:00
[求助]分页加载列名无效  发帖心情 Post By: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


 回到顶部
帅哥哟,离线,有人找我吗?
狐狸爸爸
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:管理员 帖子:47448 积分:251060 威望:0 精华:91 注册:2008/6/17 17:14:00
  发帖心情 Post By:2011/12/7 14:24:00 [只看该作者]

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

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

 


 回到顶部