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

CONVERT_OTHER_VALUE Built-in

Description

Converts the current value of a check box, radio group, or list item to the value associated with the current check box state (Checked/Unchecked), or with the current radio group button or list item element.

Syntax

PROCEDURE CONVERT_OTHER_VALUE
(item_id ITEM);

PROCEDURE CONVERT_OTHER_VALUE
(item_name VARCHAR2);

Built-in Type restricted procedure

Enter Query Mode yes

Parameters

item_id 
 
Specifies the unique ID that Oracle Forms assigns to the item when it creates the item. The data type of the ID is ITEM.
 
item_name 
 
Specifies the VARCHAR2 string you defined as the name of the item at design time.

CONVERT_OTHER_VALUE Restrictions

If the item is not a check box, radio group, or list item, Oracle Forms returns error FRM-41026: Item does not understand operation. To avoid this error, determine the item type by issuing a call to GET_ITEM_PROPERTY(item_name, ITEM_TYPE) before calling CONVERT_OTHER_VALUE.

CONVERT_OTHER_VALUE Examples

/*

** Built-in: CONVERT_OTHER_VALUE
** Example: Ensure that a particular checkbox's value
** represents either the checked or unchecked
** value before updating the record.
** Trigger: Pre-Update
*/
BEGIN
Convert_Other_Value('Emp.Marital_Status');
END;