|
版本: |
其它(帖子中说明) |
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 其它 |
浏览器: |
Chrome |
|
|
Bex5 V3.7 在使用KSQL编辑器时使用substring函数报错:select SA_OPPerson,SA_OPPerson.sName as sName,SA_OPPerson.sCode as sCode, substring(SA_OPPerson.sMobilePhone,-4,4) as sMobilePhone from SA_OPPerson SA_OPPerson
控制台打印KSQL语句:
exec KSQL: select SA_OPPerson,SA_OPPerson.sName as sName,SA_OPPerson.sCode as sCode, substring(SA_OPPerson.sMobilePhone,-4,4) as sMobilePhone from SA_OPPerson SA_OPPerson LIMIT 0, 50
--> sql:SELECT SA_OPPerson.sID, SA_OPPerson.SNAME AS sName, SA_OPPerson.SCODE AS sCode, SUBSTR(SA_OPPerson.SMOBILEPHONE, ?, ?) AS sMobilePhone FROM SA_OPPerson SA_OPPerson
--> binds:[-4, 4]
请问什么问题?谢谢
|
|