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

SYSTEM.MODE System Variable

Syntax

SYSTEM.MODE

Description

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.

Usage Notes

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.

SYSTEM.MODE Examples

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;