Home » Products » Surveyor/400 » Features » SQL Wizard

SQL Wizard

The SQL Wizard in Surveyor/400 creates SELECT statements with Point and Click functionality

The SQL Wizard is an excellent tool for quickly creating SQL SELECT statements without having to know the SQL syntax. Just select the files, fields and criteria and then click a button to generate the statement.

Demonstrates the criteria portion of the SQL Wizard


  • Launch wizard from within the SQL editor
  • Select one or more files
  • Select one or more fields from those files
  • Enter WHERE criteria for selecting just certain records
  • Enter ORDER BY criteria for changing the sorting of the records
  • Optionally override the column headings
  • Inserts generated SELECT statement into the SQL editor
  • Statement can then be ran immediately or saved for later execution