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.
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.
Select Rows>Filter from the menu bar.
The Specify Filter dialog box displays, showing the current filter.
Delete the filter expression, then click OK.