Home » Developer & Programmer » Forms » List Of Value Using The KEY-F9 Trigger (Oracle 9i , forms and reports 6i)
List Of Value Using The KEY-F9 Trigger [message #337668] Thu, 31 July 2008 10:12 Go to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Hi,

I need help for the LOV display.

I using the two type of function in the entry screen they were each one contain different LOV's.

I want to display the LOV through trigger of KEY-F9 and Writed trigger given below.


If Substr(:Pmlmain.Pmlnumber,3,3) not in ('506') Then
	  Declare
		  KK Boolean;
	  Begin
		  KK := Show_Lov('LOVPART');
	  End;
	
	Else
    Declare
		  KK Boolean;
	  Begin
  		KK := Show_Lov('LOVSUP');
	  End;
End if;


During the Entry time the error Display has

FRM-41800. List of Value not available for this Field

Please give me the solution for this.

Thanking You.

CVS

Re: List Of Value Using The KEY-F9 Trigger [message #337683 is a reply to message #337668] Thu, 31 July 2008 11:32 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Simply, there's no List of Values set for this item. So, open item's Property Palette and set "List of Values" property.

/forum/fa/4714/0/
  • Attachment: lov.PNG
    (Size: 2.48KB, Downloaded 6142 times)
Re: List Of Value Using The KEY-F9 Trigger [message #339585 is a reply to message #337668] Thu, 07 August 2008 21:15 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use 'set_item_property(lov_name)' to change between two LOVs for a particular item.

David
Re: List Of Value Using The KEY-F9 Trigger [message #340499 is a reply to message #339585] Wed, 13 August 2008 02:25 Go to previous message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member


Thank you
Previous Topic: Query
Next Topic: sending message
Goto Forum:
  


Current Time: Mon Feb 10 00:11:26 CST 2025