I think for your procedure you can use DISTINCT, too.

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

It's the same as checking if already suspended.



2011/6/16 Olaf Kluge <olaf.kluge@...>

>
>
>
>
> 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]
>
>
>

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