Subject | Walking through a Resultset with IB_Query |
---|---|
Author | Behnke@hbg.dpa.de |
Post date | 2001-08-23T14:19:31Z |
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
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