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 Step 2 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:

• I use Outlook or a similar program for email (MAPI): choose this option if you use a MAPI-based email client such as Outlook. If you don't use Outlook and you're not sure if your email client uses MAPI or not, ask your system administrator.

• I use Outlook Express or a similar program for email (SMTP): choose this option if you use an SMTP-based email client such as Outlook Express. If you don't use Outlook Express and you're not sure if your email client uses SMTP or not, ask your system administrator.

• Your name: your email descriptive name (SMTP only)

• Your email address: the email address to use as the "reply to" address (SMTP only).

• 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 example, if you use Outlook Express, choose the Accounts function from the Tools menu, select the appropriate account and click Properties, then look at the Outgoing mail (SMTP) option on the Servers page for the address of the mail server.

• 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. For example, if you use Outlook Express, choose the Accounts function from the Tools menu, select the appropriate account and click Properties, then look at the My server requires authentication option on the Servers page.

• 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 matters worse, a lot of these fields may contain default or even no data; for example, the fields may be there to support certain features in the program, but you may not use those features.

To make things easier, turn on the Run Process option in this step. It performs the same function as selecting the Analyze Database function in the Tools menu; see the help topic for the Analyze Database function for details. This process may take some time to run, depending on the size of the database.

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:

[Other]
Action=Setup