Using the query parameters list dialog

A parameterized query is one which has been defined to prompt you to enter the data that you want to use when querying the database. You use the Query Parameters (List) dialog to specify a list of values you want to use for the query.

Procedure

You can use a text file containing the values, or enter the values manually.

  1. To specify a text file containing the list of values, select the first radio button, click ... and browse for the required text file. To view the contents of the file, click ....

  2. To enter a list of values manually, select the second radio button. Type or paste the values into the box.

  3. Click OK to run the query.

  4. To re-run a parameterized query with values, click Refresh on the Results page. Enter the new values when prompted and click OK.