A script-enabled browser is required for this page to function properly.

ADD_LIST_ELEMENT Built-in

Description

Adds a single element to a list item.

Syntax

PROCEDURE ADD_LIST_ELEMENT
(list_name VARCHAR2,
list_index,
NUMBER,
list_label
VARCHAR2,
list_value
VARCHAR2);

PROCEDURE ADD_LIST_ELEMENT
(list_id ITEM,
list_index
VARCHAR2,
list_label
VARCHAR2,
list_value
VARCHAR2);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

list_id 
 
Specifies the unique ID that Oracle Forms assigns when it creates the list item. Use the FIND_ITEM Built-in to return the ID to an appropriately typed variable. The data type of the ID is ITEM.
 
list_name 
 
The name you gave to the list item when you created it. The data type of the name is VARCHAR2.
 
list_index 
 
Specifies the list index value. The list index is 1 based.
 
list_label 
 
Specifies the VARCHAR2 string that you want displayed as the label of the list element.
 
list_value 
 
The actual list element value you intend to add to the list item.

ADD_LIST_ELEMENT Restrictions

For a base table list with the List Style property set to Poplist or T-list, Oracle Forms does not allow you to add another values element when the block contains queried or changed records. Doing so causes an error. This situation can occur if you have previously used DELETE_LIST_ELEMENT or CLEAR_LIST to remove the other values element that was specified at design time by the Mapping of Other Values list item property setting.

Note: The block status is QUERY when a block contains queried records. The block status is CHANGED when a block contains records that have been either inserted or updated.

ADD_LIST_ELEMENT Examples

/* ** Built-in: ADD_LIST_ELEMENT
** Example: Deletes index value 1 and adds the value "1994" to
** the list item called years when a button is pressed.
** Trigger: When-Button-Pressed
*/
BEGIN
Delete_List_Element('years',1);
Add_List_Element('years', 1, '1994', '1994');
END;