OpenEdge progress database insert row - Beginner

[Guardian]

i need to insert new rows into my database.

OUTPUT TO c:\temp\SMLeiste_bearbeiten.csv.
DEFINE VARIABLE size AS CHARACTER NO-UNDO FORMAT "x(3)"
LABEL "Size".
for each S_Artikel
where S_Artikel.Selektion matches "KSE*"
or S_Artikel.Selektion matches "ZSE*"
or S_Artikel.Selektion matches "SSE*",
EACH BS_Zuord
where BS_Zuord.SMLeiste = "SE"
AND BS_Zuord.Owning_Obj = S_Artikel.S_Artikel_Obj
EXCLUSIVE-LOCK.

ASSIGN BS_Zuord.Property = "Size".

PUT UNFORMATTED
'First Loop - set row with Property "Size"' + '|' + STRING(BS_Zuord.Owning_Obj) + '|' + String(S_Artikel.S_Artikel_Obj)
SKIP.
END.


So the problem now is, that i don't know how to add the row with the Size without going through every item from "BS_Zuord"

one S_Artikel object has multiple BS_Zuord objects

I just want to query which S_Artikel matches my criteria and then add a BS_Zuord with equal Owning_Obj = S_Artikel_Obj

I think i might have to join the tables or something like that, but i have no idea how to do that in progress

Thanks in advance!

Continue reading...