2 jinxuhan1314 jinxuhan1314 于 2016.01.19 16:49 提问

PB 调用这个数据窗口,报select error:ORA-00936:缺乏表达式

SELECT "L_HYXM"."HYID",

"L_HYXM"."HYXM",

"L_HYXM"."KSDM",

"L_HYXM"."DJ",

"L_HYXM"."SYXM",

"L_HYXM"."SL",

"L_HYXM"."YLXH",

"L_HYXM"."SRM1",

"L_HYXM"."SRM2",

"L_HYXM"."SRM3",

"L_HYXM"."INUREDATE",

"L_HYXM"."OPERATOR",

"L_HYXM"."FLAG",

"L_HYXM"."NOTE",

"L_HYXM"."DEFRESULT",

"L_HYXM"."EMERGENCY",

"L_HYXM"."SFXM",

"L_HYXM"."XMDH",

"L_HYXM"."XMXH",

"L_HYXM"."YBLX",

"L_HYXM"."BGSJ_DD",

"L_HYXM"."DJSJ_DD",

"L_HYXM"."USEDNOW",

"L_HYXM"."XMLBA",

"L_HYXM"."XMLBB",

"L_HYXM"."SJXMLB",

"L_HYXM"."JBLB",

"L_HYXM"."LCYY",

"L_HYXM"."FHLX",

"L_HYXM"."BQLX",

"L_HYXM"."GBXM",

"L_HYXM"."STBH",

"L_HYXM"."FYMC",

"L_HYXM"."ZHPB",

"L_HYXM"."HISLB",

"L_HYXM"."BBFS",

"L_HYXM"."USENOW",

"L_HYXM"."SHOW_GZ",

"L_HYXM"."SHOW_BG",

"L_HYXM"."ZHLB",

"L_HYXM"."XZKS",

"L_HYXM"."XZLB",

"L_HYXM"."QTZH",

"L_HYXM"."TQBJSJ",

"L_HYXM"."NEEDYY",

"L_HYXM"."JJRXM",

"L_HYXM"."HYXMBM",

"L_HYXM"."LCCSTYPE",

"L_HYXM"."ISCFKD",

"L_HYXM"."CSTC",

"L_HYXM"."CSSM",

"L_HYXM"."SQKD"
FROM "L_HYXM",

"L_TESTDESCRIBE"

WHERE "L_TESTDESCRIBE"."TESTID" IN (:ar_testid) AND "L_HYXM"."USENOW" = 1 AND

"L_HYXM"."YLXH" = "L_TESTDESCRIBE"."YLXH" AND
"L_HYXM"."YLXH" > 0 AND ("L_HYXM"."ZHPB" = 0 OR "L_HYXM"."ZHPB" IS NULL)

2个回答

caozhy
caozhy   Ds   Rxr 2016.01.19 20:00

你的列名是不是有错误

jinxuhan1314
jinxuhan1314   2016.01.20 10:04

连接的oracle数据库,列名没有错误。。。。

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!