--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:

> If you are walking an entire result set I recommend that you use a
> TIB_Cursor and have the order by reverse the order so that you are

walking a

> unidirectional cursor instead of bloating a buffer and walking it

backwards.

>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <Behnke@h...>
> To: <IBObjects@y...>
> Sent: Thursday, August 23, 2001 7:19 AM
> Subject: [IBO] Walking through a Resultset with IB_Query
>
>
> > Hi All,
> >
> > i have the following problem and i wonder if there is a solution.
> > Walking through a Resultset i need to start with the end of the

Result

> > set, because i'll show the last received items of our "News-

System"

> > Therefore i make a Query like this "SELECT* from ItemTable WHERE
> > Create_DATE = 'today'";
> >
> > Now would like to go the last Record with
> > IB_QUERY1->Last() and then
> > go back for example with:
> >
> > while (count < 20)
> > {
> > IB_Query1->Prior();
> > MyStringList->Add(IB_Query1->FieldByName( "MLDIndex" )->AsString);
> > }
> >
> > But using IB_Query->Last() means that all the RecordSets will be
> > transferd to the client.
> > Is there a way ??!
> >
> > Many thanks
> > Gerhard Behnke
> > Hamburg