Thread: count of query results in for loop

count of query results in for loop

From
Sim Zacks
Date:
Is there any way to (without a separate count query first) to know the
number of rows returned in a:

    for x in select ... Loop

    ...

    End Loop

structure?



Re: count of query results in for loop

From
"Albe Laurenz"
Date:
Sim Zacks wrote:
> Is there any way to (without a separate count query first) to know the
> number of rows returned in a:
>
>     for x in select ... Loop
>
>     ...
>
>     End Loop
>
> structure?

No. Not before you exit the loop.

Yours,
Laurenz Albe