1.1.1

Example
sqlf(PEERCLIENT)> select * from firsttable order by id;
ID |NAME
------------------------
10 |TEN
20 |TWENTY
30 |THIRTY
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 446 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;
vFabric SQLFire User's Guide436
vFabric SQLFire Reference