[Stackoverflow] [Progress OpenEdge ABL] How can I get one record from same multiple records?

Status
Not open for further replies.
T

Thiru Malai

Guest
Hi I have written a query which need to show the data in drop down box. Let me share my query what i written

DEFINE TEMP-TABLE tt_seq_report.
FIELD tt_seq_report.neutral_part_obj AS DECIMAL
FIELD tt_seq_report.patt_id AS CHARACTER
FIELD tt_seq_report.npai_info2 AS CHARACTER.

EMPTY TEMP-TABLE tt_seq_report.

FOR EACH gdmf_neutral_part NO-LOCK :
FIND FIRST gdcf_part_type WHERE gdcf_part_type.part_type_obj EQ gdmf_neutral_part.part_type_obj NO-LOCK NO-ERROR.
CREATE tt_seq_report.
ASSIGN
tt_seq_report.neutral_part_obj = gdmf_neutral_part.neutral_part_obj
tt_seq_report.patt_id = gdcf_part_type.patt_id WHEN AVAILABLE gdcf_part_type
tt_seq_report.npai_info2 = gdmf_neutral_part.npai_info2.


END.

/* Written in window main block */

FOR EACH tt_seq_report NO-LOCK :
coCombo-2:ADD-LAST(tt_seq_report.patt_id).
END.

FOR EACH tt_seq_report NO-LOCK :
coCombo-3:ADD-LAST(tt_seq_report.npai_info2).
END.
/*
If you see tt_seq_report.patt_id and tt_seq_report.npai_info2 data is
i.e tt_seq_report.patt_id -BFA
tt_seq_report.npai_info2 -23
tt_seq_report.patt_id -BFA (same id)
tt_seq_report.npai_info2 -24
tt_seq_report.patt_id -SS
tt_seq_report.npai_info2 -23
tt_seq_report.patt_id -SS (same id)
tt_seq_report.npai_info2 -24
tt_seq_report.patt_id -ABS
tt_seq_report.npai_info2 -23
tt_seq_report.patt_id -ABS (same id)
tt_seq_report.npai_info2 -24
and so on.
*/


So here tt_seq_report.patt_id is same for one set of records but tt_seq_report.npai_info2 is will not be same for every records. I could use where condition if there is tt_seq_report.patt_id is BFA,SS,ABS only but it has many.

If I run this window then i can get multiple same tt_seq_report.patt_id in drop down box.

i.e once we select drop down box the showing records like below CustID(label Name for dropbox) Value(label Name for dropbox)

BFA 23 BFA 24 SS 23 SS 24 ABS 23 ABS 24

But My expected output should be

CustID(label Name for dropbox) Value(label Name for dropbox)

BFA 23 24

SS 23 24

ABS 23 24

Please help this case. Thank you.

Continue reading...
 
Status
Not open for further replies.
Top