Stonefield Query for Sage 300 Version 5.2.5868

We are please to announce the release of version 5.2.5868 of Stonefield Query for Sage 300. There are several new features in this release.

• Stonefield Query now supports Sage 300 2016 (version 6.3).

• A new type of output is available: Microsoft Word Mail Merge. This allows you to perform a mail merge from a report to create form letters.

• The Maintain Databases dialog now shows a checkmark in front of data sources used with Stonefield Query in the data source list so you can tell at a glance which ones are used.

• A formula can now use an expression that doesn't retrieve data from the database, such as " ", which allows you to add a blank column to a report.

• The SQLookup function can now return an expression instead of just a field. The expression must be one the database engine can understand rather than a Stonefield Query expression.

• The GetConditionValue function now accepts a parameter indicating which value for "is between" and "is one of" conditions is returned.

• You can now turn off usage reporting by adding Usage=N to the [Options] section of Data.ini.

• If none of your data fields contain null values, you can make processing slightly faster by adding HandleNull=N to the [Options] section of Data.INI.

• Grouping formulas can now be used as data fields in a cross-tab report.

• Cross-tab reports now use the text for the Summary Total Template field in the template if it exists; this allows you to customize the text displayed for the totals line by changing the text in the template used by the report.

• Help now displays correctly even when running from a server without having to install the help file on the workstation.

• The Calculate Value at Group Level setting in the Formula Editor is now disabled if the field is a grouping formula since a formula can't be both.

• The GetConditionValue, GetValueForField, GetValueForParameter, GoMonthDay, SQLookup, STOD, and RunSQL functions now appear in the Built-in Functions list in the Expression Builder.

• The Print button in the Preview window is now disabled for a label report using a Dymo label size since it works better to print those labels directly rather than previewing first.

• You can now specify "login" on the command line to prompt the user to log in when running a dashboard from a shortcut. Also, theDashboard Wizard now has a "Require login" setting in step 2.

Stonefield Query SDK Version 5.2.5868

We are please to announce the release of version 5.2.5868 of the Stonefield Query SDK. There are several new features in this release.

Report Designer

• A new type of output is available: Microsoft Word Mail Merge. This allows you to perform a mail merge from a report to create form letters.

• A formula can now use an expression that doesn't retrieve data from the database, such as " ", which allows you to add a blank column to a report.

• The SQLookup function can now return an expression instead of just a field. The expression must be one the database engine can understand rather than a Stonefield Query expression.

• The GetConditionValue function now accepts a parameter indicating which value for "is between" and "is one of" conditions is returned.

• You can now turn off usage reporting by adding Usage=N to the [Options] section of Data.ini.

• If none of your data fields contain null values, you can make processing slightly faster by adding HandleNull=N to the [Options] section of Data.INI.

• Grouping formulas can now be used as data fields in a cross-tab report.

• Cross-tab reports now use the text for the Summary Total Template field in the template if it exists; this allows you to customize the text displayed for the totals line by changing the text in the template used by the report.

• Help now displays correctly even when running from a server without having to install the help file on the workstation.

• The Calculate Value at Group Level setting in the Formula Editor is now disabled if the field is a grouping formula since a formula can't be both.

• The GetConditionValue, GetValueForField, GetValueForParameter, GoMonthDay, SQLookup, STOD, and RunSQL functions now appear in the Built-in Functions list in the Expression Builder.

• The Print button in the Preview window is now disabled for a label report using a Dymo label size since it works better to print those labels directly rather than previewing first.

• You can now specify "login" on the command line to prompt the user to log in when running a dashboard from a shortcut. Also, theDashboard Wizard now has a "Require login" setting in step 2.

Stonefield Query Studio

• The new ReportEngine.BeforeSendEmail script allows you to change the settings of a report before it's emailed to someone.

• You can now customize what happens when refreshing the data dictionary for a database that has tables or fields removed. For example, you can use this to not remove tables or fields from modules that may not be in the database being refreshed from.

• You are now prompted before Stonefield Query Studio removes tables from the data dictionary after refreshing from a database that has tables or fields removed.

• Stonefield Query Studio now checks that you've selected the correct name delimiters (the reverse apostrophe: `) when adding a MySQL database to the data dictionary.

• Stonefield Query now handles two tables with the same name but different schemas.

• The default for the Support Online Updates and Support Maintenance Reminder configuration settings for new projects is now False.