- 论坛徽章:
- 0
|
我们可以在 informix 的 dbaccess 或者 ec 程序 的 sql 语句使用连接字段完成查询任务,
如: select dqdh || jgdh as dqjg , zhdh, jyje from zwk:cpwj
但是, 如果将连接字段 || 操作使用在 ace 程序,则 无法完成程序编译, 请问有什么解决方法?
<code>
select
zhdh[1,5] (select dqdh || jgdh from zwk:dqzb) as zhdh1
#______________________________________^
#
# A typographical error has been found on line 10, character
# 40.
# See error number -8030.
#
#_______________________________________^
#
# A typographical error has been found on line 10, character
# 41.
# See error number -8030.
#
zhdh ,
zhmc ,
zhye
from zwk:dqzb
where jlzt='1'
ORDER BY zhdh
END
FORMAT
#_________________________^
#
# A grammatical error has been found on line 10, character 27.
# The construct is not understandable in its context.
# See error number -8018.
#
#
# A syntax error has occurred.
# See error number -201.
#
</code> |
|