SQL Workbench

Even though the Windows App provides many ways to view and analyze data, there might be times when data is needed in a different way. The SQL Workbench allows querying the database using SQL statements. To see examples of this feature, visit the Approved Workman Forum.

Only use this tool with knowledge of SQL or with explicit instructions from Customer Support.

AdminDB-SQL

Icon

Action

Description

Closes the SQL Workbench without saving current changes.

Save

Saves any changes made in the "live result set".

The Save button is only enabled if the Request a live result set is selected.

Save SQL

Saves the SQL statement that is currently displayed to a file to easily open it and run it again at a later time.

Open SQL

Opens a SQL statement that was previously saved to a file.

Auto Width

Automatically resizes the grid's columns to best fit the data that is displayed.

Grid Tools

Lists actions related to the grid such as: saving or resetting a grid layout, or exporting data.

Stay On Top

Toggles whether or not the window stays on top of the main window.

Run SQL

Runs the current SQL statement and displays the results in the grid.

•	To edit the data, check the Request a live result set box then click Run SQL again. This allows changes to be made in the grid and enables the Save button to keep the changes.

Again, be cautious about modifying any records due to possible impacts on referential integrity and validation.

•	If the grid's data is going to be printed, specify a Report Title to be used.