Column Mapping Properties Property
Description
The Column Mapping Properties group includes Column Name, Column Title, Display Width, and Return Item.
Applies to LOV
Set Oracle Forms
Column Name
Specifies the names of the columns in an LOV.
Required/Optional At least one column must be defined.
The names of the columns in the underlying record group.
Usage Notes
The column names must adhere to object naming standards.
Column Title
Specifies the title that displays above the column currently selected in the column name list.
Display Width
Specifies the width for the column currently selected in the Column Name list.
Required/Optional optional
Usage Notes
- Set the Display Width property to the width in appropriate units (points,
pixels, centimeters, inches, or characters as specified by the form's Coordinate
System property) that you want Oracle Forms to reserve for the column in
the LOV window. Column value truncation may occur if the Display Width is
smaller than the width of the column value. To avoid this situation, increase
the Display Width for the column.
- To make the column a hidden column, set Display Width to 0. (You can specify
a return item for a hidden column, just as you would for a displayed column.)
- To add extra space between columns in the LOV window, set the Display Width
wider than the column's default width. Note, however, that as an exception
to this rule, you cannot increase the width between a NUMBER column and a
non-NUMBER column by increasing the display width for the NUMBER column because
LOVs display numbers right-justified. For example, assume that your LOV contains
3 columns: column 1 and 3 are type CHAR and column 2 is type NUMBER. To increase
the width between each column, increase the Display Width for columns 1 and
3.
Return Item
Specifies the name of the form item or variable to which Oracle Forms should assign the column's value whenever the operator selects an LOV record.
NULL
Required/Optional optional
Usage Notes
The Return Item can be any of the following entries:
- form item (block_name.item_name)
- form parameter (PARAMETER.my_parameter)
- global parameter (GLOBAL.my_global)
Do not put a colon in front of the object name.