Filter
Top Products
Retrieving data
188 DataWindow .NET
Testing in DataWindow Designer
You can test the prompting for criteria by retrieving data in the Preview view
of the DataWindow object.
Using edit styles
If a column uses a code table or the RadioButton, CheckBox, or
DropDownListBox edit style, an arrow displays in the column header and users
can select a value from a drop-down list when specifying criteria:
If you do not want the drop-down list used for a column for specifying retrieval
criteria, select the Override Edit check box on the General page of the column's
Properties view.
Forcing the entry of
criteria
If you have specified prompting for criteria for a column, you can force the
entry of criteria for the column by selecting the Equality Required check box
on the General page of the column's Properties view. DataWindow Designer
underlines the column header in the grid during prompting. Selection criteria
for the specified column must be entered, and the
= operator must be used.
For more information
The section “Using Quick Select” on page 112 describes in detail how you and
your users can specify selection criteria in the grid.
The chapter on dynamic DataWindow objects in the Programmer’s Guide
describes how to write code to allow users to specify retrieval criteria at
runtime.
Retrieving rows as needed
If a DataWindow object retrieves hundreds of rows, there can be a noticeable
delay at runtime while all the rows are retrieved and before control returns to
the user. For these DataWindow objects, DataWindow Designer can retrieve
only as many rows as it has to before displaying data and returning control to
the user.