View/Manage Queries

You use the View/Manage Queries dialog box to perform the following:

Note: A few  applications consist of only one page; therefore, they do not have a List tab. With the exception of Bookmarks, one-page applications have a Search Toolbar with the same search options found on the List tab. In those applications, The system displays the search results on the application page.

To select a query to perform a search:

  1. Open an application.

  2. From the List tab, click Save Query. The system displays the Save Query menu.

  3. Click View/Manage Queries. The system displays the View/Manage Queries dialog box.

Note: You can display a query's SQL WHERE clause by clickingnext to the name of the query.

  1. To perform a search, click the underlined query name in the Query Name column of the table window. The system displays the search results on the List tab.

  2. Click Cancel to return to the List tab without performing a search.

To modify a query:

  1. Open an application.

  2. From the List tab, click Save Query. The system displays the Save Query menu.

  3. Click View/Manage Queries. The system displays the View/Manage Queries dialog box.

  4. You can edit the following fields:

  5. Description

  6. Default?

  7. Public?

  1. If you want to edit the SQL WHERE clause, click next to the name of the query. The system displays the SQL WHERE clause in the details section of the dialog box.

  2. Click one of the following buttons:

  3. Click OK to save changes this query and return to the List tab.

  4. Click Cancel to return to the List tab without saving change to the query.

To delete a query:

  1. Open an application.

  2. From the List tab, click Save Query. The system displays the Save Query menu.

  3. Click View/Manage Queries. The system displays the View/Manage Queries dialog box.

  4. Click Mark Row for Delete in the View/Manage Queries table window row containing the query you want to delete. The system marks the row for deletion. If you decide that you do not want to mark this query for deletion, click Undo Delete .

  5. Click one of the following buttons:

  6. Click OK to delete the query and return to the List tab.

  7. Click Cancel to return to the List tab without deleting the query.

See Also

Search for Records

Enter a WHERE Clause

Save a Current Query