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

SET_LOV_COLUMN_PROPERTY Built-in

Description

Sets the given LOV property for the given LOV.

Syntax

SET_LOV_COLUMN_PROPERTY
(lov_id LOV,
colnum
NUMBER,
property
NUMBER,
value
VARCHAR2);

SET_LOV_COLUMN_PROPERTY
(lov_name VARCHAR2,
colnum
NUMBER,
property
NUMBER,
value
VARCHAR2);

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).
 
colnum 
 
Specifies the column to be modified (as a NUMBER). The first column is column 1.
 
property 
 
Specifies the property you want to set for the given LOV. The possible properties are as follows:

TITLE Sets the Column Title property that controls the title that displays above an LOV column.

Note: Setting the column title to NULL resets the column title to the title specified at design time.

WIDTH Specifies the width to be reserved in the LOV for displaying column values.

Note: Setting the column width to NULL results in a hidden, or non-displayed, column.

value 
 
The VARCHAR2 or NUMBER value that represents the desired property setting.