Home » Developer & Programmer » Forms » showing LOV in Query mode (oracle form 10g)
showing LOV in Query mode [message #429670] Thu, 05 November 2009 02:45 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
The procedure is :when I open the form ...I click F7 to go to Query mode then click F9 to show LOV...Chose one of the values from lov...the value goes to the text field... then when I press F9 ... showing all the records that has value chosen from lov in the text files.
LOV is working fine in normal mode ...but it is not working in Query mode.

but the problem is : now I'm showing lov but the problem is the value that I chosen from lov doesn't go to the text item in Query mode (but it goes in normal mode)..the text item stay empty and the pointer goes to the next field.

key_listval
========
if :system.record_status in ('NEW', 'INSERT') then
if :PYPSTSM_ACTIVE_IND = 'Y' then
if show_lov = (TRUE)
then
next_item;

end if;
end if;
end if;



IF :SYSTEM.MODE <> 'ENTER-QUERY' THEN
LIST_VALUES ;

END IF;

please help me with this issue.
Re: showing LOV in Query mode [message #429727 is a reply to message #429670] Thu, 05 November 2009 08:17 Go to previous message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
solved.
Previous Topic: Writing to excel using forms 10g, Apps setup
Next Topic: error in forms
Goto Forum:
  


Current Time: Fri Sep 20 07:22:04 CDT 2024