A script-enabled browser is required for this page to function properly.

SYSTEM.LAST_RECORD System Variable

Syntax

SYSTEM.LAST_RECORD

Description

SYSTEM.LAST_RECORD indicates whether the current record is the last record in a block's list of records. The value is one of the following two CHAR values:

TRUE

Indicates that the current record is the last record in the current block's list of records.

FALSE

Indicates that the current record is not the last record in the current block's list of records.

SYSTEM.LAST_RECORD Examples

Assume that you want to create a user-defined procedure that displays a custom message when an operator navigates to the last record in a block's list of records. The following user-defined procedure performs the basic function.

PROCEDURE LAST_RECORD_MESSAGE IS
BEGIN
IF :System.Last_Record = 'TRUE'
THEN Message('You are on the last row');
END IF;
END;

You can then redefine [Down], [Next Record], and [Scroll Down] to call this user-defined procedure in addition to their normal processing.