我的sql
(在开发的单据上打开的,具体的不附上单据的设计了)
----------------------------begin
select
t0_L.FName 'AA000',
t4_L.FName 'AA001',
t5_L.FName 'AA002',
convert(decimal(18,2),t7.F_JiBenGongZi) 'AA003',
t7.F_YueFen 'AA004',
convert(decimal(18,2),t7.F_JiBenGongZi1) 'AA005',
convert(decimal(18,2),t7.F_YueDuJiXiaoGongZi) 'AA006',
t7.F_YYueFen 'AA007',
convert(decimal(18,2),t7.F_YueDuJiXiaoGongZiHeJi) 'AA008',
convert(decimal(18,2),t7.F_JiDuJiXiaoGongZi) 'AA009',
t7.F_JiFen 'AA010',
convert(decimal(18,2),t7.F_JiDuJiXiaoGongZiHeJi) 'AA011',
convert(decimal(18,2),t7.F_CanBuBiaoZhun) 'AA012',
t7.F_CYueFen 'AA013',
convert(decimal(18,2),t7.F_CanBuBiaoZhunHeJi) 'AA014',
convert(decimal(18,2),t7.F_JiaoTongBuTieBiaoZhun) 'AA015',
t7.F_JYueFen 'AA016',
convert(decimal(18,2),t7.F_JiaoTongBuTieBiaoZhunHeJi) 'AA017',
convert(decimal(18,2),t7.F_NianZhongHongBao) 'AA018',
convert(decimal(18,2),t7.F_NianDuGeRenShouRuHeJi) 'AA019',
convert(decimal(18,2),t7.F_YangLaoShiYeShengYu) 'AA020',
convert(decimal(18,2),t7.F_GongShang) 'AA021',
convert(decimal(18,2),t7.F_SheBaoHeJi) 'AA022',
t7.F_SYueFen 'AA023',
convert(decimal(18,2),t7.F_SheBaoZongJi) 'AA024',
convert(decimal(18,2),t7.F_BanShiChuFeiYong) 'AA025',
t7.F_BSCYueFen 'AA026',
convert(decimal(18,2),t7.F_BanShiChuFeiYongHeJi) 'AA027',
convert(decimal(18,2),t7.F_YeWuChePiao) 'AA028',
t7.F_YWYueFen 'AA029',
convert(decimal(18,2),t7.F_YeWuChePiaoHeJi) 'AA030',
convert(decimal(18,2),t7.F_TanQinChePiao) 'AA031',
t7.F_TQCiShu 'AA032',
convert(decimal(18,2),t7.F_TanQinChePiaoHeJi) 'AA033',
convert(decimal(18,2),t7.F_DianHuaFei) 'AA034',
t7.F_DHYueFen 'AA035',
convert(decimal(18,2),t7.F_DianHuaFeiHeJi) 'AA036',
convert(decimal(18,2),t7.F_ZhuSuFei) 'AA037',
t7.F_ZSTianShu 'AA038',
convert(decimal(18,2),t7.F_ZhuSuFeiHeJi) 'AA039',
convert(decimal(18,2),t7.F_HuiWuZhuSu) 'AA040',
convert(decimal(18,2),t7.F_HuiWuCanBu) 'AA041',
t7.F_HWTianShu 'AA042',
convert(decimal(18,2),t7.F_huiwuhejiHeJi) 'AA043',
convert(decimal(18,2),t7.F_NianDuGeRenKaiZhiHeJi) 'AA044',
convert(decimal(18,2),t7.F_ZongJi) 'AA045'
from
t_RenYuanNianDuyYuSuan_Head t7 inner join T_BD_OPERATORENTRY t6 on t6.fentryid=t7.F_yg and t7.Fuseorgid=100001
inner join T_BD_STAFF t1 on t6.Fstaffid=t1.Fstaffid
inner join t_bd_stafftemp t2 on t1.Fpostid=t2.Fpostid and t2.Fisfirstpost=1
inner join T_BD_DEPARTMENT_L t4_L on t7.F_BM=t4_L.Fdeptid
inner join T_ORG_POST_L t5_L on t5_L.fpostid=t2.fpostid
inner join T_HR_EMPINFO_L t0_L on t1.FEmpinfoid=t0_L.FID
----------------------------end
问题
本地sql查询执行,ok
本地k3cloud打开,ok
客户sql查询执行,ok
客户k3cloud打开,出现以下错
打开sql报表,出现
not support token:Kingdee.BOS.SQL.Parser.Token
[{"operation":"fe815eec-2a7e-4660-86c7-4f9484b36870.GetReportData"}]
发生时间:09:14:12
错误来源: Kingdee.BOS.SQL
错误信息:not support token:Kingdee.BOS.SQL.Parser.Token
===================================================
调用堆栈:
at Kingdee.BOS.SQL.Parser.SelectParser.select(Boolean parseOrderBy)
at Kingdee.BOS.SQL.Parser.SelectParser.select(Boolean parseOrderBy)
at Kingdee.BOS.SQL.Parser.SqlStmtParser.select()
at Kingdee.BOS.SQL.Parser.SqlStmtParser.stmt()
at Kingdee.BOS.SQL.Parser.SqlStmtParser.stmtList(IList stmtCol, Token tok)
at Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)
错误数据: System.Collections.ListDictionaryInternal
推荐阅读