View results after executing a scrollable cursor, assuming a total of N rows and a rowset m where N > m.
|
Result |
Interpretation |
|---|---|
|
Absolute 0 |
No row is returned, error. |
|
Absolute 1 |
m row is returned. |
|
Absolute N |
1 row is returned. |
|
Absolute N+1 |
No row is returned, error. |
|
First |
The first (1..m ) rows are returned. |
|
Last |
The last (N-m+1 .. N) rows are returned. |
|
Next |
The same as SQLFetch(). |
|
Prior |
Return the rowset that is before current rowset. |
These results are expected if the current cursor points to row k and k-a > 0, k + m + a < N, a>=0:
|
Result |
Interpretation |
|---|---|
|
Relative -a |
The rows (k-a, k-a + m -1) are returned. |
|
Relative a |
The rows (k + a, k+a + m -1) are returned. |