SYSTEM.MODE
SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string.
Value | Description |
---|---|
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. |
When using SYSTEM.MODE to check whether the current block is in Enter Query mode, be aware that if testing from a When-Button-Pressed trigger in a control block, Enter Query mode will never be entered, because the control block is not the current block.
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;