QueryMode

Description

Whether the DataWindow is in query mode. In query mode, the user can specify the desired data by entering WHERE criteria in one or more columns.

Applies to

DataWindows

Syntax

PowerBuilder dot notation:

dw_control.Object.DataWindow.QueryMode

Describe and Modify argument:

"DataWindow.QueryMode { = value }"

Usage

After the user specifies retrieval criteria in query mode, subsequent calls to Retrieve can use the new criteria. To retrieve data based on user selection, change the query mode back to No and use AcceptText to accept the user’s specification before the next call to Retrieve.

Setting QuerySort to Yes also puts the DataWindow into query mode, changing the QueryMode property’s value to Yes.

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.

A DataWindow cannot be in query mode when you call the RowsCopy method.

Examples

Example 1

string setting

setting = dw1.Object.DataWindow.QueryMode

Example 2

dw1.Object.DataWindow.QueryMode = "yes"

Example 3

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

Example 4

dw1.Modify("DataWindow.QueryMode=yes")