SYSTEM.FORM_STATUS
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. |
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.
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;