Filter
Top Products
Filtering rows
266 DataWindow .NET
Using filters
In the DataWindow painter, you can define filters to limit the rows that display
at runtime. Filters can use most DataWindow expression functions.
Filters do not affect which rows are retrieved
A filter operates against the retrieved data. It does not re-execute the SELECT
statement.
Defining a filter
❖ To define a filter:
1 In the DataWindow painter, select Rows>Filter from the menu bar.
The Specify Filter dialog box displays:
2 In the Specify Filter dialog box, enter a boolean expression that
DataWindow Designer will test against each retrieved row.
If the expression evaluates to
TRUE, the row is displayed. You can specify
any valid expression in a filter. You can paste commonly used functions,
names of columns, computed fields, retrieval arguments, and operators
into the filter.
International considerations
For applications to run the same in any country, filter expressions require
U.S. notation for numbers. That is, a comma always represents the
thousands delimiter and a period always represents the decimal place
when you specify expressions in the development environment.