Figure 0.2 Edit Select Data Scenario
This is the dialog used to select the desired tables to select data from.
The available database tables for this scenario are shown on the left, and the tables selected for select data generation are on the right.
Select the tables that you want to generate Select SQL statements for by dragging and dropping the tables from the 'Available Tables' tree. To enter a Where clause to restrict the data to be selected, select the table on the right hand tree and either type in the text or build it with the SQL Builder .
To include or exclude a column click on the check box shown to the left of the column, or select the appropriate action from the Include tab. Include or Exclude all columns by selecting the table, then pressing the Include All or Exclude All button.
You can set a default Where clause for a table by selecting a table from the left side 'Available Tables' tree and updating it. Then each time that table is selected for any select data scenario, it will initially use the default until it is overridden.
Move the order of the tables by selecting a table with the mouse and dragging it vertically up or down. Move the order of the columns to be generated in the same manner.
