Subject | TIB_Grid feature inquiry |
---|---|
Author | Boris Schlüszler |
Post date | 2002-11-24T13:33:14Z |
Hello all!
What about a ReverseDisplay property for TIB_Grid, which displays last
fetched rows first and first rows last?
Why that?
Imagine you have something like a history list you want to display.
In this table there some 100.000 rows.
You want to display the last 1000 or so, the last row displayed as
bottom row in the grid.
You will then set up a query like this: select * from history where
id>:number order by id
to fetch all rows whose id is bigger than the value you expect to be
around 1000 rows away.
Unfortunately you have to recalc number every now and then.
Better way would be:
select * from history order by id descending
and have it displayed in the grid reversely.
What do you think about it?
Regards, Boris
What about a ReverseDisplay property for TIB_Grid, which displays last
fetched rows first and first rows last?
Why that?
Imagine you have something like a history list you want to display.
In this table there some 100.000 rows.
You want to display the last 1000 or so, the last row displayed as
bottom row in the grid.
You will then set up a query like this: select * from history where
id>:number order by id
to fetch all rows whose id is bigger than the value you expect to be
around 1000 rows away.
Unfortunately you have to recalc number every now and then.
Better way would be:
select * from history order by id descending
and have it displayed in the grid reversely.
What do you think about it?
Regards, Boris