游标错误？该怎么解决？

[cl007]

declare cursor must be the only statemant in a query batch?

语句如下：

string medicine_id
declare cc cursor for
select medicine_id
from common_medicine_dict
where mid_to_small = 10;
open cc;
fetch cc into medicine_id
do while sqlca.sqlcode = 0
insert into yf_store_amount(drugstore_id,medicine_id,medicine_spec,medicine_serial_noint,medicine_amount,medicine_amount_small)
values("52",:medicine_id,"测试用规格","1",100,0)
fetch cc into :medicine_id
loop

close cc;

[zhuzhichao]

什麼提示

[tanye]

错误:
fetch cc into medicine_id
应该为:
fetch cc into medicine_id;
提示:在执行数据库SQL语句时一定要以";"分号结束

[tanye]

同样:
insert into yf_store_amount(drugstore_id,medicine_id,medicine_spec,medicine_serial_noint,medicine_amount,medicine_amount_small)
values("52",:medicine_id,"测试用规格","1",100,0)

[cl007]

string medicine_id

declare cc cursor for
select medicine_id
from common_medicine_dict
where mid_to_small=10;

open cc;
fetch cc into :medicine_id;
do while sqlca.sqlcode = 0

insert into yf_store_amount(drugstore_id,medicine_id,medicine_spec,medicine_serial_noint,medicine_amount,medicine_amount_small)
values("52",:medicine_id,"测试用规格","111",10000,0);

FETCH cc into :medicine_id;
loop
close cc;

我在isql中执行不行，但我把她在程序中执行却很正确，为什么？ISQL连string都不认啊！

[zhuzhichao]

ISQL是不是SQLServer的Query Analyzer呀,
如果是的話,那它不會認string的.
你可以這樣:
declare medicine_id varchar(12)

[caolei1974]

同意zhuzhichao(竹之草)　

[meteor_wyj]

你给我记住，发生COMMIT or ROOLBACK会关闭游标。