Home » Developer & Programmer » Forms » Where i can use Clear_List? (Forms 6i)
Where i can use Clear_List? [message #406297] Wed, 03 June 2009 03:45 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

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 #406352 is a reply to message #406297] Wed, 03 June 2009 09:44 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member

mm_kanish05 wrote on Wed, 03 June 2009 14:15

frm-41331: Could not delete item from Stageno




Caused by one of the following:
You tried to delete the other values element when the block contained either queried or changed records.
You tried to delete an element from a list that does not contain an other values element when the block contained either queried or changed records.


Re: Where i can use Clear_List? [message #406411 is a reply to message #406297] Wed, 03 June 2009 23:16 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,

What you mean by other value element?

I check my System.Mode, it is "Normal", So it not in query or changed record.

kanish
Re: Where i can use Clear_List? [message #406487 is a reply to message #406411] Thu, 04 June 2009 04:08 Go to previous messageGo to next message
cookiemonster
Messages: 12404
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 #406509 is a reply to message #406297] Thu, 04 June 2009 06:07 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thank Cookiemonster,

You correct, as per get_block_property i am getting "Changed", What should i want to do to clear_list now.

kanish
Re: Where i can use Clear_List? [message #406576 is a reply to message #406509] Thu, 04 June 2009 12:51 Go to previous messageGo to next message
raavi_13
Messages: 12
Registered: June 2009
Location: MUMBAI
Junior Member
hi mm_kanish05 ,

clear_list('<blcoknam>.status_type');

let me know if its not works.

Regards
Ravi
Re: Where i can use Clear_List? [message #406967 is a reply to message #406297] Mon, 08 June 2009 00:42 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,

Raavi, I know how to clear the list. I am asking about violate the behaviour even when Block Status "Changed". Is there any possible?

kanish

Re: Where i can use Clear_List? [message #407330 is a reply to message #406967] Tue, 09 June 2009 12:23 Go to previous messageGo to next message
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...
Re: Where i can use Clear_List? [message #592137 is a reply to message #406297] Sun, 04 August 2013 03:46 Go to previous message
hilmy2010
Messages: 2
Registered: May 2007
Junior Member
create non database item and use it as list item
and handle selected value with triggers to set selected value for desired field
Previous Topic: REP-51002: Bind to Reports Server failed
Next Topic: Dynamically passing the Columns values
Goto Forum:
  


Current Time: Tue Dec 06 00:25:30 CST 2016

Total time taken to generate the page: 0.07485 seconds