cursor 遍历问题

xdxycx 2004-03-01 11:07:33

我用CURSOR对一张表进行遍历如下
string str_bargaintype
declare type_cur cursor for
select bargaintypename from
bargaintype;
open type_cur;

DO WHILE sqlca.sqlcode = 0
FETCH type_cur INTO :str_bargaintype;
lb_1.additem(str_bargaintype)
LOOP

close type_cur;

为什么最后会多出一天数据呢
如我只有三条数据，但是在LISTBOX中却出现四条数据

...全文

100 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

amekoxiao 2004-08-06

打赏
举报

在循环外加
FETCH type_cur INTO :str_bargaintype;

d

liujw0211 2004-08-06

打赏
举报

string str_bargaintype
declare type_cur cursor for
select bargaintypename from
bargaintype;
open type_cur;

FETCH type_cur INTO :str_bargaintype;
DO WHILE sqlca.sqlcode = 0

lb_1.additem(str_bargaintype)
FETCH type_cur INTO :str_bargaintype;
LOOP

close type_cur;

鸡翅多 2004-08-06

打赏
举报

判断一下，如果是空，就continue

10975037 2004-08-06

打赏
举报

string str_bargaintype
declare type_cur cursor for
select bargaintypename from
bargaintype;
open type_cur;
FETCH type_cur INTO :str_bargaintype;
lb_1.additem(str_bargaintype)
DO WHILE sqlca.sqlcode = 0
FETCH type_cur INTO :str_bargaintype;
lb_1.additem(str_bargaintype)
LOOP

close type_cur;

lzheng2001 2004-08-06

打赏
举报

....

FETCH type_cur INTO :str_bargaintype;
lb_1.additem(str_bargaintype)

DO WHILE sqlca.sqlcode = 0
FETCH type_cur INTO :str_bargaintype;
lb_1.additem(str_bargaintype)
LOOP

close type_cur;