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

FIND_ITEM Built-in

Description

Searches the list of items in a given block and returns an item ID when it finds a valid item with the given name. You must define an appropriately typed variable to accept the return value. Define the variable with a type of Item.

Syntax

FUNCTION FIND_ITEM
(block.item_name VARCHAR2);

Built-in Type unrestricted function

Returns Item

Enter Query Mode yes

Parameters

block_name.item_name 
 
Specifies the fully qualified item name. The data type of the name is VARCHAR2.

FIND_ITEM Examples

/*

** Built-in: FIND_ITEM
** Example: Find an item's Id before setting several
** of its properties.
*/
PROCEDURE Hide_an_Item( item_name VARCHAR2, hide_it BOOLEAN) IS
it_id Item;
BEGIN
it_id := Find_Item(item_name);
IF Id_Null(it_id) THEN
Message('No such item: '||item_name);
RAISE Form_Trigger_Failure;
ELSE
IF hide_it THEN
Set_Item_Property(it_id,VISIBLE,PROPERTY_FALSE);
ELSE
Set_Item_Property(it_id,VISIBLE,PROPERTY_TRUE);
Set_Item_Property(it_id,ENABLED,PROPERTY_TRUE);
Set_Item_Property(it_id,NAVIGABLE,PROPERTY_TRUE);
END IF;
END IF;
END;


Referencing Oracle Forms objects by internal ID