How code tables are implemented
You can define a code table as a property of the following
column edit styles:
-
Edit
-
DropDownListBox
-
RadioButtons
-
DropDownDataWindow
-
EditMask, using spin control
The steps to specify the code table property for each edit style
are similar: you begin by defining a new edit style in the Database
painter. Once you select an edit style, use the specific procedure
that follows to define the code table property.
For how to create an edit style, see About edit styles.
Allowing null values
An internal PowerBuilder code, NULL!, indicates null values
are allowed. To use this code, specify NULL! as the data value, then
specify a display format for nulls for the column.
To define a code table as a property of the Edit edit
style
-
Select the Use Code Table check box.
-
Enter the display and data values for the code table.
-
If you want to restrict input in the column to values in the
code table, select the Validate check box.For more information, see Validating
user input.
To define a code table as a property of the DropDownListBox
edit style
-
Enter the display and data values for the code table.
-
If you want to restrict input in the column to values in the
code table, clear the Allow Editing check box.For more information, see Validating
user input.
To define a code table as a property of the RadioButtons edit
style
-
Enter the display and data values for the code table.
To define a code table as a property of the
DropDownDataWindow edit style
-
Specify the column that provides the display values in the
Display Column box. -
Specify the column that provides the data values in the Data
Column box. -
If you want to restrict input in the column to values in the
code table, clear the Allow Editing check box.
To define a code table as a property of the EditMask edit
style
-
Select the Spin Control check box.
-
Select the Code Table check box.
-
Enter the display and data values for the code table.