Specifying LOV Return Items Using Column Properties
To specify an LOV return item:
- Select the LOV in the Object Navigator.
- Select Tools | LOV Wizard.
- Click the Column Display tab at the top of the
Wizard.
- All columns in the LOV are Listed in the table. Change the Return Value
for the column to the name of the desired return item. You can use the Look
up return item button to help you find the correct return item for
the column.
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.
- Select the desired column in the Column Names
List.
- In the Return Item field, enter a name (item,
global variable, or parameter).
Tip: If you do not want a column to be returned, leave the Return Item property blank.
Related topics
Specifying LOV return items in the SELECT statement
LOV Wizard: Column Display page