Oracle Forms: Add List Element

Built-in support for ADD LIST ELEMENT

Description

Adds a single item to a list item that has already been created.

Syntax

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

PROCEDURE ADD_LIST_ELEMENT (list_id ITEM,

list_index VARCHAR2, list_label VARCHAR2, list_value NUMBER);

Built-in Type  unrestricted procedure

Enter Query Mode  yes

Parameters

list_id

Specifies the one-of-a-kind ID that will be assigned to the list item by Form Builder when it is created. Make use of the built-in FIND ITEM function to return the ID to a variable of the right type. ITEM is the data type that the ID is stored as.

list_name 

The name that you designated for the list item at the time that it was created. The name is stored as data using the VARCHAR2 data type.

list_index

Identifies the value of the list index. The index of the list starts at 1.

list_label

This parameter allows you to provide the VARCHAR2 string that will be shown as the label of the list element.

list_value

The actual value of the list element that you want to add to the item on the list.

Constraints on the ADD LIST ELEMENT variable:

Form Builder will not let you add another values element to a base table list if the List Style attribute has been set to Poplist or T-list. This is the case whether or not the block already includes queried or updated data. This action will result in an error. If you had previously used the DELETE LIST ELEMENT or CLEAR LIST functions to delete the other values element from the list, which was indicated at design time by the Mapping of Other Values list item property setting, then you may find yourself in the predicament described above.

Note: When a block includes records that have been queried, the state of the block is changed to QUERY. When a block includes records that have been either added or changed, the status of the block is considered to have been CHANGED.

Examples of ADD LIST ELEMENT

/*

**    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;

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.