Values (for columns)

Description

The values in the code table for the column.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.Values { = ' string ' }"

Parameter	Description
columnname	The column for which you want to specify the contents of the code table.
string	(exp) A string containing the code table values for the column. In the string, separate the display values and the actual values with a tab character, and separate multiple pairs of values with a slash using this format: "displayval~tactualval/displayval~tactualval/ ..." For example: "red~t1/white~t2" String is quoted and can be a DataWindow expression.

Parameter

Description

columnname

The column for which you want to specify the contents of the code table.

string

(exp) A string containing the code table values for the column. In the string, separate the display values and the actual values with a tab character, and separate multiple pairs of values with a slash using this format:

"displayval~tactualval/displayval~tactualval/ ..."

For example:

"red~t1/white~t2"

String is quoted and can be a DataWindow expression.

Usage

In the painter

Select the control and set the value in the Properties view, Edit tab.

When Style Type is DropDownListBox, fill in the Display Value and Data Value columns for the code table.

When Style is Edit or EditMask, select the Use Code Table or Code Table check box and fill in the Display Value and Data Value columns for the code table.

Examples

Example 1

setting = dw1.Describe("emp_status.Values")

Example 2

dw1.Modify("emp_status.Values = 
'Active~tA/Part Time~tP/Terminated~tT'")