invalid cursor name!!!
大家好写了个过程，但是在winsql中执行老报invalid cursor name,然后我又在dbaccess中取执行,说是201错误,语法错误.
create procedure updateCell_LabelDev()
define tmp_bts_id varchar(255);
define tmp_ci varchar(255);
define tmp_bts_label_dev varchar(255);
define tmp_cell_label_dev varchar(255);
foreach cur1for
select a.bts_id, b.label_dev,substr(a.ci,length(a.ci)-1,1)
into tmp_bts_id,tmp_bts_label_dev,tmp_ci
from radio_cell_g a,radio_bts_g b
where a.label_dev is null;
let tmp_cell_label_dev = tmp_bts_label_dev||tmp_ci;
update radio_cell_g
set label_dev = tmp_cell_label_dev
where current of cur1;
end foreach;
end procedure;
winsql中的错误信息:invalid cursor name
dbaccess中的错误信息: 201: A syntax error has occurred.
我看了半天找不到到底那错了，各位大侠看看 foreach 那句条件is null 后的分号去掉。 谢谢,按照你说的,去掉了,没起作用, 我在dbaccess试了可以么 dbaccess 中可以执行,winsql中不能,什么问题哦,在次感谢楼上
页:
[1]