The Project Browser

The Project Browser task allows you to explore your project data using standard SQL syntax. File- and Memory-based projects us the SQLite 2.8 database engine, while server-based projects use the database engine of the selected driver (currently MySQL is the only driver supported).

When running queries on your project, you may need to alter the SQL syntax to match that of the driver. You can find the specific syntax that is supported for each driver from their respective web sites.

•	SQLite can be found at http://www.sqlite.org

•	MySQL can be found at http://www.mysql.com

If you are familiar with SQL, this is a nice way to generate custom CSV exports or massage the data. If you are not familiar, or are uncomfortable using SQL, we highly recommend you avoid this task. You can permanently damage your project data beyond repair using the Project Browser. Generally speaking, though, if you stick to using just SELECT statements, you can never harm your project data.

Toolbar Buttons

•	Back is used to go back a query after more than one query has been ran.

•	Next is used to go forward one query or blank out the last ran query to start a new one.

•	Execute SQL is used to run the query in the SQL Query window.

•	Save Results is used to save the result table to a CSV file.

•	Empty Cache is used to clear out the query history and reset the Back and Next buttons.

Saved Queries Pane

•	The Saved Queries list is used to select a saved query to run and display it in the SQL Query window.

•	Save Query is used to save the current query for future or repeated use.

•	Delete is used to remove the selected Saved Query in the list.

SQL Query Window

This is the edit window where you type your queries to run.

Snippet Window

This is a list of SQL snippets that you create to reuse in your SQL queries.

Result Table

When your query is finished running, the results are displayed in this table. The column headers come from the query or the table field names.

Status Bar

•	The first pane displays the total number of records the query generated.

•	The second pane displays the amount of time it took to run the query.

•	The third pane displays the status of the last query. If an error occurred, more information will display here giving you a clue as to where the error is in your query.