Chapter 16: Managing the Database

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.

Figure 16-12: Specifying a boolean expression as a filter for testing

To filter the rows:

Select Rows>Filter from the menu bar.

The Specify Filter dialog box displays.
Enter a boolean expression that PocketBuilder 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.

PocketBuilder 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.