DB Solo
Back to Index

Query Window

DB Solo's query window allows you to execute one or more SQL statements a the same time.

1. Select the tab, Query, within DB Solo.
2. Select a Server and Database within the query window.
3. Enter the SQL query you wish to execute.

Action buttons include:

SQL Query

Below screen, Query Results, displays the results of a simple SELECT query. Middle section of the query window displays all the rows returned from your query. Bottom section displays details on the selected cell within the results. If you select more than one cell form the result grid, the detail panel will show you statistics on your selection. For example, if you select numeric cells, the detail panel shows you statistics on the selected values such as MIN, MAX, and AVG. If you have executed more than one query in the query window, the middle part will contain a tab for each query. You can view the results of each query in their respective tabs.

A search is also available within the query window. This allows you to quickly search for a specific value within the result set.

Figure - Query Results

Query History

Query history is automatically maintained by DB Solo. The history contains the last 100 queries you have executed. To see a list of past queries:

1. Select Query from the top menu bar.
2. From the pull down menu select, Query History.
3. Options include choosing a Server Connection and creating a Filter for further refinement. By selecting a server in the Server Connection combo box you can filter the list to only contain queries executed against the selected server. Entering a value in the Filter field will dynamically filter the list to only include entries that contain the entered string.
4. Select the query by highlighting it and click the Select button. You can also double-click on a query in the list. See Query History displayed below.

Figure - Query History

Back to Index DB Solo
 www.dbsolo.com
support@dbsolo.com