As with most Windows applications, there are several ways you can select a function in the Configuration Utility: from the main menu, from the toolbar, and from the shortcut menu.

Main Menu

The main menu for the Configuration Utility has the following functions:

File Menu

• New Project: this function creates a new Stonefield Query project.

• Open Project: use this to open an existing project.

• Project Encryption: allows you to encrypt your project so only authorized users can open it in the Configuration Utility.

• Launch Stonefield Query: runs Stonefield Query for the current project so you can test your customization.

• Create Help Files: creates help files for the current project.

• Project Documentation: creates documentation for the current project.

• Generate Setup: generates an Inno Setup script file for the current project.

• Import Data Dictionary: imports data dictionary information from an Excel spreadsheet.

• Exit: exits the Configuration Utility.
  

Edit Menu

• Undo: reverts any changes in the current control.

• Redo: repeats the last change made in the current control.

• Cut: removes the selection and places it onto the Windows Clipboard.

• Copy: copies the selection onto the Clipboard.

• Paste: pastes the contents of the Clipboard into the current control.

• Clear: removes the selection and does not place it onto the Clipboard.

• Select All: selects all text in the current control.

• Revert Changes: reverts all changes to the current object.

• Sort Fields Alphabetically: if this item appears sunken, fields in the data dictionary are sorted alphabetically; if not, they are displayed in the physical order they appear in their tables. Select this function to toggle the setting.

• Filter Data Dictionary: choose this function to filter the data dictionary so those items added or updated on or after a certain date are shown in bold. This make it easier to locate new tables and fields added when the data dictionary is refreshed, for example.
  

Objects Menu

• Add Database: use this function to add a database to the project's data dictionary or to refresh the structure of an existing database.

• Create Table: this function adds a virtual table to the data dictionary.

• Create Field: this function adds a calculated field to the data dictionary.

• Create Relation: use this function to define a relationship between a pair of tables.

• Create Relation on Field: use this function to define a relationship between a pair of tables based on the selected field.

• Create Script: creates a new script.

• Create Subtable: creates a subtable of the selected table.

• Create Data Group: creates a data group you can use to segregate tables.

• Create User Group: use this to define roles to implement role-based security at the table and field level.

• Remove Object: this function removes the selected object (data dictionary item, data group, user group, or script) from the project. You're asked to confirm the removal.

• Refresh Data Dictionary: use this function when the database structure changes, such as when a new table is added.

• Refresh Table: this function refreshes the data dictionary for just the selected table.

• View Table Contents: this function displays the contents of the selected table in a window.

• View Field Contents: this function displays the contents of the selected field in a window.
  

Help Menu

• Help: use this function to display the Configuration Utility documentation.

• Technical Support: this function displays the Technical Support page of the online documentation.

• Stonefield Query Web Site: when you choose this function, the Stonefield Query web site (http://www.stonefieldquery.com) is displayed in your browser.

• About Stonefield Query Configuration Utility: this function displays copyright and version information.

Toolbar

The toolbar below the main menu has the following functions:

The Create Object button is context-sensitive: if the currently selected object is a script, clicking this button creates a new script. If the selected object is a table, the button creates a new table. The tooltip for the button indicates the type of object created. You can also click the down button beside the button to display a menu of object types to create; select one from the list to create an object of the desired type.

To open a previously opened project, click the down arrow beside the Open button and choose the desired project path from the list that appears.

Shortcut Menu

The shortcut menu can be invoked by right-clicking anywhere in the Configuration Utility. It has most of the same functions that appear in the main menu.