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@...>
To: <IBObjects@yahoogroups.com>
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