4 Replies Latest reply: Feb 6, 2013 4:11 AM by HamidHelal RSS

    Enter Query with Lov

    Moazam Shareef
      Guyz,

      i'm making one form where the below things are required, but i'm unable to achieve this.

      i put the below code on KEY-F3 (KEY-DUP-ITEM)
      DECLARE
           MSGLVL          VARCHAR2(3);
           LOV     BOOLEAN;
      BEGIN
           MSGLVL:=:SYSTEM.MESSAGE_LEVEL;
           :SYSTEM.MESSAGE_LEVEL:=20;
      IF :SYSTEM.MODE='NORMAL' THEN
      LOV := SHOW_LOV('PAT_NAME_EN');
      ENTER_QUERY;
      END IF;
      END;
      
      BEGIN
      GO_ITEM('MN_PAT_REG.NAME1_EN');
                SET_BLOCK_PROPERTY('MN_PAT_REG', DEFAULT_WHERE, 'PAT_ID=:MN_PAT_REG.BLK');
                EXECUTE_QUERY;
      END;
      This will show the LOV but after seleting lov the form enter in ENTER-QUERY mode I move the ENTER-QUERY line above the LOV := SHOW_LOV('PAT_NAME_EN') but its not showing any lov where the form goes enter-query and restrict to show the lov. here my requirement is when user press F3 key clear form no validate then forms goes in ENTER-QUERY mode and shows the lov and when user select the record this will execute the query or if user didnt choose the record from lov or cancel lov then form goes into normal mode from.

      Regards