1.1

40 |Forty
50 |Fifty
5 rows selected
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor as 'select * from firsttable order by id';
sqlf(PEERCLIENT)> absolute 3 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
after last
Moves the cursor to after the last row, then fetches the row.
Syntax
AFTER LAST
Identifier
Description
Moves the cursor to after the last row, then fetches the row. If there is no current row, it returns the message:
"No current row."
The cursor must have been created with the get scroll insensitive cursor on page 434 command.
Example
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor as 'select * from firsttable order by id';
sqlf(PEERCLIENT)> absolute 3 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
sqlf(PEERCLIENT)> first scrollCursor;
ID |NAME
------------------------
10 |TEN
sqlf(PEERCLIENT)> next scrollCursor;
ID |NAME
------------------------
20 |TWENTY
sqlf(PEERCLIENT)> last scrollCursor;
ID |NAME
------------------------
50 |Fifty
sqlf(PEERCLIENT)> previous scrollCursor;
ID |NAME
------------------------
40 |Forty
sqlf(PEERCLIENT)> relative -1 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
vFabric SQLFire User's Guide424
vFabric SQLFire Reference