Sparse

Description

The names of repeating columns that will be suppressed in the DataWindow.

Applies to

DataWindows

Syntax

PowerBuilder dot notation:

dw_control.Object.DataWindow.Sparse

Describe and Modify argument:

"DataWindow.Sparse { = ' list ' }"

Parameter

Description

list

(exp) A tab-separated list of column names to be suppressed. List can be a quoted DataWindow expression.

Create method (include at the end of the DataWindow syntax):

Sparse ( names = "col1~tcol2~tcol3 ...")

Usage


In the painter

Set the value using Rows>Suppress Repeating Values. This property is not supported in Web DataWindows.

Examples

Example 1

string setting

setting = dw1.Object.DataWindow.Sparse

dw1.Object.DataWindow.Sparse = 'col1~tcol2'

Example 2

setting = dw1.Describe("DataWindow.Sparse")

dw1.Modify("DataWindow.Sparse='col1~tcol2'")