ClearValues

Description

Deletes all the items from a value list or code table associated with a DataWindow column. (A value list is called a code table when it has both display and data values.) ClearValues does not affect the data stored in the column.

Applies to

DataWindow type

Method applies to

PowerBuilder

DataWindow control, DataWindowChild object, DataStore object


Syntax

PowerBuilder

integer dwcontrol.ClearValues ( string column )
integer dwcontrol.ClearValues ( integer column )

Argument

Description

dwcontrol

A reference to a DataWindow control or DataStore.

column

The column whose value list you want to delete. Column can be a column number (integer) or a column name (string).


Return value

Returns 1 if it succeeds and -1 if an error occurs. The return value is usually not used.

Usage

The edit style of the column can be DropDownListBox, Edit, or RadioButton. ClearValues has no effect when column has the EditMask or DropDownDataWindow edit style.

Examples

This statement clears all values from the drop-down list of dw_Employee's status column:

dw_Employee.ClearValues("status")

See also

GetValue

SetValue