- 论坛徽章:
- 0
|
大家好
写了个过程，但是在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 cur1 for
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.
我看了半天找不到到底那错了，各位大侠看看 |
|
免费注册
发表于 2008-04-21 19:34
