Filtering rows

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.

StepsTo filter the rows:

  1. Select Rows>Filter from the menu bar.

    The Specify Filter dialog box displays.

  2. Enter a boolean expression that PowerBuilder will test against each row:

    Shown is the Specify Filter dialog box. At the bottom are buttons for the boolean operators and fields listing the functions and columns you can paste into the expression.

    If the expression evaluates to TRUE, the row is displayed. You can paste functions, columns, and operators in the expression.

  3. Click OK.

    PowerBuilder filters the data. Only rows meeting the filter criteria are displayed.

StepsTo remove the filter:

  1. Select Rows>Filter from the menu bar.

    The Specify Filter dialog box displays, showing the current filter.

  2. Delete the filter expression, then click OK.

NoteFiltered rows and updates Filtered rows are updated when you update the database.