As with most Windows applications, there are several ways you can select a function in Stonefield Query Studio: from the main menu, from the toolbar, from the shortcut menu, and from the Start Page.

Main Menu

The main menu for Stonefield Query Studio 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.

• Cleanup Project: compacts the project files to minimize space.

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

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

• Create Help Files: creates help files for the current project. This function is only available in the Ultimate version of Studio.

• Change SFQuery.exe Description: allows you to change the description for SFQuery.exe as part of a branding process. This function is only available in the Ultimate version of Studio.

• Generate Checksum: generates a checksum you can use when licensing reports. This function is only available in the Ultimate version of Studio.

• Import Data Dictionary: imports data dictionary information from a Microsoft Excel spreadsheet or an XML file. This function is only available in the Ultimate version of Studio.

• Query Data Dictionary: allows you to view the raw records in the data dictionary for a project and make bulk changes if necessary. This function is only available in the Ultimate version of Studio.

• Export to Microsoft Excel: exports the data dictionary to a Microsoft Excel document for documentation purposes.

• Find Possible Relations: scans through the data dictionary looking for possible relationships between tables. This function is only available in the Ultimate version of Studio.

• Review Possible Relations: reviews the possible relationships found after using Find Possible Relations or Find Relations for Table (in the Object menu). This function is only available in the Ultimate version of Studio.

• Test All Relations: tests all relations in the data dictionary and displays a dialog showing any that did not succeed. This function is only available in the Ultimate version of Studio.

• Exit: exits Stonefield Query Studio.

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.

• Find: displays the Find dialog when you're editing text to locate something in that text.

• Sort Fields Alphabetically: if this item appears sunken in the toolbar or checked in the menu, 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: choose this function to filter the data dictionary so only those items added or updated on or after a certain date or containing certain text, such as a name, are displayed. This makes it easier to locate new tables and fields added when the data dictionary is refreshed, for example.

• Find Field: finds the first field with Name or Caption containing the text you specify.

• Find Next Field: finds the next field with Name or Caption containing the text you specify. This function is disabled if you haven't use Find Field to find the first field.

Objects Menu

• Add Database: use this function to add a database to the project's data dictionary.

• 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 Subtable: creates a subtable of the selected table.

• Create Virtual Table from Table: creates a virtual table with the same structure as the selected table.

• Create Application View: creates an application view. This function is only available in the Ultimate version of Studio.

• 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.

• Create Script: creates a new script.

• Remove Object: this function removes the selected object (data dictionary item, application view, 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 Database: this function refreshes the data dictionary for just the selected database.

• 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.

• Find Relations for Table: scans through the data dictionary looking for possible relationships for the selected table. This function is only available in the Ultimate version of Studio.

Help Menu

• Help: use this function to display the Stonefield Query Studio 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.

• Renew Software Maintenance: select this function to renew the software maintenance for your Stonefield Query Studio license.

• About Stonefield Query Studio: this function displays copyright and version information as well as your software maintenance renewal date and serial number. You can select and copy the serial number from this dialog so you can paste it in when you create a support ticket.

  

Toolbar

The toolbar below the main menu has the following functions:

Some of these functions are only available in the Ultimate version of Studio.

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 from the list that appears. The number of recently opened projects is controlled by the Number of recent projects to keep option, which you can edit in the Options page.

Clicking the Go Back button takes you back to the previously selected item. You can also click the down arrow beside the button and choose the desired item to go back to from the list that appears.

Shortcut Menu

The shortcut menu can be invoked by right-clicking anywhere in Stonefield Query Studio. It has some of the same functions that appear in the main menu.