In addition to changing the location for storing Stonefield Query's reports and other files, Query's data.ini file can be used to change some other settings. These settings are listed below, along with information on the exact behaviour for each, and the available settings to be made in data.ini. The Changing the Location for Reports and Other Files topic has instructions for locating and editing the data.ini file.

Specifying the database format for Notes fields

In version 8.5, the GoldMine database structure was changed so that notes are now stored in a separate database table. Previously, the notes were stored alongside other fields in the main table.

Normally, Stonefield Query is able to detect the GoldMine version, and then handle retrieving notes values appropriately. However, in some cases, there is a problem with detecting the GoldMine version. For this reason, it's possible to explicitly specify whether to use the new version 8.5 notes format, or the earlier format. This is done by adding an 85Notes=Yes or 85Notes=No item in the [Options] section of data.ini.

[Options]
85Notes=Yes

With this change in version 8.5, the notes field was also changed to an Image data type in SQL Server database. This requires special handling when Query retrieves this data. Again, Query normally is able to detect this situation and react appropriately. However, if Query does not properly detect this SQL image field format, a SQL85Notes=Yes entry can be added to the [Options] section of data.ini, to force this processing.

[Options]
SQL85Notes=Yes