Hello,



I have a question about distinct return values.



For example an article contained the following:

Piece A

Piece B

Piece C

Another article contained these:

Piece D

Piece E

AND Piece A.



Now I would return all contained Pieces, but only one time.



For select all article into :art do

begin

Select material from article into :mat

Do

begin

Suspend;

End

End



Can I check all returned values and if not present, then suspend? Or should
I save all values in a temporary table?



Thanks



Olaf





[Non-text portions of this message have been removed]