SQL Query Builder

Navigator > Setup > SQL Query Builder

You can design an SQL query, view and print results from the query.


Query Layout tab		Use the tools to build a query.
SQL tab		View and edit the SQL.
Results tab		Set parameter types and values and view results after Execute Query.
SQL for Script tab		Copy the SQL pre-formatted for use in the ExecuteSQL function in a MaxBasic script.
Wizard tab		Generate MaxBasic code to create a scripted form, allowing parameters to be input.
File Menu
The file menu lists the last 9 files accessed, at the end of the menu.
Open...		Load a previously saved SQL query file.
Save Save as ...		Save query as an SQL Query file.
Buttons
	Check Query `(Alt+C)`	Checks the syntax of the query shown on the SQL tab without executing. An error message will provide details of problems.
	Execute Query `(Alt+X)`	Executes the query shown on the SQL tab and shows the results on the Results tab.
Clear Results `(Alt+E)`		Clears the data shown on the Results tab. You must clear the results to make changes in the Query Layout or SQL tabs.
	Print `(Ctrl+P)`	Print the SQL Query or the Query results.
	Load... `(Alt+L)`	Load a previously saved SQL query file.
	Save... `(Ctrl+S)`	Save a query as an SQL Query file.

In This Section