Sparse DataWindow object property

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

DataWindows

PowerBuilder dot notation:

<span>dw_control</span>.Object.DataWindow.Sparse

1	<span>dw_control</span>.Object.DataWindow.Sparse

Describe and Modify argument:

"DataWindow.Sparse { = ' <span>list</span> ' }"

1	"DataWindow.Sparse { = ' <span>list</span> ' }"

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 = "<span>col1</span>~t<span>col2</span>~t<span>col3 ...</span>")

1	Sparse ( names = "<span>col1</span>~t<span>col2</span>~t<span>col3 ...</span>")

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

string setting

1	string setting

setting = dw1.Object.DataWindow.Sparse

1	setting = dw1.Object.DataWindow.Sparse

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

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

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

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

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

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

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.6

August 14, 2023

Was this article helpful?

0 Comments

Inline Feedbacks

View all comments

Sparse – PB Docs 126