Subject | Re: for select do - statement in nested SP |
---|---|
Author | Ulrich |
Post date | 2003-12-15T08:15:03Z |
Alan,
everything is in only one SP AND no temporary table any longer! That
is, what was in my mind when I started do write the SP.
I thought, that SUSPEND must be in the <for select> loop to catch
every selected record, but I only need it when I have something what
I would like to give back with a return parameter....
Thanks - Ulrich
> There is no return value for an SP unless you declare one. If youI wish you could see the smile on my face! It's working AND
> declare
> RETURNS, then you need a SUSPEND to return it.
> If you do not want a return, then don't declare it AND don't use
> SUSPEND.
> Alan
everything is in only one SP AND no temporary table any longer! That
is, what was in my mind when I started do write the SP.
I thought, that SUSPEND must be in the <for select> loop to catch
every selected record, but I only need it when I have something what
I would like to give back with a return parameter....
Thanks - Ulrich