Question

pb用游标查询为什么只有最后一个能查到

DECLARE rb CURSOR FOR
SELECT bid
FROM jieshu
where rid=:lsrid;
Open rb;//打开游标
//提取数据
FETCH rb into :lsbid;
DO WHILE sqlca.sqlcode=0
//将读取的数据加到listbox中
select bname into :lsbname
from book
where bid=:lsbid;
lb_1.additem(lsbid+lsbname)
FETCH rb into :lsbid;
LOOP
close rb;//关闭游标
输出结果是
00001
00002
00003 10003
我设置断点发现中间的查询都为空

Answer 1

你先把游标的数据取出来放到一个数组中，然后再根据数组中的数据进行 这样操作看下
select bname into :lsbname
from book
where bid=:lsbid;
lb_1.additem(lsbid+lsbname)