Adding a Column to an LOV
To add a column to an LOV:
- Select the LOV in the Object Navigator.
- Select Tools | LOV Wizard.
- Click the Columns tab at the top of the Wizard.
- Columns Listed under Record Group Columns are those that are not currently
included in the LOV. To add a single column, select the desired column and
click
.
To add all the columns, click
.
or
- In the Object Navigator LOVs node, double-click
the object icon beside the desired LOV to display the Property Palette.
- Under the Functional node, double-click on Column
Mapping Properties. The LOV Column Mapping dialog appears.
- Type the name of the record group column you wish to add to the LOV in the
Column Names List.
- 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.
Note: The Display Width property defaults to the width specified for the column in the record group. If the record group is a query record group, the default width is the width of the corresponding database column at the time the record group was created.
Tip: 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.
Related topic
LOV Wizard: Column Selection page