Subject | Re: for select do - statement in nested SP |
---|---|
Author | Ulrich |
Post date | 2003-12-15T08:58:32Z |
Luc,
think that the SUSPEND statement is nessesary to loop through the
selected records. That's totally wrong.
It's needed to give back multiple records.
Thanks - Ulrich
>Ok, your explanation is far more precise. My basic mistake was, to
> That's not quite true.
> Every procedure can return values without suspend.
> Suspend is for returning MULTIPLE values (records).
>
> Suspend is used for procedures that are selected from, without
> suspend
> you have to execute the procedure and return one set of return
> parameters.
>
> Luc.
think that the SUSPEND statement is nessesary to loop through the
selected records. That's totally wrong.
It's needed to give back multiple records.
> SUSPEND is not for cvatching the record, it is for writing it toThat's the point, I didn't understand!
> the output stream.
Thanks - Ulrich