Home » Developer & Programmer » Forms » During The LOV. Not Select Previously Selected Value (Windows XP)
During The LOV. Not Select Previously Selected Value [message #326141] Tue, 10 June 2008 05:27 Go to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Hi, Good Afternoon

I Need to known, When the List of Value (LOV) on Forms has been used, After the Selection of one Document if it possible to not view the selected document.


Eg: (LOV Contain)

Documentno
52060001
52060002
52060003
52060004


I Selected the Documentno has 52060003. After the selection I select another documentno for the continus of the Entry. They were List of Value Display Follows like.

Documentno
52060001
52060002
52060004

If it possible. Please Reply me.




Re: During The LOV. Not Select Previously Selected Value [message #326258 is a reply to message #326141] Tue, 10 June 2008 22:03 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
You can change your record group at run time... I think that 'll help your case... but to do that each time when user selects a value u need to delete that value from your record group... i mean the source(table/view...) for that record group...
Re: During The LOV. Not Select Previously Selected Value [message #335413 is a reply to message #326141] Tue, 22 July 2008 02:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: During The LOV. Not Select Previously Selected Value [message #335471 is a reply to message #326141] Tue, 22 July 2008 04:52 Go to previous messageGo to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi
if you use
Table1 >> source of LOV
table2 >> destination table , then

at LOV wizard in Query section you can modify your query
to be
SELECT table1.documentno
  FROM table1
 WHERE table1.documentno NOT IN (SELECT table2.documentno
                                 FROM table2)

at run time LOV will ignore the selected data

[Updated on: Tue, 22 July 2008 04:57]

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #351969 is a reply to message #326141] Sat, 04 October 2008 01:26 Go to previous messageGo to next message
rajarshi_mcasmit
Messages: 7
Registered: September 2008
Location: DELHI
Junior Member
cvs_1984 wrote on Tue, 10 June 2008 05:27
Hi, Good Afternoon

I Need to known, When the List of Value (LOV) on Forms has been used, After the Selection of one Document if it possible to not view the selected document.


Eg: (LOV Contain)

Documentno
52060001
52060002
52060003
52060004


I Selected the Documentno has 52060003. After the selection I select another documentno for the continus of the Entry. They were List of Value Display Follows like.

Documentno
52060001
52060002
52060004

If it possible. Please Reply me.






I am also facing same type of problem like at the run time a lov display 10 student name.A block name B3 when first time one name is selected from the lov and in same block before saving data i again open lov which should have 9 record...
Re: During The LOV. Not Select Previously Selected Value [message #351976 is a reply to message #335413] Sat, 04 October 2008 03:41 Go to previous messageGo to next message
rajarshi_mcasmit
Messages: 7
Registered: September 2008
Location: DELHI
Junior Member
I am facing same type of problem,i also search on fourm.But answer is not satisfactory because answer use source table or destination table.But in my case
1st time open the lov then following item populate like

studeent01
studeent02
studeent03.

after one studeent01 item added in from and open same lov then lov should populate like


studeent02
studeent03.

I am also send you snap shot for the same.
  • Attachment: lov.txt
    (Size: 78.97KB, Downloaded 683 times)
Re: During The LOV. Not Select Previously Selected Value [message #352260 is a reply to message #351976] Mon, 06 October 2008 22:17 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/351753/67467/?srch=form_commit+record_group#msg_351753

David
Re: During The LOV. Not Select Previously Selected Value [message #378973 is a reply to message #352260] Sat, 03 January 2009 05:49 Go to previous message
kamar_19
Messages: 52
Registered: June 2005
Location: pakistan
Member
aoa
u can change record group query at runtime and in that query u can add NOT IN statement to avoid the selected items.
u can make a list of all these items which have been already selected by making a loop from first record of block to the last record.

example code is written below.
suppose u have emp nos to display in lov.
DECLARE 
	curr_rec number;
	last_rec number;
	employees varchar2(1000):='1';
	sql_query varchar2(2000);
	status number;
BEGIN
	curr_rec:=to_number(:System.Cursor_Record);
	last_record;
	last_rec:=to_number(:System.Cursor_Record);
	first_record;
	for j in 1..last_rec loop
		if :emp_no is not null then
	          employees:=employees||','||:emp_no;
		end if;
		next_record;
	end loop;
	go_record(curr_rec);
        sql_query:=' select emp_no from employees where emp_no   not in ('||employees||')';
	status := Populate_Group_with_query ('EMP',sql_query); 
	Set_LOV_Property('EMP',GROUP_NAME,'EMP'); 
	Go_item(EMP_NO);
	List_Values;

end;

best regards

Qamar abbas

[EDITED by LF: applied [code] tags]

[Updated on: Sat, 03 January 2009 08:18] by Moderator

Report message to a moderator

Previous Topic: I Don't want to enter date multiple time in form
Next Topic: Short Cut Key like alt+s to save
Goto Forum:
  


Current Time: Sun Dec 04 10:44:54 CST 2016

Total time taken to generate the page: 0.10307 seconds