>
> 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
detail?
> >
> 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
advance
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