This discussion is archived
4 Replies Latest reply: Feb 6, 2013 2:11 AM by HamidHelal RSS

Enter Query with Lov

Moazam Shareef Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points