Adding SQL queries

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

Procedure

  1. If you click Query on the first screen of the wizard and click Next, the second screen of the wizard enables you to enter the query that you want to add to the currently selected database stub. Alternatively, opening the Add wizard from the Editing Options toolbar on the Queries tab opens the second screen of the Add wizard.
  2. After entering the query in SQL, clicking Next adds the query/queries 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