Thursday, November 23, 2023

Stonefield Query SDK Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of the Stonefield Query SDK. There are several new features in this version.

Report Designer

  • You can now specify additional files to attach to an email in addition to the file for the report.

  • Cross-tab reports now support Highest and Lowest total types for date and datetime fields in the Data area.

  • You can now specify the horizontal orientation—left, right, or center, with center being the default—for a chart.

  • If you add another data source using the Other Data Sources dialog and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.

  • You can now specify that a table added in the Other Data Sources dialog is non-reportable.

  • There are several DataGrid enhancements:

    • The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.
    • The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.
    • Logical (yes/no) fields now display as check boxes.
  • You can now choose to not display a row field in a cross-tab report by setting its width to 0.

  • The recipient of an emailed report is now logged to the diagnostic file.

  • The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.

Stonefield Query Studio

  • DataEngine.GetObjectVersion script can check which database the objects belongs to with the ObjectDatabase variable.

  • A new BeforeProcessTables event in SQConfig.sqs allows you to execute custom code before tables are processed when the data dictionary is created or updated from a data source.

  • The new Application.AfterLogin script is called right after the user either successfully or unsuccessfully logs in.