Should be displayed in the DDLB drop-down menu database A XXX all data fields in the table, such as: drop-down menu to display "clothing category" all the data in the field - t-shirts, windbreaker, jeans... , want to have data filtering, the "color" is displayed only for RED or YELLOW, this is my a piece of code:

String lb_curname
String lb_item

DECLARE curs_cur CURSOR FOR
The SELECT clothing categories FROM A WHERE clause FXCCODT0001. COLOR="red" OR the WHERE FXCCODT0001. COLOR="yellow";

The open curs_cur;

The FETCH curs_cur INTO: lb_item;

The DO WHILE the SQLCA. Sqlcode=0
Sle_1. AddItem (lb_item);
The FETCH curs_cur INTO: lb_item;
LOOP

The close curs_cur;


The question now is: drop-down menu not to display the data???????
Please teach the warrior ~ ~ ~

CodePudding user response:

String lb_curname
String lb_item

DECLARE curs_cur CURSOR FOR
SELECT clothing categories FROM A WHERE clause FXCCODT0001. COLOR="red" OR the WHERE FXCCODT0001. COLOR="yellow";
String lb_curname
String lb_item

DECLARE curs_cur CURSOR FOR
SELECT clothing categories FROM A WHERE clause FXCCODT0001. COLOR in (" red ", "yellow");

The open curs_cur;

The FETCH curs_cur INTO: lb_item;

The DO WHILE the SQLCA. Sqlcode=0
Sle_1. AddItem (lb_item);
The FETCH curs_cur INTO: lb_item;
LOOP

The close curs_cur;


The open curs_cur;

The FETCH curs_cur INTO: lb_item;

The DO WHILE the SQLCA. Sqlcode=0
Sle_1. AddItem (lb_item);
The FETCH curs_cur INTO: lb_item;
LOOP

The close curs_cur;

CodePudding user response:

The SELECT clothing categories FROM A WHERE clause FXCCODT0001. COLOR="red" OR the WHERE FXCCODT0001. COLOR="yellow";
To:
SELECT clothing categories FROM A WHERE clause FXCCODT0001. COLOR in (" red ", "yellow");

CodePudding user response:

Are all very good advice! Worth learning

CodePudding user response:

Pick up points first!