Panorama 6 includes dozens of improvements to simplify and accelerate your database tasks.
Universal on Mac OS X (Native on Intel & PPC)
  • Up to 5X faster on Intel machines!
  • Up to 10X faster launch time (one bounce).
  • Reduced memory usage.
  • More stable (does not use Rosetta).
  • 100% Snow Leopard compatible.
  • 100% compatible with existing databases created in Panorama 5.x, 4.x and 3.x.
Total Recall
  • Instant seamless recovery from any type of crash: power outage, hardware failure, software failure.
  • Quickly resume your work right where you left off, including window positions, data entry, programming and graphics.
  • Now you can have it all, RAM speed and 100% data safety.
Enhanced Data Sheet Operation
  • Drag to re-arrange data sheet columns.
  • Selectively hide data sheet columns.
  • Right click on any data cell or header for pop-up menu with common commands for selecting, analyzing and organizing
  • Easily split fields into separate parts.
  • Easily merge two or more fields into one.
  • Simplified menus.
  • Smooth data sheet text
Advanced, Simplified, Search Dialog
  • Easily select from dozens of powerul search options (no geeky formula knowledge required), including:
    • Search all fields
    • Contains, beginswith, endswith
    • Equal to, less than, greater than
    • Is between or not between two values (for example 5 to 10)
    • Is close to (within 10%) a numeric value
    • Phonetic match (sounds like)
    • Date before, after or on a specific date
    • Date between two dates (for example Apr 1 to April 15)
    • Date close to a specified date (within 3 days, 7 days or 1 month)
    • Wildcard match (* and ?)
    • All upper or all lower case
    • First or last nn records
    • Even or odd records
    • Number of characters, words or lines
  • Live preview shows results as you type.
  • Save your favorite search queries for later re-use.
Next Generation Data Analysis
  • Easy dialog interface for setting up summaries and calculations, with live preview of summary results.
  • Easily expand/collapse summary outline using context menu (right click).
  • Save your favorite analysese for later re-use.
Time Lapse
  • Go back in time to previously saved versions of any database (like a multi-level Revert to Saved).
  • View multiple versions of a database at once (for example today vs. yesterday or last week).
  • Simple calendar interface for accessing previous versions of a database.
  • Full or partial restores (restore all, restore data, restore procedures, restore forms).
Simplified Data Manipulation and Calculation
  • Easily select from dozens of powerful manipulation and calculation options (no geeky formula knowledge required), including:
    • Add, subtract, multiply, divide
    • Multiply by percentage
    • Add or subtract days, months or years
    • Add prefix and/or suffix
    • Remove prefix and/or suffix
    • Convert to all upper or all lower case
    • Remove extra spaces and/or punctuation
    • Keep only specified character types (alphabetic, numeric, or custom)
    • Keep only the first nn characters, words or lines
    • Remove the first nn characters, words or lines
    • Keep text up to specified character or word
    • Replace word or phrase with another
    • Insert text in middle
    • Extract text between tags
  • Live preview shows results right in the dialog - no guessing and no mistakes.
  • Save your favorite manipulations and queries for later re-use.
Import/Export
  • Drag data directly from Excel or Numbers onto data sheet.
  • Create new databases directly from Excel or Numbers
  • Easily line up import fields with database fields.
  • Drag exported data directly to Excel, Word, Numbers, Pages, or to any folder
Procedures
  • Right click context menu in procedure editor.
  • New Programming Assistant wizard.
  • 57 new statements & functions
And More…
  • Enhanced Field Properties dialog.
  • Simplified New Database wizard.
  • Updated Recent Databases wizard.