728x90
EX)
PACKAGE BODY CONTROL_PKG IS
PROCEDURE EVENT_P(PV_CURSOR_ITEM IN VARCHAR2, PV_EVENT_NAME IN VARCHAR2) IS
BEGIN
----------------------------------
--WHEN-BUTTON-PRESSED TRIGGER 로직.
----------------------------------
IF PV_EVENT_NAME = 'WHEN-BUTTON-PRESSED' THEN
IF PV_CURSOR_ITEM = 'CONTROL.B_SEARCH' THEN
:PARAMETER.G_QUERY_FIND := 'TRUE';
APP_FIND.FIND('B_MAIN');
:PARAMETER.G_QUERY_FIND := 'FALSE';
FIRST_RECORD;
END IF;
END IF;
END EVENT_P;
END CONTROL_PKG;
The parameter parameter.g_query_find is set to 'True',
then call pre-query, the satisfaction of the IF in the trigger pre-query is parameter.g_query_find = 'true', so the system is queried by query condition.
참조 :
반응형
'Oracle - Forms > Forms 문법 관련' 카테고리의 다른 글
Oracle Forms - 문법 - USING SYSTEM VARIABLES (시스템 변수 사용) (0) | 2022.01.24 |
---|---|
Oracle Forms - 문법 - TRIGGER를 PROCEDURE화 (0) | 2022.01.24 |
Oracle Forms - 문법 - APP_ORDER_BY.APPEND (0) | 2022.01.24 |
Oracle Forms - 문법 - APP_QUERY.RESET (0) | 2022.01.23 |
Oracle Forms - 문법 - SYSTEM.CURSOR_ITEM (0) | 2022.01.23 |