Dear Community,
I'm working on implementation of virtual grid using DECLARE... SELECT....
Advantage of virtual grid is that it loads only rows that a user is willing
to see (with FETCH).
However, it is not clear how to determine max rows count that the cursor can
return. The count is necessary for two purposes: render scrollbar and
support jumping to the last rows in the grid.
The only obvious solution is to execute SELECT COUNT(1) ... before declaring
the cursor.
Is there a better solution?
Can the cursor return total rows count or is there a way to position cursor
to the last row? (Then the number of roundtrips to server can be less by 1
and virtual grid can render last rows in reverse order).
Thank you,
K.