Is there a way withing the OnProgress to find out how many rows the query currently has?

Roy Lambert

Roy,

<< Is there a way withing the OnProgress to find out how many rows the query
currently has? >>

Do you mean how many rows currently in the result set, or how many rows have
been "looked at" ?

Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Is there a way withing the OnProgress to find out how many rows the query
>currently has? >>
>
>Do you mean how many rows currently in the result set, or how many rows have
>been "looked at" ?

I was thinking IN the result set. At least that's what I wanted to give as part of the progress info. Whilst I can't see a use for how many rows have been looked at right at the moment give me a day or two and I might come up with a "need"

Roy Lambert

Roy,

<< I was thinking IN the result set. At least that's what I wanted to give
as part of the progress info. Whilst I can't see a use for how many rows
have been looked at right at the moment give me a day or two and I might
come up with a "need" >>

The short answer is "no, not currently", although I could probably expand
the OnProgress to indicate this information.  The problem with retrieving it
the "normal" way is that the cursor handle for the result set isn't "there"
yet when the OnProgress is firing.

Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< I was thinking IN the result set. At least that's what I wanted to give
>as part of the progress info. Whilst I can't see a use for how many rows
>have been looked at right at the moment give me a day or two and I might
>come up with a "need" >>
>
>The short answer is "no, not currently", although I could probably expand
>the OnProgress to indicate this information. The problem with retrieving it
>the "normal" way is that the cursor handle for the result set isn't "there"
>yet when the OnProgress is firing.


OK - no problemo - just put it to the bottom of the pile.

Roy