The first step in using Stonefield Query Studio is to set up the options, especially those used as defaults for new projects. To do so, click the Options link in the Tasks section of the Start Page.
The following options are available:
Load last project at startup: turn this option on if you want Stonefield Query Studio to automatically open the project you had open the last time when it starts.
Display captions after object names: turning this option on displays the caption defined for an object after its name in Stonefield Query Studio. For example, if you defined a caption of "Customers" for a table named ARCUST, it'll appear in Studio as "ARCUST (Customers)." This is especially useful if you aren't that familiar with the structure of the database.
Display non-reportable objects: you can specify that certain tables and fields are non-reportable, meaning the user won't see them in Stonefield Query. However, by default, they do appear in Studio. If you have a lot of non-reportable tables and fields, it can make the lists of those objects quite long and cluttered. Turn this option off to only see reportable tables and fields. You can, of course, turn this option on and off as required.
Use TOP 10 when testing relations: this setting allows you to determine whether Studio uses a TOP 10 clause in the SQL statement used to test relations or limits the result set to 10 records with an ODBC function call. The latter can cause problems with some ODBC drivers so turn this on if that's the case for you.
Number of recent projects to keep: you can have as many Stonefield Query projects as you wish. The value of this option tells Studio how many to keep in its most recent list, displayed when you click the arrow beside the Open button in the toolbar.
The Recent Projects section in the Start Page displays a maximum of seven projects regardless of what Number of recent projects to keep is set to.
You can create a private labeled or branded version of Stonefield Query by changing a number of configuration settings. This allows you to distribute Stonefield Query as your own branded product, so your end-users won't know it's Stonefield Query from Stonefield Software; they'll think it's something you've created just for them. This also allows you to sell your branded version for whatever price fits your business model. Rather than changing the configuration settings for each project you create, the options in the Default configuration settings for new projects section allow you to specify what they should be for all new projects.
Company name: this setting is the name you want displayed in various places in Stonefield Query, including the About dialog and on the Activation Code Request and Error Report reports.
Company Web site: this setting is the Web site you want displayed in the About dialog. You don't have to include "http://;" this is added automatically.
Support email: this setting is the email address you want displayed in the About dialog plus the one used when an unexpected error occurs and the user chooses "Email" to email the error report to technical support.
Sales email: once the unactivated period has expired, Stonefield Query displays a dialog every time the user starts it asking if they want to register for an additional 30 days. If they choose to do so, they're asked to enter some information (name, company, address, email address, and so forth) and submit the registration. This information is automatically emailed to the email address specified in the Sales email setting so you know who has downloaded a demo version.
Support fax: this setting is the fax number you want displayed in the error report printed when an unexpected error occurs and the user chooses "Print."
Sales phone: when a user's software maintenance is about to expire, they're remind of this and provided contact information for software maintenance renewal, including the email address, which comes from the Sales email setting, and phone number, which comes from the Sales phone setting.
Support contact information: the Technical Support topic in the help files generated by the Create Help Files function specifies how to contact your technical support. This setting allows you to specify this contact information. See the help topic for the Support Contact Information configuration setting for details.
Logo image file: this setting is the name of an image file displayed in several dialogs in Stonefield Query, including the About, Setup, and Registration dialogs. See the help topic for the Logo Image File configuration setting for information about the type of image to use.
Icon file: if you want to use your own icon rather than the Stonefield Query icon () for Stonefield Query's dialogs, specify the name of an ICO file for this setting.