After opening a new or existing project, use the Select, Where, Order by, Join, Group by, and Having options in the SQL Statement menu to build your SQL query. You can return to any of the construction dialog boxes at any time to modify the working version of your select statement.
View the SQL select statement in the SQL Statement window as it is being constructed.
Use the Run option in the Generate menu to view the result set for your SQL query.
Use the Erase option on the SQL Statement menu to erase the statement from the SQL Statement window and from the construction dialog boxes.
Use the Test SQL option in the Generate menu as an independent work area where you type in a SQL select statement, view the results, and generate ESL code. This work area is independent of the construction dialog boxes and SQL Statement window.
Note: The SQL statement you create by using the ESL SQL Wizard construction dialog boxes is a SQL select statement. However, the ESL SQL Wizard will automatically generate SQL INSERT, UPDATE, and DELETE statements for the ESL application, provided one of the columns in your select statement is a primary key from the first table accessed.
