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

SYSTEM.FORM_STATUS System Variable

Syntax

SYSTEM.FORM_STATUS

Description

SYSTEM.FORM_STATUS represents the status of the current form. The value can be one of three character strings:

CHANGED

Indicates that the form contains at least one block with a Changed record. The value of SYSTEM.FORM_STATUS becomes CHANGED only after at least one record in the form has been changed and the associated navigation unit has also changed.

NEW

Indicates that the form contains only New records.

QUERY

Indicates that a query is open. The form contains at least one block with QUERY records and no blocks with CHANGED records.

Usage Notes

Each time this value is referenced, it must be constructed by Oracle Forms. If a form contains a large number of blocks and many records, using SYSTEM.FORM_STATUS could affect performance.

SYSTEM.FORM_STATUS Examples

Assume that you want to create a trigger that performs a commit before clearing a form if there are changes to commit within that form. The following Key-CLRFRM trigger performs this function.

IF :System.Form_Status = 'CHANGED'
THEN Commit_Form;
END IF;
Clear_Form;


SYSTEM.BLOCK_STATUS examples

SYSTEM.RECORD_STATUS examples