Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible to get valid recordcount with MSDAORA?

Re: Possible to get valid recordcount with MSDAORA?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 12 Feb 2004 15:45:38 GMT
Message-ID: <CcNWb.14654$_44.18612@attbi_s52>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US