Just add DISTINCT to your query, and combine them together into one:

select distinct art, material
from article

> For select all article into :art do
> begin
> Select material from article into :mat
> Do
> begin
> Suspend;
> End
> End

---

Hello and thanks,

But the second loop is an procedure.

For select all articles in my importable do
Begin
Select returnvalues from procedure(:article) into returnvalue do
Suspend;
End

I would like something:

Do
begin
check if already suspended, if not, then suspend;
end

Thanks

Olaf







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