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.
- 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.
- 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
- 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.
- 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).
- 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.
- 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
- Right click context menu in procedure editor.
- New Programming Assistant wizard.
- 57 new statements & functions
- Enhanced Field Properties dialog.
- Simplified New Database wizard.
- Updated Recent Databases wizard.