The first time you run Stonefield Query, you are asked for the location of the AccountMate SQL files and where Stonefield Query puts its files.

You can specify any directory for the Stonefield Query files, but we recommend a directory on a server; that way, you can share reports with other users.

For the location of the AccountMate SQL files, either type the directory where AccountMate SQL is installed or click the button beside the text box and locate the AccountMate SQL directory in the dialog that appears.

After specifying the settings in Step 1, click the Next button.

The options in the Contact Information page are used as contact information when you send an error report to us. The options are self-explanatory.

The options in Step 3 are used when you want to email a report to someone or if an unexpected error occurs in Stonefield Query, in which case you have an option of emailing an error report to us so we can resolve the problem. The options are:

  • Use MAPI to send emails: choose this option if you use a MAPI-based email client such as Microsoft Outlook. If you don't use Outlook and you're not sure if your email client uses MAPI or not, ask your system administrator. Note that Stonefield Query requires the 32-bit version of Outlook and cannot send emails if you installed the 64-bit version. If that's the case, use SMTP instead. Also, MAPI isn't recommended if you want to email a scheduled report as it often fails. The other options on this page don't apply if you choose MAPI.

  • Use SMTP to send emails: choose this option if you use an SMTP-based email system or can configure your email system to use SMTP. Note that if you use Microsoft Exchange, it must be configured by your administrator to work with SMTP. This is the preferred option for emailing because it's more reliable.

  • Your name: your email descriptive name.

  • Your email address: the email address to use as the "reply to" address.

  • Mail server address: the address for your SMTP mail server. If this isn't filled in by default, check your email client to see how it's set up. For Gmail, use "".

  • SMTP port: the port for your SMTP mail server. This defaults to 25, but can be changed if necessary. As with Mail server address, check your email program's account settings and use the same port number here. For Gmail, use 465.

  • Use SSL/TLS: turn this setting on if your email server uses SSL/TLS. Turn this on for Gmail.

  • My email server requires authentication for outgoing messages: turn this option on if applicable. To determine if you should turn this on or not, check your email client setup.

  • User name: the user name to use if the My email server requires authentication for outgoing messages option is turned on.

  • Password: the password to use if the My email server requires authentication for outgoing messages option is turned on.

  • Test: once the email options are set, click this button to send a test message to yourself. This allows you to ensure the email settings are correct.

After specifying the settings in that step, click the Next button.

If your database has a lot of tables and fields, you may have a long list to choose from in step 2 of the report wizards, making it difficult to know which fields to select. To make things easier, turn on the Run Process option in this step. It performs the same function as selecting the Analyze Reports function in the Tools menu; see the help topic for the Analyze Reports function for details. This process may take some time to run, depending on how many reports there are.

After you've closed this dialog, it doesn't normally come up again. If you need to change any settings, see the Configuring Stonefield Query help topic. If you want to force the dialog to appear again, add an Other section to SFQuery.ini and create an Action entry under that section with a value of Setup. For example:


© Stonefield Software Inc., 2018 • Updated: 06/08/16
Comment or report problem with topic