Query Wizard - SQL

Top  Previous  Next  

In the previous step the Query Wizard - Select Subject you chose not to select a Subject from the drop down list and therefore decided to base the Query on an SQL select statement.

 

clip5859

 

The SQL select statement that will be used to retrieve data for this query can be typed into the editor on the right of the form.

 

You can expand a database table in the treeview to see what fields are available from it.

 

You can insert a table or field into your SQL select statement simply by double clicking on it in the treeview.

If you think the database schema has changed then you can force a refresh of the treeview by right clicking on the database name at the top of the treeview and select Refresh DB Schema.

Once you have defined your SQL select statement click 'Next >' to move to the next screen the Query Wizard - Finished screen. Your syntax will be checked at this point by performing a test execution of the SQL. If there are any errors you will be provided with a description of the error.


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0