QueryMode DataWindow object property
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.
DataWindow presentation styles
You cannot use QueryMode with DataWindow objects that use
any of the following presentation styles: N-Up, Label, Crosstab, RichText, and
Graph.
Controls
DataWindows
Syntax
PowerBuilder dot notation:
|
1 |
<span>dw_control</span>.Object.DataWindow.QueryMode |
Describe and Modify argument:
|
1 |
"DataWindow.QueryMode { = <span>value</span> }" |
|
Parameter |
Description |
|---|---|
|
value |
Whether the DataWindow is in query mode. Values are:
|
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.
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.
Buffer manipulation and query mode
A DataWindow cannot be in query mode
when you call the RowsCopy method.
Examples
|
1 |
string setting |
|
1 |
setting = dw1.Object.DataWindow.QueryMode |
|
1 |
dw1.Object.DataWindow.QueryMode = "yes" |
|
1 |
setting = dw1.Describe("DataWindow.QueryMode") |
|
1 |
dw1.Modify("DataWindow.QueryMode=yes") |