Adding SQL queries

With the Add wizard, you can add SQL queries to a database stub.

Procedure

  1. Using the Add wizard, click Query, then click Next. Enter the SQL query that you want to add to the currently selected database stub. Alternatively, open the Add wizard from the Editing Options toolbar on the Queries tab and enter the SQL query that you want to use.
  2. Click Next. The SQL query or SQL queries are added to the currently selected database stub.
    Note: If you select the Use the new query to learn from the live database check box before clicking Next, the currently selected query is used to learn from the live database, thus running a refresh for the query. If you select the Clear matching data before learning from the database check box before clicking Next, the currently selected database stub will not capture any duplicate values whenever the currently selected query is run.
  3. Click Finish to close the Add wizard.
Feedback