The Relational Workshop wizard is a tool that assists in composing relational lookup(, superlookup( and arraybuild( functions. Of coourse you can write these functions by hand, but this workshop helps automate the process, and makes it easier to avoid mistakes. This workshop is similar to the Lookup Assistant dialog in earlier versions of Panorama, but goes much farther.
The Adjusting Object Spacing dialog adjust selected objects so that the same amount of space is in between each pair of objects.
The Spacing dialog will also work with a two dimensional grid of objects. This exammple uses a grid of two columns (one containing labels, the second containing Text Editor objects). Panorama understands that it needs to keep objects that are next together together, and not put a vertical gap in between them.
The Select Duplicates Dialog (in the Search menu) provides a fast and easy way to locate duplicate information in a database. The Select Duplicates command does not remove the duplicates, it simply selects them so you can examine them. You can then decide what to do about each duplicate on a case-by-case basis. You may select duplicates based on a single field (for example, all duplicate company names), on multiple fields (for example, all records with duplicate address, city, and state), or on a formula that may combine fields or use partial fields (for example, all records containing duplicate area codes).
The new Hotkey Workshop can assist you in composing a definehotkeys statement. The idea is simple ‰"ÛÓ you press any key, and the workshop gives you the code needed to turn that key into a hot key. There is no need to look up key codes in the documentation – you just press the key, and the workshop writes the code foe that key for you.
Fixed the Summary Workshop and Crosstab Workshop so that they work with fields that contain spaces or other punctuation.
Fix in 10.1 for Z-order layering of Image Display objects now works in macOS 10.13 (previously the fix only worked in 10.12 and earlier).
Fixes in Help wizard – after clicking on a link to jump to a new page, the Open in Browser and Copy URL to Clipboard commands now work with the displayed page. The prototype code and the topic list selection (on the left) will also update (though this may take up to 1 second). Also the Open Corrections Window command (in the Help wizard) now opens the correct source code page, even if the user has clicked on a link to get to the currently displayed page
Pressing Command-F in the Help window now makes the topic search area active, with all text selected. So now you can just press Command-F to quickly start a search (instead of bringing up the Find/Select dialog, as it did in previous versions).
Fixed problem that could prevent charts from displaying.
Group objects now appear in the correct position when used in View-As-List forms.
In the Summary Workshop and Crosstab Workshop wizards, added a new Display Chart in Browser menu command.
In the definehotkeys statement, no longer need to use the FUNCTION option for arrow keys, as well as Home, End, PageUp and PageDown. Also, you can now specify LeftArrow, RightArrow, UpArrow and DownArrow as alternatives to Left, Right, Up and Down (which still work)
A field using the count( function in an automatic calculation now correctly recalculates automatically when a line item field changes.
The info(“clickedobjectid”) function now works with Text Editor objects. Strictly speaking, the object may not have been clicked, but still it could be very handy to be able to find out what object triggered the procedure.
Implemented the info(“keycode”) function. The codes returned by this function are somewhat different than in Panorama 6.
No longer loses edited field properties (formulas, code, name etc.) if you open another window and then switch back to data sheet. Note: There is one situation where changes are lost – if editing a one-line property (name, pattern, etc.) and you switch back to the data sheet by clicking on the body (a row or column) of the data sheet. But if you click on the toolbar area, in the property inspector, use Command-Tab, or do anything else other than clicking on a data cell, changes are not lost. And no matter what, changes are not lost in multi-line properties like code, formula, choices and notes.
If a window is closed while editing a value in the inspector panel (form name, procedure name, field code, output pattern, field name, etc.) the change to the value is applied before the window is closed (in the past the change to the value would be lost unless you clicked somewhere else in the window before closing).
Fixed so that corrupted # of trial days in preferences won’t prevent Panorama from launching.
Changed messsage in “blue letter dialog” to “Your Panorama X account does not have a positive balance” (used to be “Your Panorama X account has a negative balance”).
Statements that display data even after an error occurs would not handle errors properly (if error, try/catch), now this is fixed. Problem was originally isolated in the SelectDuplicate statement, but also affects FormulaFillAllFields, ImportDatabase, ImportJSONLine, ImportJSON, ImportLine and ImportText.
Updated documentation with corrections submitted by William Conable, Michael Kellock and Thomas Cooper.