OraFAQ Forum: Forms => add_list

Members

Help

Home

Home » Developer & Programmer » Forms » add_list_element Problem (database 10g , forms 6i , win XP SP2)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

add_list_element Problem [message #319044]

Thu, 08 May 2008 15:56

Hany Freedom
Messages: 208
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.

Attachment: LIST_NOTWORK.fmb
(Size: 48.00KB, Downloaded 29 time(s))

Report message to a moderator

Re: add_list_element Problem [message #319089 is a reply to message #319044 ]

Fri, 09 May 2008 00:41

djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia

Senior Member

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

Report message to a moderator

Re: add_list_element Problem [message #319183 is a reply to message #319089 ]

Fri, 09 May 2008 05:00

Hany Freedom
Messages: 208
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.

Attachment: LIST_NOTWORK.fmb
(Size: 48.00KB, Downloaded 26 time(s))

Report message to a moderator

Re: add_list_element Problem [message #319737 is a reply to message #319183 ]

Mon, 12 May 2008 21:03

djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia

Senior Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 03:01:11 CDT 2008

Total time taken to generate the page: 0.03034 seconds

.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.