This location is stored in a settings file called Data.INI in the Data subdirectory of the Stonefield Query program folder. (If you upgrade from an earlier version of Stonefield Query, this file may be in program folder instead.) This file can also optionally contain the location of the Stonefield Query "system" files, such as the license file and users table.

This file has the following contents:

[Options]
CommonFiles=location of files
TargetApp=location of Sage Pro ERP folder

where location of files is the location of the reports files. If this location is the same as Stonefield Query itself, a "." is used as the location. This makes the location more portable; if the application and its data files are moved from one directory to another, there's no need to edit Data.INI in this case.

Using Data.INI has a couple of advantages over previous versions that stored this information in the Windows Registry. One is that it's easier to change the location of the reports files; you simply edit the location in Data.INI following the instructions below. Another is that workstation setups are easier. In previous versions, after installing Stonefield Query on a server and specifying the location for the reports files, you then had to do workstation installs and specify the same location for the reports on each workstation. If you chose the wrong location on one particular machine, that user didn't have access to the reports. Now, after the first user runs Stonefield Query, Data.INI will contain the proper location, and each workstation will automatically use that location.

If you need to change this setting for some reason (for example, you selected the wrong location or want to move your reports to another folder), modify the location specified in this file. The easiest way to do that is the following:

• Run Stonefield Query. From the Help menu, choose the About function.

• Click the "Stonefield Query data folder" item in the list to bring up Windows Explorer for that folder.

• Double-click Data.INI (it may display as Data rather than Data.INI, depending on how you have Windows Explorer configured).

• Edit the location following "CommonFiles=" to the new location. Save the file.
  

Note that the new location will not take effect until you close Stonefield Query and run it again.

Note that changing the location doesn't automatically move your existing reports to the new location. If you want the reports you created to be available, you must move the files in the old location to the new one. If the new location already has a copy of these files, don't move the old files to the new location or you'll overwrite the reports someone else created. Instead, change the location in Data.INI back to the old location, run Stonefield Query and export any reports you wish to keep. Then change the location in Data.INI to the new location, run Stonefield Query, and import the reports you exported.

One consequence of Data.INI in a server environment is that all users access the same reports location. If you want users to access different locations, add the following line to Data.INI:

UseRegistry=Yes

This tells Stonefield Query to store the location of the reports files in the Windows Registry, which is what previous versions used to do. When each workstation runs Stonefield Query for the first time, they'll be prompted for the location of their reports.

To specify a different location for the Stonefield Query "system data" files, add the following line to Data.INI:

SystemData=location of files

where location of files is the location of these files. If this location is the same as Stonefield Query itself, specify "." as the location.

Because of changes to Windows security, help (CHM) files don't always display properly if they are located on a network drive; this is discussed in more detail in the Other Problems topic. To resolve this, you can either configure the computer to display the CHM file properly or copy the CHM file to a local drive and tell Stonefield Query where to find that file. To specify a different location for the Stonefield Query help file, add the following line to Data.INI:

Help=location of help file

where location of help file is the location of SFQuery.CHM. If this location is the same as Data.INI itself, specify "." as the location. Here's an example that looks for SFQuery.CHM in C:\HelpFiles:

Help=C:\HelpFiles

If the UseRegistry setting discussed above is Yes, Stonefield Query will look for the Help entry in the Windows Registry instead.