Where i can use Clear_List? [message #406297] |
Wed, 03 June 2009 03:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mm_kanish05
Messages: 493 Registered: January 2007 Location: Chennai
|
Senior Member |
![mm_kanish05%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi,
I have two list item in my form.
1.stagetype
2.stageno
Whenever a stagetype chassised associated stageno only be in the stageno list.
So i used the code like below on Key-next-item of Stagetype
Declare
cnt Number := 1;
Begin
Clear_List('Stage_type');
For i in (select stageno from Stage_Master where Stage_type = :Stage_type) Loop
Add_List_Element('stageno',cnt,i.stageno,i.Stageno);
cnt := Cnt+1;
End Loop;
End;
but i am getting the following error
frm-41331: Could not delete item from Stageno
Then where i can user clear_list (but i want clear and change the list when stage_type changed)
please suggest me some ideas.
kanish
[Updated on: Wed, 03 June 2009 04:18] Report message to a moderator
|
|
|
|
|
Re: Where i can use Clear_List? [message #406487 is a reply to message #406411] |
Thu, 04 June 2009 04:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
mm_kanish05 wrote on Thu, 04 June 2009 05:16 | Hi,
What you mean by other value element?
|
look up mapping of other value in forms help
Quote: |
I check my System.Mode, it is "Normal", So it not in query or changed record.
|
You're checking the wrong thing. system.mode only tells you if you're in enter-query mode or not.
You need to check get_block_property(<block>, status);
|
|
|
|
|
|
Re: Where i can use Clear_List? [message #407330 is a reply to message #406967] |
Tue, 09 June 2009 12:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raavi_13
Messages: 12 Registered: June 2009 Location: MUMBAI
|
Junior Member |
|
|
Hi,
clear_list doesnt work in your case..i had the same problem while developing a form...at that time i had choosen lov's instead of list.....try it...if u need any help in creating lov's ask me i will help you out in that...
|
|
|
|