SYSTEM.LAST_RECORD
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. |
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.