Before First command

The Before First command moves the cursor to before the first row, then fetches the row.

Since 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.

Syntax

BEFORE FIRST int Identifier

ij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> before first scrollcursor;
No current row

Parent topic: ij commands and errors reference

Related concepts

ij commands