Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共2 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

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

1楼
许给谁的一世欢颜 发表于: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楼
狐狸爸爸 发表于:2011/12/7 14:24:00

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

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

 

共2 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .02710 s, 2 queries.