Panorama X 0.1.025 (2011) Release Notes


#1

Panorama X 0.1.025 (2011) is now available. You can download this new version from the web site, or you can simply launch your current version of Panorama X and let it automatically update. If Panorama X is already running, choose Check for Updates in the Panorama menu.

This release is mostly about bug fixes. Behind the scenes, there has also been significant work done on the Panorama X client/server system, but all of that code is disabled in the public release. Most of the new statements and functions that are listed below have been added as part of the client/server work.

  • Now properly handles localization of floating point values in the data sheet, both for display and data entry/import (an empty pattern properly displays using the local thousands separator).

  • Panorama now ignores commas when inputting or importing numbers (or, if you are in a region where the decimal separator is a comma, it ignores decimal points).

  • Updated zip code data to June 2016.

  • The lookup( function now works correctly if the key field name contains a space or other unusual punctuation.

  • Fixed the Group Up by Quarter statement and the quarter1st( function, both of which were off by a month.

  • New throwerror statement, works with try/catch and onerror.

  • Added new dictionarydifference statement which compares the values in two dictionaries.

  • Added new commonpath( function which returns the path of common folders (desktop, library, documents, etc), even on non-English systems where these folders have localized names.

  • New info(“decimalseparator”) function returns the decimal separator character for the current region (period or comma).

  • Added new functions info(“countrycode”), info(“currencycode”), info(“currencysymbol”), info(“languagecode”), info(“measurementsystem”) that return information based on the current system locale (as specified in the System Preferences Language & Region panel).

  • Added StartBonjour/StopBonjour statements, and bonjour( function. These will be used by Panorama’s client/server system.

  • Added new statements and functions for compressing, uncompressing, and accessing .zip, .tar.gz and .tar.bz2 archives. These will be used by Panorama’s client/server system.

  • Matrix objects can now be printed.

  • Matrix objects now work in the data tile of a View-as-List form (they must not have a scroll bar, though).

  • Forms with multiple side-by-side tab panels now work correctly.

  • Panorama now ignores clicks in the empty area of tab panels (instead of triggering the associated procedure). Only clicks in the actual tab panel buttons trigger the procedure.

  • When printing a form with no Data Tile, Panorama now uses a white background (it was using a colored background in previous versions).

  • Sorting now works correctly with Choice fields. Also, works correctly when the list of choices is modified.

  • In a procedure, formulafill zeroblank(0) or formulafill "" will now correctly clear all cells in a numeric field. Also, now using fill "" also clears all cells in a numeric field.

  • Panorama now keeps track of the current field separately for each form and for the data sheet, so that the current field internally always matches what the user sees visually as the current field.

  • Fixed the matrixclick and info(“matrixclickedobjectid”) functions so that they work even when the matrix frame is in a separate form. Also added the new info(“matrixclickedframeform”) function.

  • The Clear, Copy, Cut and Paste statements now work identically to the ClearCell, CopyCell, CutCell and PasteCell statements, all known bugs in these statements are now fixed.

  • The CutRecord and PasteRecord statements no longer loop endlessly.

  • Text Editor objects will no longer display white text for selection in a View-as-List form (you can’t select the cell, so it was incorrectly partially highlighting).

  • The Database Options dialog now opens without an error message.

  • The info(“windowtype”) and info(“windowview”) functions now return the correct value for View-As-List form windows.

  • Now converts carriage returns to vertical tabs (\x0B) when exporting text, for compatibility with programs like Excel in exporting data that contains carriage returns.

  • Made a change that hopefully fixes the problem of forms sometimes opening with the property inspector panel visible. But since the problem couldn’t be reliably duplicated, this may or may not fix the problem.

  • Fixed problem where the first time a window is opened it would sometimes be the wrong height.

  • Matrix objects now support the Sync Up/Down option.

  • Fixed occasional incorrect display of Elastic Window objects in data mode.

  • The List/Matrix constructor now displays a warning notification if the <query> tag is below one or more <search> tags (in which case the constructor will not generate the search wizard).

  • The closefile statement now works properly with secret windows (or the setactivedatabase statement).

  • The initializedictionary statement now works properly if a value is a lone local variable (it would work with more complex expressions).

  • No longer can make elastic objects negative size my shrinking the window too far. The elastic object will still shrink almost to zero size, but not negative size – further shrinkage is ignored even if the window gets smaller. This also fixed a problem with the Help window.

  • Fixed problem that would cause crashes when clicking on an empty area in a View-As-List form.

  • When importing a database from Panorama 6, now correctly imports the background color of report tiles.

  • When importing a database from Panorama 6, now correctly imports matrix objects (this wasn’t quite correct in the previous 2 or 3 releases).

  • Now correctly opens View-As-List windows when importing a database from Panorama 6.

  • The New Account panel of the Site License wizard now has links to help pages for frequently asked questions and passwords.

  • Multiple minor changes and fixes in the Site License wizard.

  • The goform statement now stops the procedure if you try to use it in a non-form window (instead of causing an Objective-C runtime error).

  • Cleaned up menus in several wizards, including Help, Site License, View Organnizer, Memory Usage and Dialog Workshop. Disabled all print menu commands in these wizards.

  • Panorama Help wasn’t correctly rendering the page type in the parameter section when you previewed, it always said “plain” instead of “statement” or “function.”

  • Minor changes to processing payments and account management, including allowing 4 digit CVC codes (required for AMEX).

  • Assorted minor documentation corrections.


CSV import/export issues with Excel
Anomaly in converting from 6 to X
#2

Great News! I already can confirm, that Panorama X now recognizes and respects the system’s regional number formats, and I now can start to get rid of a lot of cumbersome workarounds I had to use before.

By the way, I also like it very much that Panorama X – previous versions already – supports OS X versioning and reverting.


#3

I am missing something very basic. This works in Pan6:
Fileglobal GS300
GS300 = 3
Field «DateRef»
FirstRecord
Loop
Loop
DownRecord
Until 12
If «DateRef» ≠ zeroblank(0)
InsertRecord
Endif
Until GS300

But in PanX it stops after inserting one record. It only works if the last line is Until 3


Until statement fixed loop count
#4

I think I encountered this issue; I think the until statement will not work correctly with a variable in this format; it requires a constant. If it is always 3, just put a 3 there.