Subject Re: [IBO]: Position on last record on TIBOTable without fetching all records
Author Adomas Urbanavicius
We use same thechnique with TIBOQuery.
In fact with open runtime order billing transactions dataset of 700.000
record from first to last record takes from
20 - to 6 seconds. And open Products, Wares and services catalog with
~140.000 records from 1 to last takes about 1 - 4 secs.

Vahan Yoghoudjian wrote:

> Hi Jason, what we really want to do is the following:
>An account has a few 100,000 transactions.
>Of course it is not conceivable to show them all at once.
>To show those transactions, we would like to implement the following
>A form is opened, which contains a grid.
>This grid shows the transactions of the said account, starting from the
>latest transactions, ie the latest transaction for that account is near the
>bottom of the grid.
>The cursor bar is on the latest transaction.
>The user may click on the up arrow, and reach the topmost line on his grid.
>If he clicks on the up arrow again, the grid shows more of the former
>Of course, if the user is stubborn enough to keep clicking on the up arrow
>all day, he will eventually go through the 100,000 transactions, but this is
>unlikely to happen.
>Now how much the user will peek backwards at the account history cannot be
>told in advance, and remains his choice.
>How could this interface be implemented, using a TIBOTable or is there
>another component that would do this job ?
>Note that TIBOTable would work perfectly for us if we wanted to position on
>the first record when we open the table and let the user scroll down as he
>wished, but we want to position on the last record and let the user scroll
>up, is that possible without fetching all the records at once?