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

SET_LOV_PROPERTY Built-in

Description

Sets the given LOV property for the given LOV.

Syntax

SET_LOV_PROPERTY
(lov_id LOV,
property
NUMBER,
value
NUMBER);

SET_LOV_PROPERTY
(lov_name VARCHAR2,
property
NUMBER,
value
NUMBER);

SET_LOV_PROPERTY
(lov_id LOV,
property
NUMBER,
x
NUMBER,
y
NUMBER);

SET_LOV_PROPERTY
(lov_name VARCHAR2,
property
NUMBER,
x
NUMBER,
y
NUMBER);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

lov_id 
 
Specifies the unique ID that Oracle Forms assigns the LOV when created. Use the FIND_LOV Built-in to return the ID to an appropriately typed variable. The data type of the ID is LOV.
 
lov_name 
 
Specifies the LOV name (as a VARCHAR2).
 
property 
 
Specifies the property you want to set for the given LOV. The possible properties are as follows:

AUTO_REFRESH Specifies whether Oracle Forms re-executes the query each time the LOV is invoked.

GROUP_NAME Specifies the record group with which the LOV is associated.

LOV_SIZE Specifies a width, height pair indicating the size of the LOV.

POSITION Specifies an x, y pair indicating the position of the LOV.

TITLE Specifies the title of the LOV. Overrides the value specified in Oracle Forms unless the property value is NULL.

value 
 
Specify one of the following constants:

PROPERTY_TRUE Specifies that the property is to be set to the TRUE state.

PROPERTY_FALSE Specifies that the property is to be set to the FALSE state.

Recordgroup Name
 
Specify the VARCHAR2 name of the record group you are setting. You can create this record group in Oracle Forms or programmatically, as long as the record group exists when the SET_LOV_PROPERTY is called.
 
x 
 
Specify either the x coordinate or the width, depending on the property you specified.
 
y 
 
Specify either the y coordinate or the height, depending on the property you specified.

SET_LOV_PROPERTY Restrictions

SET_LOV_PROPERTY Examples

/*

** Built-in: SET_LOV_PROPERTY
** Example: if LOV is currently base on GROUP1,
** make LOV use GROUP2
*/
DECLARE
lov_id LOV;
BEGIN
lov_id := Find_LOV('My_LOV_1');
IF Get_LOV_Property(lov_id,GROUP_NAME) = 'GROUP1' THEN
Set_LOV_Property(lov_id,GROUP_NAME,'GROUP2');
ENDIF;
END;