QuerySort

Description

Whether the result set is sorted when the DataWindow retrieves the data specified in query mode. When query sort is on, the user specifies sorting criteria in the first row of the query form.

DataWindow presentation styles You cannot use QuerySort with DataWindow objects that use any of the following presentation styles: N-Up, Label, Crosstab, RichText, and Graph.

Applies to

DataWindows

Syntax

PowerBuilder dot notation:

dw_control.Object.DataWindow.QuerySort

Describe and Modify argument:

"DataWindow.QuerySort { = value }"

Parameter	Description
value	Whether the data retrieved from query mode specifications is sorted. Values are: Yes – Sorting is enabled. No – Sorting is disabled.

Parameter

Description

value

Whether the data retrieved from query mode specifications is sorted.

Values are:

Yes – Sorting is enabled.
No – Sorting is disabled.

Usage

If the DataWindow is not already in query mode, setting QuerySort to Yes also sets QueryMode to Yes, putting the DataWindow in query mode.

When you set QuerySort to No, the DataWindow remains in query mode until you also set QueryMode to No.

Query mode and secondary DataWindows

When you are sharing data, you cannot turn on query mode for a secondary DataWindow. Trying to set the QueryMode or QuerySort properties results in an error.

Examples

Example 1

string setting

setting = dw1.Object.DataWindow.QuerySort

Example 2

dw1.Object.DataWindow.QuerySort = "yes"

Example 3

setting = dw1.Describe("DataWindow.QuerySort")
dw1.Modify("DataWindow.QuerySort=yes")