본문 바로가기

Oracle - Forms/Forms 문법 관련

Oracle Forms - 문법 - :PARAMETER.G_QUERY_FIND := 'TRUE OR FALSE';

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.

참조 :

https://programmerall.com/article/38551630540/

반응형