2 Replies Latest reply: May 25, 2012 2:59 PM by DanielB RSS

    Dynamiclly changing the block property

    MST
      Hi,

      I am changig dynamically block block property based on menu. I am calling same form in different three menus.
      But below one not working. I added below code in pre-query.

      I quired JOC No. 7002114 for :PARAMETER.CRNT_STS = 'A' but it is showing first record 7002097. Not showing 7002114 .
      Please do the needful.
      --------------
      IF :PARAMETER.CRNT_STS = 'S' THEN
           SET_BLOCK_PROPERTY('B1',DEFAULT_WHERE,'WHERE GJM_JOC_CAT = ''O'' AND (GJM_CRNT_STS = ''U'' OR GJM_WRK_CPMLCTN_STS = ''U'') AND GJM_JOC_NO = NVL('||''''||*:B1.GJM_JOC_NO*||''''||',GJM_JOC_NO)');
      END IF;

      IF :PARAMETER.CRNT_STS = 'A' THEN
           SET_BLOCK_PROPERTY('B1',DEFAULT_WHERE,'WHERE (GJM_JOC_CAT = ''O'' AND (GJM_CRNT_STS = ''S'' OR GJM_WRK_CPMLCTN_STS = ''S''))
      OR (GJM_JOC_CAT = ''R'' AND (GJM_CRNT_STS = ''U'' OR GJM_WRK_CPMLCTN_STS = ''U'')) AND GJM_JOC_NO = NVL('||*:B1.GJM_JOC_NO*||',GJM_JOC_NO)');
      END IF;
      --------------