apache > db
Apache DB Project
 
Font size:      

Previous

Previous

Syntax

PREVIOUS Identifier

Description

Moves the cursor to the row previous to the current one, then fetches the row. The cursor must have been created with the Get Scroll Insensitive Cursor command. It displays a banner and the values of the row.

Note:
This command works only in a Java(TM) 2 Platform, Standard Edition, v 1.2 (J2SE) or higher environment.

Examples


ij> get scroll insensitive cursor scrollCursor as 
'SELECT * FROM menu FOR UPDATE OF price';
ij> last scrollcursor;
COURSE    |ITEM                |PRICE
-----------------------------------------------
dessert   |creme brulee        |6
ij> previous scrollcursor;
COURSE    |ITEM                |PRICE
-----------------------------------------------
entree    |lamb chop           |14

Previous Page
Next Page
Table of Contents
Index