SQL Statement Form (VisData)

Enables you to execute any valid SQL statement and save it as a query, or update the currently selected query’s SQL property.

You can view the SQL statement from a query in the Database window by selecting it, clicking the right mouse button, and then choosing Design.

Use the SQL Statement window to enter, modify, execute, and save SQL statements.

Form Items

Execute SQL

Executes the SQL statement. This is the default button and will be invoked if you press ENTER while the form is active.

Note   To put a carriage return into the SQL statement, press CTRL+ENTER.

Clear SQL

Clears the SQL Statement text box. It does not copy the contents onto the Clipboard.

Save SQL

Saves the SQL statement. This command will prompt you to overwrite the SQL statement in a query if one is selected in the QueryDefs list on the Table form, or it will prompt you for a new name if you chose No to the above prompt or there is no query currently selected.