Oracle - Forms/Forms 문법 관련
Oracle Forms - 문법 - :PARAMETER.G_QUERY_FIND := 'TRUE OR FALSE';
bok01
2022. 1. 23. 15:50
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.
참조 :
반응형