[Stackoverflow] [Progress OpenEdge ABL] How to find the minimum value for 1-many relationship?

Status
Not open for further replies.
F

Felice

Guest
I want to find the minimum date value in a list of transactions that are associated with an investment. There are many transactions for one investment, clearly. How do I write this so that Progress will only give me the minimum transaction date? I get the minimum at the end of my list, but I do not want the list, just the minimum value.

Code:
FOR EACH ilinvest WHERE ilinvest.inv-num EQ 406885:
    FOR EACH iltrans WHERE iltrans.reg-pin EQ ilinvest.reg-pin:
        DISPLAY iltrans.tran-dt(MINIMUM).
    END.
END.

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