Table of Contents

Using the Query Editor

The Query Editor dialog allows you to create new SQL queries or edit the existing queries created using the Data Source wizard. Optionally, you can add query parameters.

The Query Editor can contain two pages depending on the current query.

  1. The first page allows you to specify the query or select the stored procedure.

    QueryEditorDialog_Page1

    You can choose the following options to create/modify a query.

    • Select the Query option and run the Query Builder by clicking the Run Query Builder... button. The Query Builder allows you to choose the required tables/columns visually and displays the resulting SQL query within the SQL String editor.
    • If available, select the Stored Procedure option to select one of the stored procedures from the database.

  2. The second page of the Query Editor allows you to add or modify query parameters.

    QueryEditorDialog_Page2

Edit this page