读书人

请问 如题

发布时间: 2013-02-05 10:40:57 作者: rapoo

请教 如题
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最后都要加分号

读书人网 >PB

热点推荐