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

gfxd(PEERCLIENT)> get scroll insensitive with nohold cursor scrollCursor as 'select * from firsttable order by id';
gfxd(PEERCLIENT)> absolute 3 scrollCursor;
ID         |NAME
------------------------
30         |THIRTY
gfxd(PEERCLIENT)> first scrollCursor;
ID         |NAME
------------------------
10         |TEN
gfxd(PEERCLIENT)> next scrollCursor;
ID         |NAME
------------------------
20         |TWENTY
gfxd(PEERCLIENT)> last scrollCursor;
ID         |NAME
------------------------
50         |Fifty
gfxd(PEERCLIENT)> previous scrollCursor;
ID         |NAME
------------------------
40         |Forty
gfxd(PEERCLIENT)> relative -1 scrollCursor;
ID         |NAME
------------------------
30         |THIRTY
gfxd(PEERCLIENT)> after last scrollCursor;
No current row