This discussion is archived
9 Replies Latest reply: Mar 24, 2011 11:23 AM by Amatu Allah RSS

Show_lov in Enter-query-mode not working

836677 Newbie
Currently Being Moderated
I have a very basic problem. But unable to detect where I'm going wrong.
In Mouse-double-click for a particular item I need to display LOV and this should happen only when form in "enter_query" mode.
There fore, I wrote the below code in When-Mouse-Double-Click-trigger:
Declare
     l_chosen BOOLEAN;
Begin
     IF :SYSTEM.BLOCK_STATUS ='ENTER_QUERY' THEN
               GO_BLOCK('BL_VISIT');
         l_chosen:=Show_Lov('LOV_PATIENT_NO_NAME');     
  End If;
End;
But when the form in enter-query mode and I double click on the item the LOV doesn't display. :(

Legend

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