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.