Wednesday, March 16, 2022

Stonefield Query Enterprise is now Horizon Reports

Stonefield Software Inc. is pleased to announce that effective immediately, Stonefield Query Enterprise (the web version of Stonefield Query) has been purchased by Horizon Reports, https://www.horizon-reports.com. Horizon Reports is owned and operated by Trevor Mansuy, former lead developer of Stonefield Query Enterprise, so the product is in great hands. All licenses and software maintenance have been transferred to Horizon Reports.

Please note that Stonefield Software still owns and will continue to develop, maintain, and support Stonefield Query (the desktop version). Licenses of that version remain with Stonefield Software and we will continue to provide support and new versions of that product.

Thursday, January 20, 2022

Reporting4ACT! Version 8.1

We are pleased to announce the release of version 8.1 of Reporting4ACT! There are several new features in this version.

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Reporting4Act!.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

Friday, January 14, 2022

Stonefield Query for ALERE Version 8.1

We are pleased to announce the release of version 8.1 of Stonefield Query for ALERE. There are several new features in this version.

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

Stonefield Query for GoldMine Version 8.1

We are pleased to announce the release of version 8.1 of Stonefield Query for GoldMine. There are several new features in this version.

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

Thursday, January 13, 2022

Stonefield Query for AccountMate Version 8.1

We are pleased to announce the release of version 8.1 of Stonefield Query for AccountMate. There are several new features in this release.

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

Wednesday, January 12, 2022

Stonefield Query for Sage Pro ERP Version 8.1

 We are pleased to announce the release of version 8.1 of Stonefield Query for Sage Pro ERP. There are several new features in this version.

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

  • The performance of "Current + History" tables has been improved.

Stonefield Query for Sage 300 Version 8.1

We are please to announce the release of version 8.1 of Stonefield Query for Sage 300. There are several new features in this version.
  • Stonefield Query now works with Sage 300 2022 (version 6.9).

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

  • Database passwords up to 40 characters are now supported.

Thursday, January 6, 2022

Stonefield Query SDK Version 8.1

 We are pleased to announce the release of version 8.1 of the Stonefield Query SDK. Here are the new features.

Report Designer

  • The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

  • Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

  • You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

  • The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

  • If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

Stonefield Query Studio

  • The View Table Contents and View Field Contents windows now have search, filter, and export to Microsoft Excel functionality.

  • Project encryption is no longer supported.

  • VFP9R.dll, VFP9RENU.dll, and ISXDL.dll are no longer installed since they are no longer required.

  • The Generate Setup function now requires Inno Setup version 6.1 or later.

  • The installer has a more modern icon and appearance.

Thursday, October 28, 2021

Stonefield Query for GoldMine Version 8.0.7947

We are pleased to announce the release of version 8.0.7947 of Stonefield Query for GoldMine. The main purpose of this release is for compatibility with the new GoldMine 2021.2. The new features in this version are:

  • Stonefield Query is compatible with GoldMine 2021.2.

  • An issue causing some report output layouts to be distorted was resolved.

All new features and improvements from earlier version 8.0 releases are also included in 8.0.7947.

Friday, October 22, 2021

Reporting4Act! Version 8.0.7947

We are pleased to announce the release of version 8.0.7947 of Reporting4Act!. The main purpose of this release is to add compatibility with the new Act! v24. The new features in this version are:

  • Reporting4Act! is now compatible with Act! v24.

  • An issue causing some report output layouts to be distorted was resolved.

All new features and improvements from the initial version 8.0 release are also included in 8.0.7947.