OraFAQ Forum: Forms » During The LOV. Not Select Previously Selected Value

Home » Developer & Programmer » Forms » During The LOV. Not Select Previously Selected Value (Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

During The LOV. Not Select Previously Selected Value [message #326141]

Tue, 10 June 2008 05:27

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.

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #326258 is a reply to message #326141]

Tue, 10 June 2008 22:03

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...

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #335413 is a reply to message #326141]

Tue, 22 July 2008 02:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #335471 is a reply to message #326141]

Tue, 22 July 2008 04:52

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

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...

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #351976 is a reply to message #335413]

Sat, 04 October 2008 03:41

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 1594 times)

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #352260 is a reply to message #351976]

Mon, 06 October 2008 22:17

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: During The LOV. Not Select Previously Selected Value [message #378973 is a reply to message #352260]

Sat, 03 January 2009 05:49

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 08 10:24:20 CST 2025