ij Commands and Errors Reference
Page 7 of 39

Before First

Syntax

BEFORE FIRST int Identifier

Description

Moves the cursor to before the first row, then fetches the row. (Since there is no such row, it returns the message "no such row.")

The cursor must have been created with the Get Scroll Insensitive Cursor command.

NOTE: This command works only in a JDK 1.2 environment.

Example

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