请问 如题
请教 如题
dw_1.settransobject(sqlca)
int li_bjmc,n
string ls_bjmc
SELECT COUNT(distinct bjmc)INTO:li_bjmc FROM xscj_bj
DECLARE bjmccursor CURSOR FOR
SELECT xscj_bj.bjmc FROM xscj_bjkc,xscj_bj
WHERE xscj_bjkc.bjbh=xscj_bj.bjbh GROUP BY bj.bjmc
OPEN bjmccursor
FOR n=1 TO li_bjmc
FETCH NEXT bjmccursor INTO :ls_bjmc
ddlb_1.additem(ls_bjmc)
NEXT
CLOSE bjmccursor
如上代码,运行时,第4行(SELECT COUNT(distinct bjmc)INTO:li_bjmc FROM xscj_bj)提示“syntax error”
个人检查了下,符号没有问题,求高手找错误。谢谢
------解决方案--------------------
SELECT COUNT(distinct bjmc)INTO:li_bjmc FROM xscj_bj
加分号;
所有的嵌入式SQL最后都要加分号
dw_1.settransobject(sqlca)
int li_bjmc,n
string ls_bjmc
SELECT COUNT(distinct bjmc)INTO:li_bjmc FROM xscj_bj
DECLARE bjmccursor CURSOR FOR
SELECT xscj_bj.bjmc FROM xscj_bjkc,xscj_bj
WHERE xscj_bjkc.bjbh=xscj_bj.bjbh GROUP BY bj.bjmc
OPEN bjmccursor
FOR n=1 TO li_bjmc
FETCH NEXT bjmccursor INTO :ls_bjmc
ddlb_1.additem(ls_bjmc)
NEXT
CLOSE bjmccursor
如上代码,运行时,第4行(SELECT COUNT(distinct bjmc)INTO:li_bjmc FROM xscj_bj)提示“syntax error”
个人检查了下,符号没有问题,求高手找错误。谢谢
------解决方案--------------------
SELECT COUNT(distinct bjmc)INTO:li_bjmc FROM xscj_bj
加分号;
所有的嵌入式SQL最后都要加分号