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.

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

  • Create Resource File: creates a resource file for the data dictionary strings (such as headings and captions) for the current project.

  • Create Customer Resource File: creates a blank resource file you can customize as necessary.

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

  • Publish Project: publish Stonefield Query to a web site.

  • Convert Reports: converts reports from an older Stonefield Query project.

  • Find Possible Relations: scans through the data dictionary looking for possible relationships between tables.

  • Review Possible Relations: reviews the possible relationships found after using Find Possible Relations or Find Relations for Table (in the Object menu).

  • Test All Relations: tests all relations in the data dictionary and displays a dialog showing any that did not succeed.

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

  • Save: saves all changes to the current object.

  • 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 Join Tree: creates a join tree.

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

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

  • Create Custom Setting: creates a new project-specific setting.

  • Remove Object: this function removes the selected object (data dictionary item, data group, role, join tree, or custom setting) 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.

  • Update Virtual/Subtable to Match Main Table: updates the selected virtual table or subtable to have the same fields with the same properties as the original table the virtual table or subtable was created from.

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

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 ( is displayed in your browser.

  • Stonefield Query Customer Portal: choosing this function navigates your browser to the Stonefield Query Customer Portal, where you can manage your licenses and perform other tasks. See our blog for details on using the portal.

  • Check for updates: checks to see if there are updates to Stonefield Query Studio.

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


The toolbar below the main menu has the following functions:

The Create Object button is context-sensitive: if the currently selected object is a field, clicking this button creates a new field. 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 to Previous Item button selects the previously selected item; this is a quick way to move back and forth between objects. You can also click the down arrow beside the button and select a specific item to select 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.