previous

Moves the cursor to the row previous to the current one, then fetches the row.

Syntax

PREVIOUS Identifier

Description

After the cursor is created with the Get Scroll Insensitive Cursor command, Moves the cursor to the row previous to the current one, then fetches the row. It displays a banner and the values of the row.

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