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

Adding a Column to an LOV

To add a column to an LOV:

  1. Select the LOV in the Object Navigator.
  2. Select Tools | LOV Wizard.
  3. Click the Columns tab at the top of the Wizard.
  4. 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 button to move a single item. To add all the columns, click button to move all items.

or

  1. In the Object Navigator LOVs node, double-click the object icon beside the desired LOV to display the Property Palette.
  2. Under the Functional node, double-click on Column Mapping Properties. The LOV Column Mapping dialog appears.
  3. Type the name of the record group column you wish to add to the LOV in the Column Names List.
  4. 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.


LOV Wizard: Column Selection page