Filter
Top Products
Using Quick Select
116 DataWindow .NET
As you specify selection criteria, DataWindow Designer builds a WHERE
clause for the
SELECT statement.
❖ To specify selection criteria:
1 Click the Criteria row below the first column for which you want to select
the data to retrieve.
2 Enter an expression, or if the column has an edit style, select or enter a
value.
If the column is too narrow for the criterion, drag the grid line to enlarge
the column. This enlargement does not affect the column size in a
DataWindow object.
3 Enter additional expressions until you have specified the data you want to
retrieve.
About edit styles
If a column has an edit style associated with it in the extended attribute system
tables (that is, the association was made in the Database painter), if possible,
the edit style is used in the grid. Drop-down list boxes are used for columns
with code tables and columns using the CheckBox and RadioButton edit styles.
SQL operators
supported in Quick
Select
You can use these SQL relational operators in the retrieval criteria:
Table 4-2: SQL relational operators used in retrieval criteria
Because = is the default operator, you can enter the value 100 instead of = 100,
or the value
New Hampshire instead of = New Hampshire.
Operator Meaning
= Is equal to (default operator)
> Is greater than
< Is less than
< > Is not equal to
> = Is greater than or equal to
< = Is less than or equal to
LIKE Matches this pattern
NOT LIKE Does not match this pattern
IN Is in this set of values
NOT IN Is not in this set of values