query subject definition 问题，

xiaoerp

framework manager，在query subject definition中定义视图时，
不支持substring与left函数，是怎么回事呀？

语句：

• SELECT
• SPFWFL_DM,
• SPFWFL_MC,
• (SUBSTRING (SPFWFL_DM,1,1)||'0000000') AS 大类,
• (CASE WHEN DLBZ<>'Y' THEN SUBSTRING (SPFWFL_DM,1,3)|| '00000' ELSE NULL END) AS 中类,
• (CASE WHEN DLBZ<>'Y' AND ZLBZ <>'Y' THEN SUBSTRING (SPFWFL_DM,1,5)|| '000' ELSE NULL END) AS 小类,
• (CASE WHEN SLBZ='Y' THEN SPFWFL_DM ELSE NULL END) AS 详细类
• FROM
• [XBFX].DM_SPFWFL DM_SPFWFL
• WHERE
• DM_SPFWFL.XYBZ ='Y'
• ORDER BY
• SPFWFL_DM
  

复制代码


错误：


我把
(SUBSTRING (SPFWFL_DM,1,1)||'0000000') AS 大类
  改为
(‘SPFWFL_DM’||'0000000') AS 大类
就正常了

left函数也不能用，有同样的错误