如何在 ACE 报表打印程序中使用 字段连接?
我们可以在 informix 的 dbaccess 或者ec 程序 的 sql 语句使用连接字段完成查询任务,如:select dqdh ||jgdh asdqjg ,zhdh, jyjefrom zwk:cpwj
但是, 如果将连接字段 || 操作使用在ace 程序,则 无法完成程序编译,请问有什么解决方法?
<code>
select
zhdh (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
fromzwk: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>
页:
[1]