Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible to get valid recordcount with MSDAORA?
"Greg Rodenroth" <g-rodenroth_at_ti.com> wrote in message
news:c0g5as$r4k$1_at_home.itg.ti.com...
> All,
>
> I am trying to get a valid recordcount using MSDAORA as a provider. All
> cursor types (forward, static, dynamic, keyset) return a -1 when using a
> server side cursor. When I use a client side cursor, the recordcount is
> correct, however, some of my recordsets are sizeable, and the client side
> transfer takes up noticeable processing time.
>
> Any thoughts?
>
>
Simple, it can't know how many records there are until they are retrieved.
If you actually retrieve them then the count is known.
Jim
Received on Thu Feb 12 2004 - 09:45:38 CST
![]() |
![]() |