After you execute a scrollable cursor, you see these results, 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. |
The following 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. |
