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 window, Behavior category.

When EditStyle is DropDownListBox, click the Values browse button to fill in the Display Value and Data Value columns for the code table.

When Style is Edit or EditMask, set the CodeTable property and click the Values browse button to fill in the Display Value and Data Value columns for the code table.

Examples

Example 1

[Visual Basic]
setting = dw1.Describe("emp_status.Values")

Example 2

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