In the QueryPad window, the Query menu provides you with the following options:
- Connect to Database—This allows you to connect to a database. The Connect dialog is displayed (see Connect QueryPad to a Database).
Access to QueryPad might be restricted on your system. In order to connect QueryPad to a database successfully, the Geo SCADA Expert server has to be configured to allow SQL queries to be edited from its clients, and your User Account has to be configured to allow you to edit SQL queries. For more information, see Specify Whether SQL Queries can be Edited using the Clients on this Server, and see Define the SQL Editing Settings for a User.
- Disconnect from database—This allows you to disconnect from a database (see Disconnect QueryPad from a Database).
- Execute a Query—This allows you to execute any query that you have entered in the SQL Entry pane. If your SQL query does not require any parameters, QueryPad will execute the query (see Run your Query in QueryPad).
- Previous Query text— This allows you to view the previous query, if you have executed more than one within the current use of QueryPad (see View your QueryPad Command History).
- Next Query text— This allows you to view the next query, if you have executed more than one within the current use of QueryPad (see View your QueryPad Command History).
- Open History—This allows you to open and load into QueryPad a History file that you have previously saved (see Opening a Query Command History).
- Save History—This allows you to save your query command history in a QueryPad History file (see Opening a Query Command History).
- Execute History—This allows you to execute any query or command from you history (see View your QueryPad Command History).
- List Helper Commands—This provides you with a list of main query commands that you can use within QueryPad.