absolute

Moves the cursor to the row specified by the int, and then fetches the row.

Syntax

ABSOLUTE int Identifier

Description

Moves the cursor to the row specified by the int, and then fetches the row. The cursor must have been created with the Get Scroll Insensitive Cursor command. It displays a banner and the values of the row.

Example

gfxd(PEERCLIENT)> select * from firsttable order by id;
ID         |NAME
------------------------
10         |TEN
20         |TWENTY
30         |THIRTY
40         |Forty
50         |Fifty

5 rows selected
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