SQLWizard Overview
SQL (Structured Query Language) is an industry-standard language that enables you to select the data you want to work with from a database. SQLWizard enables you to create SQL queries using a simple natural language style interface.
The SQLWizard contains two areas:
The
Query Builder area at the top of the wizard window is used to construct a query.
The
Preview area at the bottom of the wizard shows the SQL code generated by the SQLWizard. It can also display
a preview of the data that will be selected by the query.
To create a query using SQLWizard:
1 In the Build your query section, enter the conditions you want to use to select data from the Site database. Alternatively, to a modify a previously saved query, click Open Query to load the query from a .DBQ file.
2 When you have specified all the conditions for your query, click Preview to display the results that will be returned when you apply the expression to your Site database. If you want to display the SQL statement generated by the query, click the SQL Statement tab.
3 If you opened SQLWizard from a database view and you want to select which fields are displayed or the order in which the results are sorted, click Show Fields.
4 To save your query to a file, click Save Query.
5 Click OK to save the query and close the wizard. The SQL statement generated by the wizard is displayed in the filter expression field.
Related Topics