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

CLEAR_RECORD Built-in

Description

Causes Oracle Forms to remove, or flush, the current record from the block, without performing validation. If a query is open in the block, Oracle Forms fetches the next record to refill the block, if the record space is no longer filled after removing the current record.

A database record that has been cleared is not processed as a delete by the next Post and Commit Transactions process.

In a default master-detail block relation, clearing the master record causes all corresponding detail records to be cleared without validation.

Syntax

PROCEDURE CLEAR_RECORD;

Built-in Type restricted procedure

Enter Query Mode yes

CLEAR_RECORD Examples

/*

** Built-in: CLEAR_RECORD
** Example: Clear the current record if it's not the last
** record in the block.
*/
BEGIN
IF :System.Last_Record = 'TRUE' AND :System.Cursor_Record = '1' THEN
Message('You cannot clear the only remaining entry.');
Bell;
ELSE
Clear_Record;
END IF;
END;


DELETE_RECORD Built-in