Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding elements to List Item before starting

26875Apr 29 2002
Hello friends at www.oracle.com,

here I have many programs that use the same object - a list item -, and all these objects have the same elements inside it.

My goal is to insert these elements into the "Elements in list" property of the list item: when the program is opened, it:

1. Fires WHEN-NEW-FORM-INSTANCE or WHEN-WINDOW-ACTIVATED trigger
2. At the trigger, opens a cursor for selecting data from table elements_list (an example table that has the common elements)
3. Insert these selected items into the list item

Handling the trigger and opening the cursor is easy, but with which instruction should I insert the elements into the object so that the "Elements in list" property has these items inside when I execute the program?

The idea is to make maintenance easy: if I create a new element to this list, instead of opening each program that has this list, I just make an insertion to the table and it's solved: all programs that use the same object will automatically add the new element.

My problem is to know which instruction should be used to insert the table elements to the "Elements in list" property.

I searched for SET_ITEM_PROPERTY but I found nothing.

Best regards,

--
Franklin Gongalves Jr.
franklin@inf.trt9.gov.br
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2002
Added on Apr 29 2002
3 comments
915 views