Deletes a specific list element from a list item.
Built-in Type unrestricted procedure
Enter Query Mode yes
Specifies the unique ID that Form Builder 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.
The name you gave to the list item when you created it. The data type of
the name is VARCHAR2.
Specifies the list index value. The list index is 1 based.
• Do not use the DELETE_LIST_ELEMENT built-in if the Mapping of Other Values property is
defined and there are queried records in the block. Doing so may cause Form Builder to be unable
to display records that have already been fetched.
For example, assume that a list item contains the values A, B, and C and the Mapping of Other Values
property is defined. Assume also that these values have been fetched from the database (a query is
open). At this point, if you delete B from the list using DELETE_LIST_ELEMENT, an error will
occur because Form Builder will attempt to display the previously fetched values (A, B, and C), but
will be unable to because B was deleted from the list.
Before deleting a list element, close any open queries. Use the ABORT_QUERY built-in to close an
Note: A list does not contain an other values element if none was specified at design time or if it was
programmatically deleted from the list at runtime.
For a Poplist or T-list-style list item, Form Builder returns
error FRM-41331: Could not delete element from <list_item> if
you attempt to delete the default value element.
The default value element is the element whose label or value was specified at design time for the Initial
Value property setting.