LOV should not repeat values [message #487649] |
Wed, 29 December 2010 04:51 |
deepak3arora
Messages: 32 Registered: October 2009 Location: chandigarh
|
Member |
|
|
Hello All,
I need my Forms 10g List of Values(LOV) not to repeat values.
Test Case : MY Lov record Group Query is : select student_name from students;
Students Table contains Id:1 student_name : Deepak ;
Id:2 student_name : Rajeev ; Id:3 student_name : Rohit
now on selecting the LOV thru forms i select "Deepak". On creating one more record i want that LOv should show only two records Rajeev and Rohit and thereon with more records creation.
It should function all this without commiting the records to database.
Please if anyone can Help with it!!!!
|
|
|
Re: LOV should not repeat values [message #487652 is a reply to message #487649] |
Wed, 29 December 2010 05:28 |
imedmy
Messages: 16 Registered: November 2009 Location: tunis
|
Junior Member |
|
|
hi
what you have to do is
when validating record you have to set lov property i think recodr_group and you have to use a procedure called post
exemple
post;
set_lov_property ('lov_name',record_group,'
select blabla from ur_table t
where not exists (select 1 from table_of_block tt
tt.(key) = t.(migrated key))')
|
|
|