SYSTEM.MODE - Form- System Variables in Oracle Forms

SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode.  The value is always a character string.

NORMAL:- Indicates that the form is currently in normal processing mode.

ENTER-QUERY Indicates that the form is currently in Enter Query mode.

QUERY                    Indicates that the form is currently in fetch processing mode, meaning that a query is currently being processed.

Example:

Assume that you want Oracle Forms to display an LOV when the operator enters query mode and the input focus is in a particular text item. The following trigger accomplishes that operation.

/* ** When–New–Item–Instance Trigger */

BEGIN

IF :System.Cursor_Item = ’EMP.EMPNO’ and :System.Mode = ’ENTER–QUERY’ THEN

IF NOT Show_Lov(’my_lov’) THEN

RAISE Form_Trigger_Failure;

END IF;

          End if;

END;