#DATABASES FOR MAC CODE#
Databases that contain latitude/longitude data can be searched for proximity to specific locations - what airports are within 200 miles of San Francisco? If a database contains addresses within the United States, approximate proximity searches can be performed based on the zip code (lat/long data not required). If your data contains addresses, Panorama X can display it on a map. Relational keys are not limited to a single field, and can even be defined with a formula. Panorama's relational model supports one record-to-one record links, range-to-one record (shipping and tax tables, for example), and one record-to-many records. Panorama X streamlines data entry with features like Clairvoyance™ (auto-complete), automatic capitalization, input and output patterns, default values and the unique smart date feature that understands human friendly dates like today, friday or last monday. Proposed modifications are previewed in real time as they are changed, and actual database manipulation occurs at 10k-50k records per second. Multiple parsing/manipulation rules can be chained together for complex transformations, and sets of parsing/manipulation rules can be saved for later re-use. Modify all fields in a single operation.Recalculating entire field (with formula).Search & replace words, phrases or regular expression patterns.Splitting combined names into separate first/last names.Entire datasets can be rapidly altered based on parsing/manipulation rules set up from pop-up menus (advanced users can also use arbitrary formulas and regular expressions). Fields can be added, removed, rearranged, hidden, merged or split at any time. Panorama allows huge data sets to be bent, reshaped or refactored at will. You can even integrate code written in AppleScript, shell script, Python, Ruby, PHP and more.
#DATABASES FOR MAC FULL#
Programmabilityįor advanced users, Panorama X includes a full-featured programming language, including conditional logic, subroutines, alerts and dialogs, full menu control, background timers, asynchronous internet access, and much much more. It can also be attached to a button, or set up to trigger when a specific event occurs. The recorded code is automatically added to the Action menu, where it can be played back at any time. Just turn on the "watch me" recorder and Panorama will automatically write the code for you as you search, sort, and perform other database tasks. Recordabilityīasic automation doesn't require any programming at all. That's why every aspect of Panorama X operation can be automated - database manipulation, modifying database structure, even graphical layout tasks can be automated. If a task is going to be performed more than 2 or 3 times, automation is the best way to ensure that the task is performed rapidly and accurately. Here at ProVUE, we're big believers in automation.