> On Tuesday 25 February 2003 09:28, Christoph Haller wrote:
> > > On Mon, Feb 24, 2003 at 07:53:05PM +0000, Darko Prenosil wrote:
> > > >     I need two answers I did not find in documentation :
> > > > How can I get exact number of rows in DECLARED CURSOR ?
> > > > OK, I can FETCH until NULL, but this does not fits my needs !
> >
> > You may want to use FETCH ALL, otherwise what or your needs in
> >
> If I use FETCH ALL all, all the data will be sent to client, then why
to use
> CURSOR at all ? I need to reduce network trafic on slow connections !
I cannot see how you are going to reduce network traffic by knowing in
how many rows will be returned.
Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT()
function on the query to learn about the number of rows to be returned.

Regards, Christoph

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to