Home » Developer & Programmer » Forms » add_list_element Problem (database 10g , forms 6i , win XP SP2)
icon4.gif  add_list_element Problem [message #319044] Thu, 08 May 2008 15:56 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I made simple form for Departments table in hr schema .... and when I made the department_name column as a poplist it doesn't work correctly , even after I add this trigger "WHEN-NEW-ITEM-INSTANCE" on the item ( department_name ) :-
add_list_element('DEPARTMENT_NAME',1,:DEPARTMENTS.DEPARTMENT_NAME,:DEPARTMENTS.DEPARTMENT_NAME);

same problem happened.
so ..... what suppose to do until the column work correctly ?

please have a look to the attachment to understand what I mean.
Re: add_list_element Problem [message #319089 is a reply to message #319044] Fri, 09 May 2008 00:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Create a 'record_group' based on 'department_name', then an LOV which uses it and returns a value to the item in which you are interested, and then assocaite that LOV with your item.

David
icon4.gif  Re: add_list_element Problem [message #319183 is a reply to message #319089] Fri, 09 May 2008 05:00 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I'm not exactly understand what you meant ..... but I did LOV that retrieve the department_name values ...... but I don't know how can I associate that LOV with the poplist (department_name) .

I attached what I reached for.
Re: add_list_element Problem [message #319737 is a reply to message #319183] Mon, 12 May 2008 21:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Go to the property sheet of the item which is displayed on the canvas and set its 'List of Values (LOV)' property to the LOV that you have just created.

David
Previous Topic: Reports 10g
Next Topic: REP-52007 PARAMETER FORM ERROR
Goto Forum:
  


Current Time: Wed Dec 07 05:06:43 CST 2016

Total time taken to generate the page: 0.11748 seconds