Thursday, April 10, 2008

Stonefield Query Version 3.2 Update

We posted updated versions of the Stonefield Query SDK, Stonefield Query for Sage Accpac ERP, Stonefield Query for Sage Pro ERP, Stonefield Query for GoldMine, and Stonefield Query for HEAT today with the following changes.

All Versions

  • Thanks to Boudewijn Lutgerink, the Dutch version of Stonefield Query is now current with version 3.2.
  • An error that occurred if you ran a report that uses the RunSQL function in the Advanced Report Designer was fixed. Also, editing a field using that function no longer executes the function.
  • A bug that caused an error if you created a new report then right-clicked in the Reports Explorer on a folder was fixed.
  • A bug that caused the Favorites folder to appear as "Favorites" in some dialogs rather than the localized equivalent when the language is set to something other than English was fixed.
  • Stonefield Query now has consistent behavior if you try closing it by clicking the Close button, right-clicking and choosing Exit, or choosing Exit from the File menu when a report wizard is open.
  • You no longer get an error if you press Esc during the "processing records" step when running a long report.

Sage Pro

  • The Analyze Database function now works correctly with Sage Pro databases.
  • The Pay Priority field in the Accounts Payable Master File in the Sage Pro version now supports a value of 0 for Payment Hold.
  • Stonefield Query now supports the case where you've customized the SQL statement for a report and used code that includes multiple SQL statements.
  • It now does a better job when updating from an older ACCPAC Query version.

Sage Accpac

  • Date fields in the Sage Accpac version now display as true date values rather than numeric values.
  • Some joins were optimized in the Sage Accpac data dictionary, making some reports (especially those involving Accounts Receivable Items) faster.
  • A bug that prevented reports involving Order Entry Invoices and Invoice Details from working correctly when you have more than one data dictionary was fixed.
  • It now does a better job when updating from an older ACCPAC Query version.


  • A bug that gave an error when creating help files for a project when you're running the Configuration Utility on Windows Vista or Windows XP using a limited user account was fixed. Also, it now gives a warning rather than an unexpected error if the folder for the help files is read-only.
  • The update process now displays the correct name of the updater application if you've changed it when the user runs the Check for Updates function and an update is available on a Windows Vista system.
  • Stonefield Query now supports updating project components, such as the data dictionary files.