Navigates to the first record in the block's list of records.
PROCEDURE FIRST_RECORD;
Built-in Type restricted procedure
Enter Query Mode no
None.
/*
** Built-in: FIRST_RECORD
** Example: Have a button toggle between the first and last
** records in a block.
** Trigger: When-Button-Pressed
*/
BEGIN
/*
** If we're not at the bottom, then go to the last record
*/
IF :System.Last_Record <> 'TRUE' THEN
Last_Record;
ELSE
First_Record;
END IF;
END;