CODEWITHSUNDEEP
openedgeprogress-4gl
sander
sander

Reputation: 1654

FOR EACH two tables with WHERE clause OpenEdge

I'm trying to add together two tables based on their common field which is ProductID, I'm using OpenEdge Editor and when I run this progress file, I get no output or no warning message.

FOR EACH table1, EACH table2 WHERE table1.ProductID = table2.ProductID:
    DISPLAY table1.ProductID.
END.

Upvotes: 0

Views: 970

Answers (1)

bupereira
bupereira

Reputation: 1498

When a Progress Openedge program like yours runs with no output, it's a sign no records match the criteria. Query the tables separately, make sure they have records and hard-code some codes you're sure as present to test functionality. Your syntax seems to be correct, so it's most likely a data-related issue.

Upvotes: 3

Related Questions