OraFAQ Forum: Forms » add_list

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

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

add_list_element Problem [message #319044]

Thu, 08 May 2008 15:56

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.

Attachment: LIST_NOTWORK.fmb
(Size: 48.00KB, Downloaded 1026 times)

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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: 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.

Attachment: LIST_NOTWORK.fmb
(Size: 48.00KB, Downloaded 1030 times)

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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: Sun Feb 09 06:12:15 CST 2025