GetCurrentRowNumber

Returns the row number for the current position of the named scroll cursor.

Syntax

GETCURRENTROWNUMBER Identifier

Description

After the cursor is created with the get scroll insensitive cursor, returns the row number for the current position of the named scroll cursor. Zero (0) is returned if the cursor is not positioned on a 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)> before first scrollCursor;
No current row
gfxd(PEERCLIENT)> GETCURRENTROWNUMBER scrollCursor;
0
gfxd(PEERCLIENT)> relative 2 scrollCursor;
ID         |NAME
------------------------
20         |TWENTY
gfxd(PEERCLIENT)> GETCURRENTROWNUMBER scrollCursor;
2