| Subject | Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure |
|---|---|
| Author | |
| Post date | 2018-05-04T16:56:37Z |
I am not sure if I understand your explanation here... 
1...
Why would I test the input parameter, "PI_KEY_IN" for each row? I am only doing this to ensure that the client never sends an input value of zero(0).
2...
In the other email you sent you stated that...
"A FOR .. DO is a loop construct, which either execute a single statement for each iteration (each row) in the loop, or a block of statements delimited by BEGIN and END."
However. if this follows as most constructs, the "DO" part is the end statement to the "FOR". Or is this better understood as "FOR" everything I do here, "DO" the following... ???
Steve
1...
Why would I test the input parameter, "PI_KEY_IN" for each row? I am only doing this to ensure that the client never sends an input value of zero(0).
2...
In the other email you sent you stated that...
"A FOR .. DO is a loop construct, which either execute a single statement for each iteration (each row) in the loop, or a block of statements delimited by BEGIN and END."
However. if this follows as most constructs, the "DO" part is the end statement to the "FOR". Or is this better understood as "FOR" everything I do here, "DO" the following... ???
Steve