[Stackoverflow] [Progress OpenEdge ABL] if else statements for finding values from two different table

[Rafailo]

I want to match a number from two different table and if it's found in any table it will display that..

INPUT FROM VALUE("/mydirectory/test.csv").
REPEAT:
IMPORT c.
FOR EACH table1 NO-LOCK WHERE table1.ordernumber=c.
IF AVAILABLE table1 THEN
DISPLAY table1.ordernumber table1.orderdate.
ELSE IF NOT AVAILABLE table1 THEN
FIND FIRST table2 NO-LOCK WHERE table2.ordernumber=c.
IF AVAILABLE table2 THEN
DISPLAY table2.ordernumber table2.orderdate.
END.
END.

So far I have written this much but it's not giving correct results. Appreciate help on this regards. Thanks.

Continue reading...