Before First commandThe Before First command moves the cursor to before
the first row, then fetches the row.Before First commandCursorsfetching next 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.
SyntaxBEFORE FIRST int IdentifierExampleij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> before first scrollcursor;
No current row