Before First command

Before First command Before First commandCursorsfetching next row Syntax BEFORE FIRST int Identifier

Description

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.

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