PickList property editor

This is a feature of JBuilder Professional and Enterprise.

Use the PickList property editor to set properties associated with a picklist or lookup relationship between two DataSet objects.

To display this property editor, choose the pickList property from the Inspector when any Column of a StorageDataSet is selected in the structure pane. The values specified in this dialog are stored in an instance of a PickListDescriptor object.

You can use the pickList field for providing values to a column using a picklist to enter a new value to a column, and it also covers creating a lookup that will display values from another column. The links are to topics in the Database Application Developer's Guide book.

For more information on creating pick lists, see the class description for PickListDescriptor.

Picklist/Lookup Dataset

Select the DataSet object that contains the data for display in the pick list. The data set must be instantiated to display in this list.

When a DataSet is selected, the grid fills with the following data:

The DataSet name Read-only property that displays a list of all columns in the DataSet specified in the Picklist/Lookup Dataset field.
Data Type Read-only property that displays the data type of each column in the DataSet specified in the Picklist/Lookup Dataset field. The data type of the column determines what choices are displayed in the "destination" column drop down; only similar data types can be specified.
Show in picklist Select this option to select the Column components to read from when filling in data from the pick list DataSet into the columns specified in the "destination" Columns property.

If your pick list contains multiple columns, you must also set the itemEditor property of the Column. The default pick list item editor is the PickListItemEditor, which can only display picklist with a single column.

(DataSet name) Select the "destination" Column components to be filled in when an entry in the pick list is selected. This property is also used for the display of lookup values and if not set, your application may generate a java.lang.NullPointerException error.

Lookup Column To Display

Select the name of the Column in the pick list DataSet to display for this (the column whose pickList is being defined) column in data-aware controls.

Note: If you set this property but omit to specify a column in the "destination" column, your application will generate an error when run, likely a java.NullPointerException error.

Enforce Integrity

Select this option to have JBuilder enforce data constraints such as minimum or maximum value for the destination columns.