You can limit which rows are displayed by defining a filter.
The filters you define are for testing only and are not saved with the table or passed to the DataWindow painter.
To filter the rows
-
Select Rows>Filter from the menu bar.
The Specify Filter dialog box displays.
-
Enter a boolean expression that PowerBuilder will test against each row:
If the expression evaluates to TRUE, the row is displayed. You can paste functions, columns, and operators in the expression.
-
Click OK.
PowerBuilder filters the data. Only rows meeting the filter criteria are displayed.
To remove the filter
-
Select Rows>Filter from the menu bar.
The Specify Filter dialog box displays, showing the current filter.
-
Delete the filter expression, then click OK.
Filtered rows and updates
Filtered rows are updated when you update the database.
