To create a two-parameter query

  1. Select the Two-parameter Query option in the Query Type group box.

Example:

Select * from customers_rms where customerid >= A and customerid <= F
  1. Enter the query information in the Two-parameter Query group box.

  2. Table name: The name of the table to be queried (customers_rms in the example).

  3. Selected columns: The names of the columns in the answer set, separated by commas. Enter an asterisk (*) to retrieve all columns from the table.

  4. Parameter column: The name of the column that contains the parameter (customerid in the example).

  5. Low Value: The low parameter value that sets the lower bound of data (A in the example).

  6. High Value: The high parameter value that sets the upper bound of data (F in the example).

  7. Parameter Data Type (optional): The data type for the retrieved parameter column (may be different from its native data type). If a Parameter Data Type is not selected, the returned data defaults to String.

  1. Click the Query button in the Two-parameter Query group box.

    image\twoparam.gif

  2. The result set from the query appears in the Data Grid.