before first

Moves the cursor before the first row, then fetches the row.

Syntax

BEFORE FIRST int Identifier

Description

Moves the cursor before the first 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)> before first scrollCursor;
No current row