Been trying to figure this one out for a a while w.o. success. What am I missing here?
OE 11.X
They say SELECT DISTINCT = BREAK BY & FIRST OF: Progress KB - What is an ABL equivalent for a SQL SELECT DISTINCT?
BUT
=>
33-835 076174338355 0
AND
─
SELECT DISTINCT icsec.altprod, icsec.prod, icsec.custno
FROM icsec
WHERE icsec.alt-prod = '33-835'
=>
33-835 076174338355 0
33-835 10092080 1608
33-835 1857625 2716
33-835 1857625 9300
33-835 1857625 9310
33-835 1857625 9313
33-835 1857625 9314
33-835 1857625 9316
33-835 1857625 9317
OE 11.X
They say SELECT DISTINCT = BREAK BY & FIRST OF: Progress KB - What is an ABL equivalent for a SQL SELECT DISTINCT?
BUT
Code:
FOR EACH icsec NO-LOCK WHERE cono = 1 AND icsec.altprod = '33-835'
BREAK BY icsec.altprod BY icsec.prod BY icsec.custno:
IF FIRST-OF(icsec.altprod) AND FIRST-OF(icsec.prod) AND
FIRST-OF(icsec.custno) THEN
DISP icsec.altprod icsec.prod icsec.custno.
END.
33-835 076174338355 0
AND
─
SELECT DISTINCT icsec.altprod, icsec.prod, icsec.custno
FROM icsec
WHERE icsec.alt-prod = '33-835'
=>
33-835 076174338355 0
33-835 10092080 1608
33-835 1857625 2716
33-835 1857625 9300
33-835 1857625 9310
33-835 1857625 9313
33-835 1857625 9314
33-835 1857625 9316
33-835 1857625 9317
Last edited by a moderator: