This version must be manually downloaded and installed (as I expect for all beta downloads for the forseeable future). Here is the link.
To update Panorama X Server:
- Start by updating PanoramaX.app
- Launch Panorama X
- Open the Preferences dialog, switch to the Server pane
- If Panorama X Server is running, stop it
- Start Panorama X Server. It will automatically update before launching.
This version takes a detour from bug fixes and adds a major new feature, the join statement. This wasn’t really on the road map even ten days ago, but I had an epiphany about how to do this, and here it is. This new feature gives Panorama X the capability of doing joins in a manner very similar to SQL, including both inner and outer joins.
Used in it’s most basic form, the join statement can perform the same function as a formulafill statement combined with a lookup( function. However, the join statement is much, much faster. In tests joining a 400 record database with a 20,000 record database, join was 5x faster. When joining two 20,000 record databases, join was 135 times faster – a 7 minute formulafill took only 3 seconds with join. I believe these performance gains will increase even further with larger databases.
Of course the join statement isn’t just faster than previous Panorama relational features, it is far more flexible, and makes it much easier to set up comprehensive database joins.
Now that Panorama has join capabilities I have definite further ideas for embedding relational capabilities deeper into the program. However, these ideas may need to wait for a future release.
In addition to the new join feature, Panorama X 10.2b10 also includes nearly a dozen bug fixes and minor new features:
The new GlobalDictionaryBuild statement builds a global dictionary by scanning a database. (This statement was the inspiration for the join statement).
The GetTextDialog statement now works for editing local variables, even when the “sheet” option is used.
The OpenForm statement has a new option, NoVersionButton, that allows you to remove the caret icon just the the right of the window title (at the top of the window), and removes the ability to click on the title to rename the document, or to Command-Click on the title to see the path to this document. This option is now used on all wizard and utility windows (About Panorama, Memory Usage, Formula Workshop, etc.).
The new ClearGlobalDictionaryValues statement clears all values from a global dictionary (without actually deleting the global dictionary).
An .Initialize procedure that closes the database it is associated with no longer causes an error to occur.
Fixed synchronization of secret databases when opened as an auxiliary database and the primary database is not shared.
The OpenAsyncProgressWindow statement no longer fails with an error if passed a window height less than 200 points.
When Panorama is launched by double clicking on the app, the menus now work correctly.
The Server Administration window can no longer be resized (which just showed a bunch of empty white space).
Improved code for updating menus when user role is changed (from admin to user, etc.)
Incorporated documentation corrections submitted by Michael Kellock, Thomas Cooper and Kurt Meyer.