SYSTEM.TAB_PREVIOUS_PAGE system variable in Oracle D2k Forms
Syntax
SYSTEM.TAB_PREVIOUS_PAGE
Description
SYSTEM.TAB_PREVIOUS_PAGE
Description
The system variable SYSTEM.TAB_PREVIOUS_PAGE specifies the name of the tab page from which
navigation occurred. Use it inside a When-Tab-Page-Changed trigger.
navigation occurred. Use it inside a When-Tab-Page-Changed trigger.
SYSTEM.TAB_PREVIOUS_PAGE examples
/* Use system variable SYSTEM.TAB_PREVIOUS_PAGE inside a
** When-Tab-Page-Changed trigger to change the label of the
** tab page to initial-cap after an end user navigates out
** of the tab page:
*/
** When-Tab-Page-Changed trigger to change the label of the
** tab page to initial-cap after an end user navigates out
** of the tab page:
*/
Example
DECLARE tp_nm VARCHAR2(30); tp_id TAB_PAGE; tp_lbl VARCHAR2(30); BEGIN tp_nm := :SYSTEM.TAB_PREVIOUS_PAGE; tp_id := FIND_TAB_PAGE(tp_nm); tp_lbl := GET_TAB_PAGE_PROPERTY(tp_id, label); IF tp_nm LIKE ’ORD%’ THEN SET_TAB_PAGE_PROPERTY(tp_id, label, ’Orders’); END IF; END;