| combo box... blank? [message #81565] |
Mon, 03 March 2003 09:45  |
kim
Messages: 116
Registered: December 2001
|
Senior Member |
|
|
i am getting a blank in the botton of my combo box when i populate it. is there a way to get rid of this? here is my code.
PROCEDURE get_cat1 IS
cat_desc nsmp.tr_cat1.cat1_desc%type;
loop_var NUMBER;
cat1 NUMBER;
cursor C1 is
select cat1_desc from nsmp.tr_cat1
order by cat1_desc;
begin
OPEN C1;
loop_var := 0;
LOOP
FETCH C1 INTO cat_desc;
EXIT WHEN C1 %NOTFOUND or c1 %notfound is null;
loop_var := loop_var + 1;
add_list_element('catlist',loop_var,cat_desc,cat_desc);
END LOOP;
CLOSE C1;
END;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
