Home » Developer & Programmer » Forms » forms lov change (Oracle forms 10G)
forms lov change [message #565948] Mon, 10 September 2012 00:44 Go to next message
shanmugait
Messages: 3
Registered: June 2012
Location: CHENNAI
Junior Member
Hello everyone!

Iam new for forms.....

I need one help in forms..

I have one multi record block in that i have one LOV..If i choose lov in first record that won't be display in second record lov .....

Please urgent...anyone help me...
Re: forms lov change [message #565963 is a reply to message #565948] Mon, 10 September 2012 02:39 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
If i choose lov in first record that won't be display in second record lov

What do you mean by that?
Re: forms lov change [message #565981 is a reply to message #565963] Mon, 10 September 2012 05:02 Go to previous messageGo to next message
shanmugait
Messages: 3
Registered: June 2012
Location: CHENNAI
Junior Member
It means i don't want to display LOV list again, i already selected before ....

Actually my requirement is

1. I have rack no for my LOV

2. For Ex.

A1,A2,A3,A4,A5

3. I select A1 for my first record
4. Then A1 should not come to further Record LOV and like that i want...

Thanks

[Updated on: Mon, 10 September 2012 05:03]

Report message to a moderator

Re: forms lov change [message #565984 is a reply to message #565981] Mon, 10 September 2012 05:23 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
POST changes you've made in a form (for example, in a WHEN-NEW-RECORD-INSTANCE trigger). Doing so, list of values would (in a new record) "see" that this value has already been entered and wouldn't display it again. You'd fix that in its WHERE clause; something like
where lov_column not in (select lov_column from that_table
                         where id = :block.id)
Re: forms lov change [message #565991 is a reply to message #565984] Mon, 10 September 2012 06:02 Go to previous message
shanmugait
Messages: 3
Registered: June 2012
Location: CHENNAI
Junior Member
Thank you very much
Previous Topic: How to drop and create constraints with forms_ddl
Next Topic: Query mode not working at once the form is opened
Goto Forum:
  


Current Time: Wed Jul 30 11:14:46 CDT 2014

Total time taken to generate the page: 0.08487 seconds