Wednesday, March 5, 2008

The Last of the 3.2 Changes

Release Candidate 1 of the Stonefield Query SDK is now available. It has quite a few changes since the previous blog post.

New/Updated Features

  • Improvements were made in how link action scripts are handled, making it easier to do things such as link to Google Maps.
  • The new Analyze Database function in the Tools menu (also available in the Setup dialog) goes through your database and marks only those tables and fields that contain meaningful data as "favorites". Step 2 of the report wizards will then have a new Show only favorites option. Turn this option on to show only those tables and fields marked as "favorites". Turn it off again to show all tables and fields. This feature is only available if you turn on the new Enable Table/Field Favorites configuration setting, and is particularly useful for large (hundreds of tables) data dictionary in which not all tables and fields may contain meaningful data.
  • You can now drag a Stonefield Query import file (an SFX file) from Windows Explorer to the Reports Explorer to import that report. You can also drag an FRX file from Windows Explorer to the Reports Explorer to bring up the External Report Wizard for that report.
  • The Field Properties dialog for the Label Wizard has a new Display this field in the report setting. Turn this setting off if you want the field included in query (for example, you want to sort on it) but not display it in the report.
  • Step 3 of the Chart Wizard now displays the axis (X or Y) in the caption for the appropriate boxes, making it clear where a field will be graphed.
  • The Reports Explorer and Help menu now have a Manual function that displays the content of a PDF with the same name as the executable (SFQUERY.EXE by default). These functions are only visible if that file exists.
  • The close box on the Report Wizards is now functional.
  • The report wizards and Template Editor now appear in the Windows Task Bar when they're open so they're easy to locate when you have a lot of windows open.
  • You can now have multiple code zoom windows (right-click on the code box when a script is selected and choose Zoom) open in the Configuration Utility.
  • A new Application.ReportsExplorerReady script is available.
  • The new Execute method of the SQApplication object can be used to launch an application.
  • The Template Editor now has a shortcut menu.

Bug Fixes

  • Improvements were made in all dialogs so keyboard-only users (including disabled users) can move from one control to the next correctly.
  • A bug in how the project list in the Configuration Utility (displayed by clicking the arrow beside the Open Project button in the toolbar) is filled when opening projects was fixed.
  • The size and position of the Reports Explorer are now saved when you choose Exit from the File menu.
  • A bug that prevented a report from being exported properly immediately after renaming it in the Reports Explorer was fixed.
  • A grey box that appears when you clicked the Available To list in the Information page of the Reports Explorer no longer appears.
  • Closing Stonefield Query while multiple report wizards are open now works correctly, including the case where, when prompted if you want to cancel a report, you choose No. Also, the "cancel this report" dialog that appears now displays the name of the report so you can tell which report is being closed when multiple report wizards are open.
  • You no longer get a warning that a report has no filter if it has no filter but does have an exclusion filter or a TOP N clause.
  • Stonefield Query no longer stubbornly insists on downloading an update if you choose No in the Download Update dialog.
  • The Prompt for Subtable option no longer appears in the Add Database dialog when you choose to create an empty database.
  • A difficult-to-reproduce bug that caused an error immediately after adding a calculated field or virtual table in the Configuration Utility was fixed.
  • The Test button on the properties page for relations in the Configuration Utility is now disabled if the relationship information isn't complete.
  • A bug that caused an error if you try to sort on a calculated field that derives its value from a memo field was fixed.
  • A bug that caused an incorrect warning that a filter condition contains fields that aren't in the query when you have a custom SQL statement involving a subtable (got all that?) was fixed.
  • Ctrl+O is no longer the hotkey for the New Folder function in the File menu since that hotkey is usually reserved for an Open function in most applications.
  • A bug that prevented the code zoom window from being restored to the correct location if you had two monitors and the window was previously open on the second one but you only have one now was fixed. (Ok, that one was really obscure!)
  • If it exists, the value of the Desktop Image configuration setting is now moved to the Logo Image setting if that setting is blank.
  • Changing the value of the Advanced User setting for yourself in the Maintain Users and Groups dialog now takes effect immediately rather than after restarting Stonefield Query.
  • Downloading individual files during a product update now works correctly.
  • A bug that cut off the link status display in the preview window was fixed.
  • A bug that caused the Show All Fields option in the Filter Condition dialog to disappear after clearing the filter was fixed.
  • A bug that allowed you to click the OK button in the Login dialog a second time after the DataEngine.GetCustomMetaData script returned .F. (meaning Stonefield Query should terminate) and continue using the application was fixed.
  • A bug that prevented a field containing characters requiring it to be delimited (for example, a field named [Some-Field]) from being displayed correctly when defined as an enumerated field was fixed.
  • The Include this field in the group header for option in the Grouping page of the Field Properties dialog is no longer enabled if there are no groups.