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 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
sqlf(PEERCLIENT)> after last scrollCursor;
No current row