Index

- Welcome to Panorama X! -- Table of Contents
- Creating a New Panorama X Account -- setting up a new account.
- Getting Started with Panorama X -- whether you are a brand new Panorama user or are moving up from a previous version, you'll find great tips for getting out of the blocks quickly.
- Importing a Panorama 6 Database -- Importing a Panorama 6 Database
- Managing Account Roles -- configuring a Panorama X account for a team, assigning privilege levels for administrators, developers, and general users.
- Managing Your Panorama X Account -- account expiration, adding credits, monitoring account activity, managing logged in computers, modifying contact information/passwords.
- Panorama Help Wizard -- learn how to get the most from Panorama's online help wizard, including choosing a realm, searching for a specific topic, and opening multiple help windows.
- Panorama Live Video Training -- learn how to access live video training sessions.
- Panorama Server -- sharing a database across multiple computers, or even across the entire internet.
- Panorama Video Training -- learn how to get the most from Panorama's video training wizard, including finding a video, zooming the video, opening related help topics, and purchasing on-demand training videos.
- Panorama X Account FAQ -- frequently asked questions about Panorama X accounts and pricing.
- Resetting a Lost or Forgotten Account Password -- using the Lost Password link in the Site License window.
- Tutorial -- basic step-by-step lessons for learning Panorama X, including data entry, searching, sorting, analyzing, creating forms and basic programming.
- - -- The - operator subtracts the numeric value on the right from the numeric value on the left.
- ?( -- The ?( function allows a formula to make a true/false, yes/no decision.
- * -- The * operator multiplies the numeric value on the left by the numeric value on the right.
- / -- The / operator divides one numeric value by another.
- \ -- The \ operator performs integer division.
- ^ -- The ^ operator raises a number to a power.
- + -- The + operator works differently depending on the type of operands used with it. If both operands are numeric, it does numerical addition. If either operand is text the + operator concatenates (joins together) the two operands.
- < -- The < operator compares two values to see if the first value is less than the second value.
- <= -- The <= operator compares two values to see if the first value is less than or equal to the second value.
- <> -- The <> operator compares two values to see if they are different.
- = -- The = operator compares two values to see if they are the same.
- > -- The > operator compares two values to see if the first value is greater than the second value.
- >= -- The >= operator compares two values to see if the first value is greater than or equal to the second value.
- 101: Building a Mailing List Database -- The tutorial begins by creating a new database with seven fields: first and last names, address, city, state, zip code and phone number. You'll also learn how to examine and modify field attributes, and how to rename a field.

- 102: Entering Data Into Your New Database -- This lesson introduces the basics of using the keyboard to enter new data into the database, as well as editing existing data. You'll learn about some basic data entry aids including automatic capitalization, input patterns, and the tab key. Finally, you'll learn how to expand the input area to edit multi line data.

- 103: Saving and Opening Database Files -- Panorama uses standard macOS techniques for saving your documents. All Panorama databases files end with an extension of .pandb. You'll learn several techniques for opening a database, including double clicking, open recent, and setting up favorite databases … even an easy way to find and open a database that you've lost (forgotten what folder it was in).

- 104: Importing Data Into the Mailing List -- If you already have data in another program (FileMaker, MySQL, a spreadsheet, etc.) you certainly don't want to re-enter that data in using the keyboard. In this lesson you'll learn how to import a text file (CSV, tab delimited, etc.) into an existing database. The data in the text file doesn't have to be arranged the same way as the database, Panorama can rearrange the data on the fly as it is imported. (Panorama can even split or merge columns as the data is imported, though that is not covered in this lesson).

- 105: Inserting a Field and Re-Importing -- This lesson shows how to insert a new field into the middle of an existing database, and then how to set up all of the options for the new field and re-import text into the modified database.

- 106: Sorting the Database -- You'll often need data arranged in some particular order: alphabetically, by date, price, etc. In this lesson you'll learn how to sort by one field or many, how sorts can be reversed (undo), and how to set up a favorite sort order so that it can be quickly accessed with a single click.

- 107: Searching for a Person -- Finding the data you need from a large database can be like finding a needle in a haystack. Panorama's search tools can quickly locate any data you are interested in. You'll also see how to jump from item to item if there is more than one data item that matches your search.

- 108: Selecting Instead Of Finding -- Panorama's selection tools allow you to focus on just the information you are currently interested in, making everything else temporarily invisible. For extra credit for advanced users, I'll show you how to modify the selected information as a batch, and how to undo batch operations.

- 109: Selecting from a Specific Field -- Up till now, all of the searches have been of the entire database, including all fields. Now you'll learn how to narrow the search to a specific field.

- 110: Selecting More of the Same -- It's easy to right click on any data item and ask Panorama to display other data items witht same, or similar values. For example you can quickly find other people with the same last name, or other people in the same state, or other checks written in the same month.

- 111: Zip Code Distance Searches -- If your database contains US databases with zip codes, you can right click to find other addresses that are close to the clicked address. You can choose to find other addresses that are with 15, 25, 50 or 100 miles.

- 112: Using the Sounds Like Search Option -- If you don’t know exactly how something is spelled you can try using Panorama’s sounds like option, which performs searches phonetically.

- 113: Making Complex Searches -- Panorama's Find/Select dialog can perform complex searches based on multiple criteria (up to 12, or even more in a program). The complex search is built up from individual simple searches, with a live preview as each component of the search is assembled.

- 114: Searching with a Regular Expression -- Regular expressions are a powerful technology that allow complex patterns to be created to perform sophisticated searches for just about anything – email addresses, phone numbers, urls, prices, part numbers, you name it. In fact, entire books have been written about regular expressions and how to use them. This lesson gives a brief introduction.

- 115: Searching with a Formula -- If Panorama's standard seach options aren't precise enough, any Boolean (true/false) formula can be used. You can choose from any of Panorama's hundreds of formula operators and functions, even perform searches that compare different fields (for example find all items where the price is more than twice the cost).

- 116: Selecting All Records -- This lesson is super easy — one command that makes all of the data in the database visible.

- 117: Saving Favorite Searches for Later -- It can take a lot of time to set up the complex searches described in the previous lessons. Fortunately, Panorama allows you to save any search so that you can repeat it later with a single click.

- 118: Temporarily Hiding One or More Fields -- This lesson shows how you can temporarily hide one or more fields so that you can focus on just the fields that you are interested in at the moment. Later you can easily make all fields visible again. You can also set up favorite configurations that quickly make only specific fields visible.

- 119: Automating Tasks with Procedures -- Right out of the box, Panorama is a very flexible program. Its built in menus and tools bring incredible power to your fingertips. Even better, you can easily create your own programs that can be activated with a menu or button. As shown in this lesson, you can write programs from scratch or you can have Panorama write a program for you simply by watching and recording your actions. In the course of this lesson I'll create programs that sort and select data, hide fields, and finally, display a map based on an address in the database.

- 120: Extra Credit: Running Code Automatically -- This lesson is for advanced users, and shows how a program can run automatically when data is entered into a field. In this lesson, a short program is created that runs when a phone number is entered. The program adds a default area code if necessary and formats the number. It also displays a notification if there are too many or too few digits.

- 121: Extra Credit: Importing and Cleaning Up More Names -- This is another advanced lesson that shows how to import data into an existing database even if the new data is in a different format from the existing data, and even if the new data isn't consistently formatted. In this example the new data is brought in directly from an Apple Numbers spreadsheet.

- 201: Introducing Forms (Graphical Layout) -- Now we switch gears to talk about "free form" custom layouts, which Panorama calls Forms. A form is like a piece of paper that allows you to design any arrangement you want -- labels, invoices, statements, whatever you need. A database can contain multiple forms, each with its own custom layout. In this lesson you'll learn how to create new forms, and how to create and manipulate graphic objects within a form.

- 202: Forms: Working with Data -- This lesson demonstrates how to include data in a form, both for display and editing.

- 203: Creating a Data Entry Form -- Assembling a complex data entry form piece-by-piece can be tedious. Fortunately, Panorama can do most of the work for you, automatically creating a pixel perfect layout in seconds. In fact, I'll build a complete data entry form for this mailing list database in seven seconds flat.

- 204: Adding Buttons to a Form -- It's easy to add a push button to a form. In this lesson I'll create a standard push button, and also a graphical icon button (Panorama includes almost 700 icons from the Font Awesome collection) and a button constructed from an image.

- 205: Printing Mailing Labels -- Panorama has powerful capabilities for printing custom reports. In this lesson, I'll build a simple template for printing Avery 5160 mailing labels.

- 206: Displaying a Map -- With the ability to embed a web browser into a form, the entire internet is accessible from within Panorama. You can access any public web page, or you can construct HTML on the fly from your database (this help system is constructed with a Panorama form that contains an embedded web browser). In this lesson, a browser is used to embed a map directly into the database.

- 207: Searchable List -- In addition to Panorama's standard Find/Select dialog, you can also build a custom search list into a form. The list is automatically synced with the database, or you can create a list that has its own independent data source.

- 208: Tab Panels -- Tab Panels provide a way to cram a lot of user interface into a limited area. In this example I'll use a tab panel to combine four forms into one, with control buttons to switch between different panels.

- 301: Building and Organizing a Checkbook -- Now that you’ve created your first simple mailing list database, you’re ready to try something more complicated. In this lesson you’ll build and use a database for keeping track of a checkbook. This lesson starts by creating the new database and setting up the fields.

- 302: Checkbook Sample Data -- In this lesson the new checkbook database is filled with imported sample data.

- 303: Data Entry Helpers -- Before you can work with and analyze data, you have to get the data into the database, and that usually means data entry with the keyboard. This job is never easy, but Panorama does have tools that can make data entry faster and less error prone. This lesson examines how Panorama can improve the data entry process for each of the fields in the checkbook database.

- 304: Selecting Data -- Earlier lessons demonstrated searching in depth, but only in a database with text fields. Since the checkbook contains date and numeric fields, there are some additional searching tips.

- 305: Totals, Summaries and Charts -- In this lesson you'll see how you can quickly calculate totals, summaries, and charts of summarized data.

- 306: Collapsible Outline Summaries -- In this lesson you'll see how Panorama can quickly calculate subtotals and totals, organizing them into an outline that can be collapsed or expanded to see just the level of detail you need. Once calculated, you can even "rank" summaries, for example to show where spending is concentrating or which regions have the highest sales. The ability to “zoom” in and out like this is a great tool for actually understanding your data.

- 999: Further Reading -- Suggestions for Panorama topics beyond the tutorial.
- abortalldialogs -- The abortalldialogs statement closes all open dialog windows (with prejudice).
- abortifstructurelocked -- The abortifstructurelocked statement Check if database structure is locked, if it is, notify user and stop program.
- abs( -- The abs( function calculates the absolute value of a number.
- Accessing the Clipboard -- reading from and writing to the system's clipboard.
- Action Menu -- simple way to create your own menu items.
- activegrid -- The activegrid statement manages the operation of a grid that controls a series of options.
- activeobjectaction -- The activeobjectaction statement allows a procedure to communicate with the object on the current form that is currently being edited (if any).
- addfield -- The addfield statement adds a new field to the current database (on the end).
- Adding New Fields -- adding one or more fields to a database.
- addlines -- The addlines statement adds a specified number of records to the end of a database.
- addmultiplerecords -- The addmultiplerecords statement Adds multiple records.
- addrecord -- The addrecord statement adds a new record at the end of the current database.
- addrelatedrecord -- The addrelatedrecord statement adds a new record to the related database corresponding to the current database.
- addremotehost -- The addremotehost statement makes a remote host available to this computer.
- Adjusting Object Spacing -- adjust the spacing between multiple selected objects so that the same amount of space is in between each pair of objects.
- adjustobjectspacing -- The adjustobjectspacing statement adjusts the spacing of selected objects in a form.
- adjustobjectspacingdialog -- The adjustobjectspacingdialog statement opens a dialog sheet to adjust the spacing of the currently selected objects.
- adjustservervariable( -- The adjustservervariable( function adjusts the value of a server variable. This is an "atomic" operation, so it is multi-user friendly.
- adjustservervariable -- The adjustservervariable statement adjusts the value of a server variable. This is an "atomic" operation, so it is multi-user friendly.
- adjustxy( -- The adjustxy( function adjusts the four corners of a rectangle. However, only corners that are inside a boundary are adjusted. Corners outside the boundary are left alone.
- Advanced Server Settings -- Panorama X Server settings for advanced users.
- after( -- The after( function extracts all text after a specified tag (sequence of characters).
- age( -- The age( function calculates a person's current age (in years) from their birthdate.
- aggregate( -- The aggregate( function calculates an aggregate (sum (total), count, minimum, maximum or average) by scanning specified records in a database.
- alert -- The alert statement displays a modal alert window with a message and one or more buttons.
- alertcanceldelete -- The alertcanceldelete statement displays a modal alert window with a message and two buttons: Cancel and Delete.
- alertcancelok -- The alertcancelok statement displays a modal alert window with a message and two buttons: Cancel and Ok.
- alertdeletecancel -- The alertdeletecancel statement displays a modal alert window with a message and two buttons: Delete and Cancel.
- alertmodal -- The alertmodal statement displays a modal alert sheet (not attached to any window) with a message and one or more buttons.
- alertnoyes -- The alertnoyes statement displays a modal alert window with a message and two buttons: No and Yes.
- alertok -- The alertok statement displays a modal alert window with a message and one button: Ok
- alertokcancel -- The alertokcancel statement displays a modal alert window with a message and two buttons: Ok and Cancel.
- alertoksmall -- The alertoksmall statement displays a modal alert window with a message and one button: Ok
- alertrevertcancel -- The alertrevertcancel statement displays a modal alert window with a message and two buttons: Revert and Cancel.
- Alerts -- displaying a variety of standard modal alerts.
- alertsavecancel -- The alertsavecancel statement displays a modal alert window with a message and two buttons: Save and Cancel.
- alertsheet -- The alertsheet statement displays an alert sheet (attached to the current window) with a message and one or more buttons. Note: with the introduction of OS 11, Big Sur, sheets no longer appear to slide down from the title bar, but open a dialog centered on the active window.
- alerttimestampmismatches -- The alerttimestampmismatches statement display mismatched time stamps.
- alertyesno -- The alertyesno statement displays a modal alert window with a message and two buttons: Yes and No.
- alertyesnocancel -- The alertyesnocancel statement displays a modal alert window with a message and three buttons: Yes, No and Cancel.
- aliaspath( -- The aliaspath( function returns the path an alias points to (or an error if the specified file isn't an alias).
- Aligning Objects -- so that two or more object edges are made even with each other.
- alpha( -- The alpha( function extracts the alpha (opacity) from a color.
- alphabeticnumber( -- The alphabeticnumber( function converts a number into letters: A, B, C, etc.
- analyzedialog -- The analyzedialog statement opens the standard Analyze dialog.
- and -- The and operator returns true if both operands are true.
- append -- The append statement appends a text string to a field or variable.
- appenddataarrays( -- The appenddataarrays( function appends two or more data arrays to each other (see Data Arrays).
- appenddictionaryvalue -- The appenddictionaryvalue statement appends a value to an item in a dictionary (see Data Dictionaries).
- appendline -- The appendline statement appends a text string to a field or variable on a new line.
- appendluhncheckdigit( -- The appendluhncheckdigit( function adds a Luhn check digit to a series of digits.
- appledayzero( -- The appledayzero( function returns an internal constant used for converting between superdates and regular dates.
- applescript( -- The applescript( function executes AppleScript source code and returns the result.
- applescript -- The applescript statement executes an AppleScript.
- AppleScript -- writing scripts with AppleScript.
- applescriptconstant( -- The applescriptconstant( function converts an expression into an AppleScript literal.
- applescriptstring( -- The applescriptstring( function converts text into an AppleScript string literal.
- arccos( -- The arccos( function calculates the inverse cosine of a numeric value.
- arccosh( -- The arccosh( function calculates the inverse hyperbolic cosine of a numeric value.
- archivecontents( -- The archivecontents( function lists the contents of a compressed archive in *.zip*, *.tar.gz* or *.tar.bz2* format.
- arcsin( -- The arcsin( function calculates the inverse sine of a numeric value.
- arcsinh( -- The arcsinh( function calculates the inverse hyperbolic sine of a numeric value.
- arctan( -- The arctan( function calculates the inverse tangent of a numeric value.
- arctanh( -- The arctanh( function calculates the inverse hyperbolic tangent of a numeric value.
- Arithmetic Formulas -- mathematical operators and functions.
- array( -- The array( function extracts a single data item from a text array or a data array (see Text Arrays and Data Arrays).
- arrayboth( -- The arrayboth( function creates a new array from two arrays. The new array contains only items that are in both of the original arrays.
- arrayboth -- The arrayboth statement creates a new array from two existing arrays. The new array contains only items that are in both of the original arrays.
- arraybuild( -- The arraybuild( function builds an array by scanning a database and creating an array element for every record (including invisible records) in the database (see Text Arrays).
- arraybuild -- The arraybuild statement builds an array by scanning a database and creating an array element for every record (including invisible records) in the database (see Text Arrays).
- arraychange( -- The arraychange( function changes the value of a single data item in a text array or a data array (see Text Arrays and Data Arrays).
- arraycolumn( -- The arraycolumn( function extracts a column from a two dimensional array.
- arraycommonprefix( -- The arraycommonprefix( function finds the common prefix (if any) of all items in an array.
- arraycontains( -- The arraycontains( function checks to see if any element of a text array or a data array matches a specified value.
- arraydeduplicate( -- The arraydeduplicate( function removes duplicate elements from a text array (see Text Arrays).
- arraydeduplicate -- The arraydeduplicate statement removes duplicate elements from an array (see Text Arrays).
- arraydelete( -- The arraydelete( function deletes (removes) one or more elements from a text array or a data array (see Text Arrays and Data Arrays).
- arraydeletevalue( -- The arraydeletevalue( function deletes any array elements that match the value parameter. This must be an exact match, including upper and lower case. If the value occurs multiple times in the array, every occurence of the value will be removed, with one exception: if the value occurs in two consecutive array elements, only the first occurence will be deleted.
- arraydifference( -- The arraydifference( function creates a new array from two existing text arrays. The new array contains only items that are in the first array but not in the second array.
- arraydifference -- The arraydifference statement creates a new array from two existing text arrays. The new array contains only items that are in the first array but not in the second array.
- arrayelement( -- The arrayelement( function converts between character positions and array element numbers in a text array.
- arrayfilter( -- The arrayfilter( function processes each element of a text array or a data array with a formula (see Text Arrays and Data Arrays).
- arrayfilter -- The arrayfilter statement processes each element of an array with a formula (see Text Arrays).
- arrayfirst( -- The arrayfirst( function extracts the first element of a text array.
- arrayhack( -- The arrayhack( function hacks an array by adding, replacing or removing array elements
- arrayinsert( -- The arrayinsert( function inserts one or more empty elements into the middle of a text array (see [Text Arrays]).
- arrayintegersort -- The arrayintegersort statement sorts all the numeric elements of a text array in proper numeric order.
- arrayitemsandwich( -- The arrayitemsandwich( function adds a prefix and/or suffix to each non-blank item in a text array.
- arrayitemtrim( -- The arrayitemtrim( function removes characters from the beginning and/or end of each item in an array.
- arraylast( -- The arraylast( function extracts the last element of an array.
- arraylefttrim( -- The arraylefttrim( function removes one or more elements from the beginning of an array.
- arraylookup( -- The arraylookup( function uses a key to look up a value in a two dimensional text array containing key/value pairs (see Text Arrays).
- arraymenuitems( -- The arraymenuitems( function converts a carriage return delimited array into a series of menu items.
- arraymerge( -- The arraymerge( function merges two text arrays together (see [Text Arrays]).
- arraymultisort( -- The arraymultisort( function sorts a two-dimensional array on the key of one or more of its columns.
- arraymultisort -- The arraymultisort statement sorts a two-dimensional array on the key of one or more of its columns.
- arraynotcontains( -- The arraynotcontains( function is the reverse of arraycontains(. it returns false if the value is in the array, true if it is not in the array.
- arraynumericsort( -- The arraynumericsort( function sorts a text array in numeric order (see Text Arrays).
- arraynumericsort -- The arraynumericsort statement sorts all the numeric elements of a text array in proper numeric order.
- arraynumerictotal( -- The arraynumerictotal( function totals all the numeric elements of a text array.
- arraynumerictotal -- The arraynumerictotal statement totals all the numeric elements of a text array.
- arrayrandomize( -- The arrayrandomize( function reorders an array in random order.
- arrayrandomize -- The arrayrandomize statement reorders an array in random order.
- arrayrange( -- The arrayrange( function extracts a series of data items from a text array or a data array (see Text Arrays and Data Arrays).
- arrayrelocate( -- The arrayrelocate( function moves one or more items to a new position in a text array or a data array (see Text Arrays and Data Arrays).
- arrayrelocate -- The arrayrelocate statement moves one or more items in a text array to a new position.
- arrayreplacevalue( -- The arrayreplacevalue( function changes array elements that match a specified value.
- arrayreverse( -- The arrayreverse( function reverses the order of the elements in a text array or a data array (see Text Arrays and Data Arrays).
- arrayreverselookup( -- The arrayreverselookup( function uses a value to look up a key in a two dimensional text array containing key/value pairs (see Text Arrays).
- Arrays -- work with a numbered collection of data items (including Text Arrays and Data Arrays.
- arraysearch( -- The arraysearch( function searches a text array or a data array (see Text Arrays and Data Arrays) to see if it contains a specific value.
- arrayselectedbuild( -- The arrayselectedbuild( function builds an array by scanning a database and creating an array element for every visible (selected) record in the database (see Text Arrays).
- arrayselectedbuild -- The arrayselectedbuild statement builds an array by scanning a database and creating an array element for every visible (selected) record in the database (see Text Arrays).
- arraysize( -- The arraysize( function returns the number of elements in a text array or a data array (see Text Arrays and Data Arrays).
- arraysort( -- The arraysort( function alphabetizes (A-Z) the elements in a text array (see [Text Arrays]).
- arraysort -- The arraysort statement sorts the elements in an array (see Text Arrays).
- arraystrip( -- The arraystrip( function removes any blank elements from a text array or a data array (see Text Arrays and Data Arrays).
- arraystrip -- The arraystrip statement strips blank elements from an array.
- arraytableceiling( -- The arraytableceiling( function looks up a value in a double column table, similar to the table( function but from an array instead of a database.
- arraytablefloor( -- The arraytablefloor( function looks up a value in a double column table, similar to the table( function but from an array instead of a database.
- arraytoggle -- The arraytoggle statement "toggles" a value within an array.
- arraytopythonlist( -- The arraytopythonlist( function converts a Panorama array into a Python list.
- arraytrim( -- The arraytrim( function removes one or more elements from the end of an array.
- arrayunpropagate( -- The arrayunpropagate( function scans an array from top to bottom, removing duplicate values in a row.
- arrayunpropagate -- The arrayunpropagate statement scans an array from top to bottom, removing duplicate values in a row.
- asc( -- The asc( function converts the first character of a text string into a number from 0 to 65535 based on Unicode encoding.
- assign( -- The assign( function assigns a value to a field or variable, also returning the value.
- assign -- The assign statement assigns a value to a field or variable.
- assignfield -- The assignfield statement performs an assignment, much like an equals sign or the assign statement. However, the assignfield statement only performs the assignment to a database field, not to any variable.
- assignfieldwithsideeffects -- The assignfieldwithsideeffects statement performs an assignment, much like an equals sign or the assign statement. However, the assignfieldwithsideeffects statement only performs the assignment to a database field, not to any variable. After performing the assignment, it will run any side effects associated with the field, including formulas and code associated with the field.
- assignfileglobal -- The assignfileglobal statement performs an assignment, much like an equals sign or the assign statement. However, the assignfileglobal statement only performs the assignment to a fileglobal variable.
- assignglobal( -- The assignglobal( function assigns a value to a global variable (creating the variable if necessary).
- assignglobal -- The assignglobal statement performs an assignment, much like an equals sign or the assign statement. However, the assignglobal statement only performs the assignment to a global variable.
- assignlocal -- The assignlocal statement performs an assignment, much like an equals sign or the assign statement. However, the assignlocal statement only performs the assignment to a local variable.
- assignservervariable -- The assignservervariable statement assigns a value to a permanent variable on the server. If the server variable does not already exist, it will be created.
- assignwindowglobal -- The assignwindowglobal statement performs an assignment, much like an equals sign or the assign statement. However, the assignwindowglobal statement only performs the assignment to a windowglobal variable.
- autoallfieldwidths -- The autoallfieldwidths statement automatically sets the width of all fields based on the data in each field.
- autofieldwidth -- The autofieldwidth statement automatically sets the width of the current field based on the data in it.
- Automatic Field Calculations -- performing formulas automatically when data is entered into a field.
- Automatic Field Code -- running a short program when data is entered into a field.
- Automatic Form Construction -- creates a column of form elements for editing data fields (or variables).
- Automatic Mailing Label Construction -- creates a mailing label.
- Automatic Record Numbering in a Shared Database -- generating unique numbers across multiple users.
- Automatic Report Construction -- creates a tabular report with columns of data.
- Automatic Startup Database -- automatically open one or more databases when Panorama is launched.
- automaticfieldchoices -- The automaticfieldchoices statement updates the current field's Choice list with actual data in the database.
- automaticfieldname( -- The automaticfieldname( function returns an available field name.
- automaticformname( -- The automaticformname( function returns an available form name.
- automaticprocedurename( -- The automaticprocedurename( function returns an available procedure name.
- Auxiliary Databases -- automatically opening multiple databases associated with each other.
- average -- The average statement calculates averages and sub-averages for the selected records in the current field.
- batchassign -- The batchassign statement assigns a bunch of fields/variables to another bunch of fields/variables.
- batchreplace( -- The batchreplace( function performs multiple find/replace operations on a piece of text.
- batchreplace -- The batchreplace statement performs multiple find and replace operations on a piece of text.
- beep -- The beep statement makes the computer speaker beep once.
- before( -- The before( function extracts all text before a specified tag (sequence of characters). If the tag doesn't exist the function returns "".
- beginswith -- The beginswith operator returns true if the value on the left starts with the value on the right, false if it doesn't.
- bestfitrectangle( -- The bestfitrectangle( function fits a rectangle within a boundary rectangle, enlarging or reducing as necessary to produce the best fit without changing the proportions.
- bestfitrectangle -- The bestfitrectangle statement fits a rectangle within a boundary rectangle, enlarging or reducing as necessary to produce the best fit without changing the proportions.
- between( -- The between( function checks to see if a value is between two other values.
- bigendian( -- The bigendian( function returns true if Panorama is running on a "big endian" processor
- bigendianbinaryvalue( -- The bigendianbinaryvalue( function converts big endian binary data (a byte, word, or longword) into an unsigned number (see Binary Data).
- bigmessage -- The bigmessage statement displays a message alert.
- Binary Data -- Panorama allows a formula or procedure to work with raw binary data.
- binarydatabuild( -- The binarydatabuild( function builds a binary value by scanning a database and assembling individual binary values for every record (including unselected records) in the database.
- binarydatatype( -- The binarydatatype( function returns information about the type of structure data contained in a binary data value, if available (see Binary Data).
- binarytotext( -- The binarytotext( function converts binary data into text, optionally using a specified encoding.
- binaryvalue( -- The binaryvalue( function converts binary data (a byte, word, longword, or longlongword) into a number (see Binary Data).
- bit( -- The bit( function converts a bit number (1 to 64) into a number (1, 2, 4, 8, 16, etc.)
- black( -- The black( function returns black as a Panorama color value (see Colors).
- blindposixscript( -- The blindposixscript( function executes a POSIX shell script using NSTask and returns the process id.
- blockkeyboard -- The blockkeyboard statement temporarily suspends/resumes keyboard input.
- blue( -- The blue( function extracts the blue intensity from a color.
- blueprintlibraries -- The blueprintlibraries statement generates blueprints for all procedure library databases.
- blueprinttool -- The blueprinttool statement handles clicks in the Blueprint Tool (graphic mode).
- bonjour( -- The bonjour( function returns a list of available hosts.
- bonjourserversenabled( -- The bonjourserversenabled( function returns true if client access to bounjour servers (on local network) is enabled.
- bookmarkpath( -- The bookmarkpath( function converts saved bookmark data (from the filebookmark( function) into a standard file path.
- bookmarkshareddatabase -- The bookmarkshareddatabase statement saves the local location of the current shared database.
- booleanvalue( -- The booleanvalue( function converts a numeric or text value to Boolean (true/false).
- boolstr( -- The boolstr( function converts a Boolean value to text, either `"true"` or `"false"`.
- brightness( -- The brightness( function extracts the brightness from a color.
- bringforward -- The bringforward statement brings the selected form objects one layer towards the front.
- bringpanoramaforward -- The bringpanoramaforward statement brings Panorama forward, making it the active Application.
- bringtofront -- The bringtofront statement brings the selected form objects to the front.
- buildfavoritesmenu -- The buildfavoritesmenu statement builds the Favorite Databases menu.
- buildwizardmenus -- The buildwizardmenus statement scans the wizard folder to build the Wizard menu and submenus.
- Bulk Data Transformations on Shared Databases -- using formulafill, propagate, etc. in a shared environment.
- bundleresourcepath( -- The bundleresourcepath( function returns the file path and name of a specified item in the Panorama application bundle.
- byte( -- The byte( function converts a number into a single byte of binary data (see Binary Data).
- bytearray( -- The bytearray( function extracts a value from an array of bytes (see [Binary Data]).
- bytepattern( -- The bytepattern( function converts a byte count to text: 543 Bytes, 543 Kb, 123 Mb, 3.2 Gb
- cache( -- The cache( function stores a value in a temporary variable.
- calcenclosingrectangle -- The calcenclosingrectangle statement will calculate the rectangle surrounding all of the specified objects.
- calendardate( -- The calendardate( function helps in creating monthly calendars.
- calendarday( -- The calendarday( function helps in creating monthly calendars.
- call( -- The call( function allows a procedure to be called as a subroutine within a formula and return a result.
- call -- The call statement allows a procedure to call a separate procedure within the current database as a subroutine.
- calledby( -- The calledby( function returns true if this function is in code called by the specified database, the specified procedure, or both.
- callerslocalvariablevalue( -- The callerslocalvariablevalue( function allows a subroutine to access a local variable in the procedure that called it.
- callingdatabase( -- The callingdatabase( function returns the name of the database that called this procedure as a subroutine, if any.
- callingprocedure( -- The callingprocedure( function returns the name of the procedure that called this procedure as a subroutine, if any.
- callwithin( -- The callwithin( function allows a "mini-procedure" to be called as a subroutine within a formula and return a result.
- callwithin -- The callwithin statement allows a procedure to call a mini-procedure within a separate procedure within the current database as a subroutine.
- callwithindatabase( -- The callwithindatabase( function returns true if the current procedure was called by another procedure in the same database, false if it was called by a procedure in another database.
- cancelok -- The cancelok statement displays a modal alert window with a message and two buttons: Cancel and Ok.
- cardexpirevalidate( -- The cardexpirevalidate( function checks the validity of a credit card expiration date.
- cardtype( -- The cardtype( function returns the credit card type (American Express, Visa, MasterCard or Discover).
- cardvalidate( -- The cardvalidate( function verifies that a number is a valid credit card number.
- cardvalidate -- The cardvalidate statement verifies that a number is a valid credit card number.
- case -- The case statement allows multiple decisions to be chained together (also see the elseif statement).
- catch -- The catch statement works with try and endcatch to trap errors in a sequence of statements.
- catcherror( -- The catcherror( function evaluates an expression, but suppresses any error generated by that expression.
- ceil( -- The ceil( function converts a number to an integer, truncating toward positive infinity.
- cell -- The cell statement enters a value into the currently active field (i.e. cell).
- cgilink( -- The cgilink( function creates a domain independent URL for another CGI action on the same server.
- cgilinknewwindow( -- The cgilinknewwindow( function creates a domain independent link for another CGI action on the same server that opens a new browser window.
- cginavlink( -- The cginavlink( function creates a domain-independent navigation link for the current record in this database.
- cginavlinknewwindow( -- The cginavlinknewwindow( function creates a domain-independent navigation link (to a new browser window) for the current record in this database.
- cgitest -- The cgitest statement tests a CGI procedure.
- change -- The change statement replaces text with new text in the current field (selected records only).
- changedictionaryname -- The changedictionaryname statement changes the name (key) of an item in a dictionary (see Data Dictionaries).
- changedictionaryvalues( -- The changedictionaryvalues( function changes one or more values in a dictionary (see Data Dictionaries).
- changeobject -- The changeobject statement modifies the properties of one object in a form.
- changeobjects -- The changeobjects statement modifies the properties of one or more objects in a form.
- changetimer -- The changetimer statement modifies a repeating task that will be performed periodically when Panorama is not otherwise busy.
- changeword -- The changeword statement replaces one word with another in the current field (selected records only).
- changewordexact -- The changewordexact statement replaces one word with another in the current field (selected records only).
- Changing the Design of a Shared Database -- modifying database fields, forms and/or procedures.
- channelactivemodule( -- The channelactivemodule( function returns the currently active module for a channel, if any.
- channelactivemodule -- The channelactivemodule statement returns the currently active module for a channel, if any.
- channelcall -- The channelcall statement calls a procedure in the active channel module.
- channelcatalog -- The channelcatalog statement creates a list of all channel databases (including the path for each database).
- channelgetdictionary -- The channelgetdictionary statement returns the current settings for a specified channel.
- channelinformation( -- The channelinformation( function returns information about a specified channel.
- channelinformation -- The channelinformation statement returns information about a specified channel.
- channelload -- The channelload statement loads a channel module.
- channelmodules( -- The channelmodules( function returns a list of available modules for a specified channel type.
- channelmodules -- The channelmodules statement returns a list of available modules for a specified channel type.
- channelopen -- The channelopen statement opens a channel module for editing.
- channelpath( -- The channelpath( function returns the path of a specified channel module.
- channelpath -- The channelpath statement returns the path of a specified channel module.
- channelprocedures -- The channelprocedures statement returns a list of procedures available in a specified channel.
- Channels -- provide a standard way to interface with external resources (email servers, phones, web sites etc.)
- channelsetdictionary -- The channelsetdictionary statement saves new settings for a specified channel.
- channelswitch -- The channelswitch statement switches the active channel module.
- channeltypes( -- The channeltypes( function returns a list of available channel types.
- channeltypes -- The channeltypes statement returns a list of available channel types.
- characterfilter( -- The characterfilter( function scans and filters text on a character by character basis.
- characterfilter -- The characterfilter statement scans and filters text on a character by character basis.
- Characters and Unicode Values -- working with individual characters of text.
- chararray( -- The chararray( function extracts a single character from text.
- chart( -- The chart( function converts a table of data into an HTML page with a chart (bar, line, pie, etc.).
- checkdesignlock -- The checkdesignlock statement checks if field structure can be changed, if not, returns an error.
- checkedarraymenuitems( -- The checkedarraymenuitems( function converts a carriage return delimited array into a series of menu items, some of which may be checked.
- checkedmenuitem( -- The checkedmenuitem( function creates a single menu item with an optional checkmark.
- checkemptyselection -- The checkemptyselection statement notifies the user if a selection failed, and reverts to the previous selection.
- checkforupdates -- The checkforupdates statement performs the same action as the Check for Updates menu item.
- checkserverconnection( -- The checkserverconnection( function checks to see if the specified server is connected.
- checkserverconnection -- The checkserverconnection statement checks to see if the specified server is connected.
- checkserversynchronization -- The checkserversynchronization statement checks the synchronization of the current database.
- checkstructurelock -- The checkstructurelock statement Check if database structure is locked, if it is, notify user and stop program.
- chevronquoted( -- The chevronquoted( function adds « » quotes to text if necessary to make it a legal Panorama token.
- Choices -- fixed list of choices.
- choosefiledialog -- The choosefiledialog statement displays a modal dialog allowing selection of files or folders.
- choosefolderdialog -- The choosefolderdialog statement pauses and displays the standard “choose folder” dialog.
- chr( -- The chr( function converts a number into a single character of text, based on Unicode encoding.
- chunkarray( -- The chunkarray( function extracts a binary "chunk" from binary data (see Binary Data).
- city( -- The city( function looks up the name of a city associated with a US zip code.
- cityzip( -- The cityzip( function returns the lowest zip code associated with a city.
- cityzips( -- The cityzips( function returns a list of zip codes associated with a city.
- classicdictionaryvalue( -- The classicdictionaryvalue( function returns the value of an item in the dictionary, given its key (see Data Dictionaries). Unlike getdictionaryvalue(, this function does not treat keys as case sensitive.
- clear -- The clear statement deletes the contents of the current cell without touching the clipboard.
- clearcell -- The clearcell statement deletes the contents of the current field.
- clearglobaldictionaryvalues -- The clearglobaldictionaryvalues statement clears (removes) all the keys and values from the specified global dictionary.
- clearrecord -- The clearrecord statement deletes the currently selected record.
- cleartypeahead -- The cleartypeahead statement clears any typed ahead characters that have been pressed while a procedure is running.
- clearundo -- The clearundo statement clears out the undo stack, eliminating the ability to undo any previous action.
- Client/Server Debug Instrumentation -- using instrumentation with Panorama X server and clients.
- clientimportallocaterecords -- The clientimportallocaterecords statement contacts the server to allocate new records when importing or appending new data.
- clientimportuploaddata -- The clientimportuploaddata statement contacts the server to upload and insert new records to the server when importing or appending new data.
- clipboard( -- The clipboard( function returns whatever text is currently on the computer's clipboard.
- clipboardimagesave -- The clipboardimagesave statement saves an image on the clipboard as an image file (.jpg, .png, etc.).
- clipboardimagesize( -- The clipboardimagesize( function returns the dimensions of whatever image is currently on the computer's clipboard.
- cloakeddatabasename( -- The cloakeddatabasename( function converts the regular "uncloaked" database name into the internal "mangled" name used on the server.
- cloneform -- The cloneform statement copies all of the objects in a form (optionally, with modifications) into the active form.
- cloneobjects -- The cloneobjects statement duplicates objects in a form (with modifications).
- closeactiveobject -- The closeactiveobject statement closes any object whose text is currently being edited.
- closeallasyncprogresswindows -- The closeallasyncprogresswindows statement closes any asynchronous progress windows.
- closeclonewindow -- The closeclonewindow statement is an alternative method to close the current window, works even if the window has no close box.
- closedatabase -- The closedatabase statement closes a specified database.
- closedatabaseactiveobjects -- The closedatabaseactiveobjects statement stops all text editing associated with the current database.
- closedialog -- The closedialog statement closes a form window that was previously opened with the opendialog statement.
- closedialogwindow -- The closedialogwindow statement is used internally by the rundialog statement.
- closefile -- The closefile statement closes the current database.
- closeserverfile -- The closeserverfile statement closes the current database (used on the server).
- closewindow -- The closewindow statement closes the current window.
- Cocoa Objects -- discussion of how objects are implemented in Panorama X compared to earlier versions
- Code -- basics of programming code.
- Coding with Debug Instrumentation -- modifying your code to generate debug instrumentation output.
- collapse -- The collapse statement hides the detail records associated with the currently active summary record.
- collapsetosummary -- The collapsetosummary statement collapses to the next higher summary level.
- Colors -- Using colors in Panorama formulas and procedures.
- colorwheel -- The colorwheel statement allows the user to pick a color using the operating systems standard color picker dialog
- columnstatsdialog -- The columnstatsdialog statement opens the standard Column Stats dialog.
- commalist( -- The commalist( function converts a text array (see Text Arrays) into an English list, with items separated by a comma and a space, except for the last two items which are separated by the word and and spaces.
- commastr( -- The commastr( function converts a number to text, with a comma every third digit. The number is converted as an integer, with no decimal point.
- commatocr( -- The commatocr( function converts a comma delimited array into a carriage return delimited array.
- Comments -- A comment is a note inside a program.
- commonfieldspopup -- The commonfieldspopup statement pops up a list of common fields, and changes the current field specifications when a field is chosen from this menu.
- commonpath( -- The commonpath( function returns the path for common folders (desktop, library, documents, pictures, etc.).
- comparedictprocedures -- The comparedictprocedures statement compares all the procedures from a dictionary with the procedures in a specified database.
- completedatestr( -- The completedatestr( function converts a date to text, spelling out the month and including the day of the week.
- compress -- The compress statement compresses a file or an entire folder.
- computermacid( -- The computermacid( function returns the primary MAC address for this computer.
- concatenate( -- The concatenate( function concatenates two text strings (same as the + operator).
- Confirmation Alerts -- Configuring alerts to confirm sensitive operations (deletions, etc.).
- connect( -- The connect( function appends a prefix and suffix together with a connector in between.
- connecttoserver -- The connecttoserver statement reconnects the current database to the server (after the dropserver statement has been used).
- console -- The console statement sends a message to the console log.
- constant( -- The constant( function converts an expression into a constant value (that can be plugged into a new formula).
- Constants -- values embedded into a formula.
- constantvalue( -- The constantvalue( function converts a field or variable into an equivalent constant value.
- Construct Menu -- used to automatically construct complex form applications, including calendars, lists, mailing labels, and more.
- Construct Multiple Fields -- using a template to quickly add multiple fields to a database.
- constructcalendar -- The constructcalendar statement creates the form elements for a monthly calendar.
- constructfields -- The constructfields statement creates one or more new fields based on a template.
- constructfieldssheet -- The constructfieldssheet statement opens a sheet to add/insert multiple new fields into the database.
- constructformdataeditors -- The constructformdataeditors statement creates a column of form elements for editing data fields (or variables).
- constructlineitems -- The constructlineitems statement creates a grid of line items.
- constructlistmatrix -- The constructlistmatrix statement creates a text list or matrix in the current form.
- constructmailinglabel -- The constructmailinglabel statement creates the form elements for printing mailing labels.
- constructreport -- The constructreport statement creates a report in the current form.
- constructtabpanel -- The constructtabpanel statement creates a tab panel in the current form.
- contains -- The contains operator returns true if the value on the left contains the value on the right, false if it doesn't.
- containsword -- The containsword operator returns true if the text contains a specified word, false if it doesn't.
- Control Flow -- making decisions about what code should be executed in response to changing conditions.
- Controlling and Monitoring the Server Connection -- overriding automatic server connection behavior.
- controlsound -- The controlsound statement controls playback of a sound file.
- converttimezone( -- The converttimezone( function converts a time or superdate from one time zone to another.
- convertvariablestoconstants -- The convertvariablestoconstants statement converts all of the variables in a formula into constant values.
- Coordinates -- working with points and rectangles.
- copy -- The copy statement copies the contents of the current field onto the clipboard.
- copycell -- The copycell statement copies the contents of the current field onto the clipboard, replacing anything previously on the clipboard.
- copyfile -- The copyfile statement copies a file (or folder).
- copyfolder -- The copyfolder statement copies an entire folder full of files (and subfolders, if any).
- copyindentedcode -- The copyindentedcode statement copies the selected code with 4 space indent (for pasting into the Panorama forum).
- copynewerfile( -- The copynewerfile( function copies a file to another name or location. However, the file is only copied if it is newer than the old file, otherwise the destination is not touched.
- copynewerfile -- The copynewerfile statement copies a file to another name or location. However, the file is only copied if it is newer than the old file, otherwise the destination is not touched.
- copynewerfolder -- The copynewerfolder statement copies an entire folder full of files, but only copies newer files.
- copypartialdictionary( -- The copypartialdictionary( function partially copies a dictionary (see Data Dictionaries).
- copypartialdictionary -- The copypartialdictionary statement builds a new dictionary and initializes it with values from an existing dictionary (see Data Dictionaries).
- copyrecord -- The copyrecord statement copies the contents of the current record onto the clipboard.
- cos( -- The cos( function calculates the cosine of an angle.
- cosh( -- The cosh( function calculates the hyperbolic cosine of a numeric value.
- count( -- The count( function counts all non-empty instances of a line item field in the current record.
- count -- The count statement counts all non-empty data cells for the current field.
- countsummaries( -- The countsummaries( function counts summary records.
- countsummaries -- The countsummaries statement counts summary records.
- county( -- The county( function returns the name of the county associated with a US zip code.
- cr( -- The cr( function generates a carriage return.
- Crash Proof Debug Instrumentation Monitoring -- real time crash-proof instrumentation monitoring
- createpassword -- The createpassword statement creates a random password using characters or numbers (or a mixture) set to the chosen length.
- Creating a New Database -- creating a new database.
- Creating a New Form Object -- with the Object Library.
- Creating a New Form -- creating a new empty form, or a duplicate of an existing form.
- Creating a Shared Database -- convert a single user database into a shared database.
- Credit Cards -- working with credit card numbers.
- crlf( -- The crlf( function generates a carriage return line feed.
- croptext( -- The croptext( function crops text to a specified length. If the text was already shorter than the specified length, it is left unchanged. If it is longer, the text is cut off and an ellipsis is added on the end.
- Crosstab Workshop -- tool for two dimensional summarizing, analyzing and charting large amounts of data.
- crosstab( -- The crosstab( function converts information in a database into a crosstab table (tab delimited text).
- crosstabdatabaseselectoriginal -- The crosstabdatabaseselectoriginal statement selects original data corresponding to a cell in an exported crosstab database.
- crosstabpopup -- The crosstabpopup statement handles a click on a crosstab text list.
- crosstabselectoriginalformula -- The crosstabselectoriginalformula statement returns the formula that will select the original data associated with a crosstab cell.
- crtolf( -- The crtolf( function converts carriage returns into linefeeds.
- crtovtab( -- The crtovtab( function converts carrige returns (ASCII 0x0D) into vertical tabs (ASCII 0x0B).
- Cryptography -- encrypting and decrypting data, and calculating hash values.
- csvexportline( -- The csvexportline( function generates a comma delimited line of data containing all the fields in the current record.
- csvexportlinevisiblecells( -- The csvexportlinevisiblecells( function generates a comma delimited line of data containing all the visible (non hidden) fields in the current record.
- csvquoted( -- The csvquoted( function adds quotes if necessary for CSV text (RFC 4180).
- csvtotsv( -- The csvtotsv( function converts comma separated text into tab separated text.
- Custom Database Initialization -- using an .Initialize procedure to automatically run custom code when a database opens.
- Custom Dialogs -- creating custom dialogs using forms.
- Custom Menus -- creating custom menus, menu bars and pop-up menus (and customizing standard menus).
- Custom Report Headers and Footers -- setting up custom report headers and footers.
- Custom Report Margins -- specifying the top, left, right and bottom margins of a custom report.
- Custom Statements -- creating your own custom statements that can be used in your code.
- Custom Tab Order -- Customizing the tab order in a data sheet or form.
- customdialog -- The customdialog statement customizes the appearance of the gettext and getscrap dialogs.
- Customizing Debug Instrumentation Coverage -- specifying what code is being debugged at the moment.
- custompluralpattern( -- The custompluralpattern( function converts a number to text using a pattern, making customizable adjustments for pluralization.
- customstatementdatabase( -- The customstatementdatabase( function returns the name of the library database that defines a custom statement.
- cut -- The cut statement deletes the contents of the current field, copying it onto the clipboard.
- cutcell -- The cutcell statement delete the contents of the current cell and places the deleted data on the clipboard.
- cutline -- The cutline statement copies the current record to the clipboard and deletes it.
- cutrecord -- The cutrecord statement copies the current record to the clipboard and deletes it.
- Data Arrays -- A numbered collection of data values.
- Data Button Object -- is used to create checkboxes and radio buttons.
- Data Dictionaries -- Overview of Panorama's key/value data dictionaries.
- Data Input Validation -- validation of data entry (checking for duplicates, etc.)
- Data Sheet -- a window that displays the database information in rows and columns.
- Data Types -- different types of data that can be stored in Panorama, including text, numbers and dates.
- dataarray( -- The dataarray( function creates a data array from zero or more separate values (see Data Arrays).
- dataarrayappend( -- The dataarrayappend( function appends one or more values to the end of an existing array.
- dataarraybuild( -- The dataarraybuild( function builds a data array by scanning a database and creating an array element for every record (including invisible records) in the database (see Data Arrays).
- dataarrayinsert( -- The dataarrayinsert( function inserts one or more values into the middle of an existing array.
- dataarrayselectedbuild( -- The dataarrayselectedbuild( function builds a data array by scanning a database and creating an array element for every visible record in the database (see Data Arrays).
- Database Blueprints -- exporting a database into a blueprint.
- Database Functions -- functions that access database information, including the data itself and information about the structure of the database.
- Database Integrity Checks -- checking database integrity when opening and saving.
- Database is Damaged Alert -- how to fix the "database is damaged" alert when opening a database.
- Database Navigation & Editing -- using program code to navigate within a database, and to add and remove database records.
- Database -- a single collection of records and fields.
- databaseconsoledump -- The databaseconsoledump statement dumps the raw contents of the specified database to the console in comma delimited format.
- databaseexportcsv -- The databaseexportcsv statement exports selected records in the current database in CSV format (comma separated) to a text file.
- databaseexportjson -- The databaseexportjson statement exports selected records in the current database in JSON format to a text file.
- databaseexporttsv -- The databaseexporttsv statement exports selected records in the current database in TSV format (tab separated) to a text file.
- databaseexportusingformula -- The databaseexportusingformula statement exports selected records in the current database to a text file, using a formula.
- databaseoptionsdialog -- The databaseoptionsdialog statement opens the standard Database Options dialog.
- datafocus -- The datafocus statement makes sure that Panorama is focused on data, not on a property panel.
- datamode -- The datamode statement switches a form from graphics mode into data mode.
- datatype( -- The datatype( function determines what kind of data is in a field or variable: text, number, etc.
- datavalidationalert -- The datavalidationalert statement displays an alert when invalid data has been input.
- datavalue( -- The datavalue( function returns the value of a field or variable: text, number, etc.
- Date Arithmetic Formulas -- performing calculations on dates, and converting between dates and text.
- Date Patterns -- control how dates are displayed or converted to text.
- Date Search Options -- searching dates within a database.
- date( -- The date( function converts text into a number representing a date.
- datepattern( -- The datepattern( function converts a number representing a date into text. The function uses a pattern to control how the date is formatted (see Date Patterns).
- Dates -- working with dates.
- datestr( -- The datestr( function converts a date to text using format mm/dd/yy.
- datevalue( -- The datevalue( function converts integer values for year, month and day into a number representing a date.
- daylightsavingstimeoffset( -- The daylightsavingstimeoffset( function returns the current daylight saving time offset of the specified time zone.
- dayofmonth( -- The dayofmonth( function computes the day within a month.
- dayofquarter( -- The dayofquarter( function computes the day within a quarter.
- dayofweek( -- The dayofweek( function computes the day of the week, with Sunday being 0, Monday 1, etc.
- dayofyear( -- The dayofyear( function computes the day within a quarter.
- daystr( -- The daystr( function converts a date to the day of the week (for example Sunday).
- dayvalue( -- The dayvalue( function extracts the day from a date as a numeric value.
- dbcheckopen( -- The dbcheckopen( function returns true if the specified database is currently open, false if it is not.
- dbconstructormenu( -- The dbconstructormenu( function used internally by ProVUE
- dbfolder( -- The dbfolder( function returns the folder path of the folder the current database is located in.
- dbinfo( -- The dbinfo( function gets information about a database: what forms it contains, what fields, what flash art pictures, etc.
- dbname( -- The dbname( function returns the name of the current database.
- dbpath( -- The dbpath( function returns the HFS path of the folder the current database is located in.
- dbserverdomain( -- The dbserverdomain( function returns the server domain for the database.
- dbshared( -- The dbshared( function returns true if the current database is shared, otherwise false.
- dbsubfolder( -- The dbsubfolder( function returns the path of a subfolder within the same folder as the current database.
- Debug Instrumentation Log Window -- dynamically monitor debug instrumentation output as your program runs.
- Debug Instrumentation Monitoring using an External Program -- monitoring debug instrumentation with an external program (Terminal.app, BBEdit.app).
- Debug Instrumentation Text File -- configuring and accessing the debug instrumentation log (text) file.
- Debug Instrumentation -- conditional logging of the internal state of Panorama program code.
- debug -- The debug statement stops the current program, allowing you to examine variables or single step.
- decodebase64( -- The decodebase64( function decodes data using Base64.
- decrypt( -- The decrypt( function decrypts data.
- defaultcase -- The defaultcase statement works together with the case statement to specify statements that will be executed if none of the case statements are true.
- defaulttext( -- The defaulttext( function returns a text value, or returns a default value if the text value is empty ("").
- define -- The define statement performs an assignment, much like an equals sign or the assign statement. However, the define statement only performs the assignment if the variable is currently undefined. If the variable already has a value, the define statement leaves it alone. The define statement is especially useful for initializing permanent variables.
- definehotkeys -- The definehotkeys statement defines one or more Hotkeys.
- defineservervariable -- The defineservervariable statement defines the value of a permanent variable on the server. If the variable already exists, it is not touched.
- degree -- The degree statement tells Panorama that all angles input to and calculated in trigonometric functions are in degrees rather than radians.
- degrees2radians( -- The degrees2radians( function converts an angle from degrees to radians.
- degreestoradians( -- The degreestoradians( function converts an angle from degrees into radians
- delay -- The delay statement loops for a specified period of time.
- deleteabove -- The deleteabove statement copies the current record to the clipboard and deletes it, then moves to the record above.
- deleteall -- The deleteall statement removes all records, leaving a single blank record.
- deletechildren -- The deletechildren statement deletes all the records in another database that have a value in the key field that is equal to the key value.
- deletedictionaryvalue( -- The deletedictionaryvalue( function deletes one or more key/value pairs from a dictionary (see Data Dictionaries).
- deletedictionaryvalue -- The deletedictionaryvalue statement deletes a key/value pair from a dictionary (see Data Dictionaries).
- deletefield -- The deletefield statement deletes the current field from the database.
- deleteformcustompreference -- The deleteformcustompreference statement deletes a form custom preference.
- deleteglobaldictionaryvalues -- The deleteglobaldictionaryvalues statement deletes one or more global dictionary values.
- deletehotkeys -- The deletehotkeys statement deletes the hotkeys in a specific scope.
- deleteobject -- The deleteobject statement deletes the specified object from the current form.
- deleterecchildrenwarn -- The deleterecchildrenwarn statement warns you before deleting the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- deleterecord -- The deleterecord statement deletes the currently selected record.
- deleterecordandchildren -- The deleterecordandchildren statement This deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- deleteselectedobjects -- The deleteselectedobjects statement deletes selected objects from a form.
- deletewebtemplate -- The deletewebtemplate statement deletes the web template (a dictionary) associated with a form (if any).
- Deleting All Summary Records -- when finished with summary records, they must be deleted.
- Deleting Fields -- deleting fields from the database.
- Deleting Raw Data Records -- converting summaries into data.
- Deploying Panorama in an Organization -- transferring preferences and/or account login credentials to multiple computers.
- devbuild( -- The devbuild( function always returns false in production copies of Panorama.
- Diagnosing a Formula embedded in a Form Object -- diagnosing problems with formulas embedded in form objects.
- dialdigits -- The dialdigits statement dials one or more digits.
- dialphone -- The dialphone statement dials one or more digits, adjusting for area codes, country codes, etc..
- dictionaryassignmentscode( -- The dictionaryassignmentscode( function returns code that can be used to take the values in a dictionary (see Data Dictionaries) and assign them to fields or variables based on the dictionary keys.
- dictionarydifference -- The dictionarydifference statement builds an array that lists keys of dictionary values that are different between two dictionaries (see Data Dictionaries).
- dictionaryfromarray( -- The dictionaryfromarray( function builds a new dictionary and initializes it from a two dimensional text array (see Data Dictionaries and Text Arrays).
- dictionaryfromvariables( -- The dictionaryfromvariables( function builds a new dictionary and initializes it from a list of variables (carriage return delimited).
- dictionaryvalueexists( -- The dictionaryvalueexists( function returns true or false depending on whether or not a key/value pair exists in a dictionary (see Data Dictionaries).
- dictionaryvalueexists -- The dictionaryvalueexists statement returns true or false depending on whether or not a key/value pair exists in a dictionary (see Data Dictionaries).
- Disable Editing of Individual Fields -- disable editing of inidividual database fields in the data sheet and/or forms.
- disableabort -- The disableabort statement prevents loops from being stopped early by pressing SHIFT-COMMAND-ESCAPE or by exceeding the maximum allowed loop time.
- disablefieldediting -- The disablefieldediting statement disables editing for a specified list of database fields (all others are enabled).
- disconnectedserver -- The disconnectedserver statement takes the current database offline without contacting the server.
- displaydata -- The displaydata statement will display data in a large dialog with a scroll bar.
- displayhtml -- The displayhtml statement will display a dialog containing HTML. You can control the size of the dialog, as well as several appearance options.
- Displaying Data in a Grid -- fundamentals of displaying data in a grid (Text List/Matrix).
- divzero( -- The divzero( function divides two numbers, returns zero if denominator is zero.
- divzeroerror( -- The divzeroerror( function divides two numbers, returns an error if the denominator is zero.
- dollarsandcents( -- The dollarsandcents( function converts a number to text formatted as dollars and cents.
- doubleclick( -- The doubleclick( function returns true if the mouse has been double clicked.
- downloaddatabasefromserver -- The downloaddatabasefromserver statement downloads a database file from a Panorama server.
- downloaddatafromserver -- The downloaddatafromserver statement asynchronously downloads pre-calculated binary data from a Panorama server.
- downloadpartialdatabase -- The downloadpartialdatabase statement downloads specified components of the current database from the server. The current database must be shared.
- downloadrecord -- The downloadrecord statement downloads the current record from the connected server.
- downloadrecordwithwarning -- The downloadrecordwithwarning statement downloads the current record from the connected server, with a warning if the record is currently locked.
- downrecord -- The downrecord statement moves the cursor down one visible record.
- Drag and Drop -- dragging data to and from a Panorama form.
- dragarrayorder -- The dragarrayorder statement tracks dragging of a cell within a Matrix or Text List object, then reorders the array associated with that object accordingly.
- draggraybox -- The draggraybox statement facilitates dragging something around in a form window.
- dragtext -- The dragtext statement starts drag-and-drop of text.
- dragwithinmatrix -- The dragwithinmatrix statement tracks dragging of a cell within a Matrix or Text List object.
- dropallshareddatabases -- The dropallshareddatabases statement drops the connection to all shared databases. Panorama uses this when the client is about to quit, could also be used if you know you are about to go offline.
- dropfromfinder -- The dropfromfinder statement processes any files or folders that have been dropped on a form from the finder.
- dropimagesfromfinder -- The dropimagesfromfinder statement processes images that have been dropped on a form from the Finder. The images may be added to new records in the database or put in the current record.
- dropserver -- The dropserver statement disconnects the current database from the server.
- dumpdictionary( -- The dumpdictionary( function returns a carriage return separated array of dictionary keys and values (see Data Dictionaries).
- dumpdictionary -- The dumpdictionary statement returns a carriage return separated array of dictionary keys and values (see Data Dictionaries).
- dumpdictionaryquoted( -- The dumpdictionaryquoted( function returns a carriage return separated array of dictionary keys and values (see Data Dictionaries). The text values are quoted.
- dumpdictionaryquoted -- The dumpdictionaryquoted statement returns a carriage return separated array of dictionary keys and values (see Data Dictionaries).
- dumpdictionarysource( -- The dumpdictionarysource( function returns a carriage return separated array of dictionary keys and values (see Data Dictionaries). The keys and values are quoted so that they could be used to re-assemble the dictionary with the initializedictionary( function.
- Duplicate Removal with Unpropagate -- using the unpropate command to remove duplicate data.
- duplicatefield -- The duplicatefield statement duplicates the current field.
- duplicaterecord -- The duplicaterecord statement duplicates the current record.
- Duplicating Objects -- to make copies of one or more objects.
- Edit Menu -- edit text and data, to search (and replace), and to undo and recent actions.
- editcell -- The editcell statement opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellstop -- The editcellstop statement opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellwith -- The editcellwith statement opens the edit window for the currently active field (or cell), using the supplied alternate text.
- editfavoritesdialog -- The editfavoritesdialog statement handles the Favorites button in a dialog.
- editfield -- The editfield statement begins editing of the specified field.
- editfieldname -- The editfieldname statement opens the data sheet window's field properties inspector and selects the field name.
- else -- The else statement works together with the if statement to specify statements that will be executed for both the true and false cases.
- elseif -- The elseif statement allows multiple if decisions to be chained together.
- emojicheats( -- The emojicheats( function abbreviates any emojis with "emoji cheat" codes.
- emptycell( -- The emptycell( function returns true if the specified field is empty in the current record.
- emptydatabase( -- The emptydatabase( function returns true if the current database is completely blank.
- emptyfield -- The emptyfield statement tells Panorama to move to the next available (empty) field in a series of line item fields.
- emptyfill -- The emptyfill statement fills every empty visible cell in the active field with the specified value.
- emptyline( -- The emptyline( function returns true if the entire current record (all fields) is blank, otherwise it is false.
- emptylineitemnumber( -- The emptylineitemnumber( function returns the numeric suffix of the first matching line item field that is empty (if any).
- enableabort -- The enableabort statement allows the SHIFT-COMMAND-ESCAPE key sequence to stop an endless loop.
- enclosingfolder( -- The enclosingfolder( function takes a full path and filename and returns the name of the folder that contains the file.
- enclosingpath( -- The enclosingpath( function takes a full path and filename and returns the path of the folder that contains the file.
- encodebase64( -- The encodebase64( function encodes data using Base64.
- encodehttppostdata( -- The encodehttppostdata( function converts a dictionary into HTTP post data.
- encodeurlfragment( -- The encodeurlfragment( function encodes text so that it can be used in the fragment portion of a URL (the portion after the # symbol).
- encodeurlhost( -- The encodeurlhost( function encodes text so that it can be used in the host portion of a URL (for example www.host.com).
- encodeurlpassword( -- The encodeurlpassword( function encodes text so that it can be used in the password portion of a URL.
- encodeurlpath( -- The encodeurlpath( function encodes text so that it can be used in the path portion of a URL (the portion after the host name, but before any ? symbol).
- encodeurlquery( -- The encodeurlquery( function encodes text so that it can be used in the query portion of a URL (the portion after the ? symbol).
- encodeurluser( -- The encodeurluser( function encodes text so that it can be used in the user name portion of a URL.
- encrypt( -- The encrypt( function encrypts data.
- endcase -- The endcase statement marks the end of statements controlled by a previoius case statement.
- endcatch -- The endcatch statement works with try and catch to trap errors in a sequence of statements.
- endif -- The endif statement marks the end of statements controlled by a previoius if statement.
- endloop -- The endloop statement is used at the end of a loop.
- endnoshow -- The endnoshow statement resumes the output of text and graphics after it has been disabled with the noshow statement.
- endshowlater -- The endshowlater statement resumes the immediate display of text and graphics after it has been deferred with the showlater statement.
- endswith -- The endswith operator returns true if the value on the left ends with the value on the right, false if it doesn't.
- enterprisecall -- The enterprisecall statement calls a procedure in a server database, opening and closing the database if necessary.
- Error Handling -- Techniques for trapping runtime errors instead of letting them abort the program.
- Error Wizard -- Advanced dialog for displaying program errors.
- error( -- The error( function returns an error with the specified message.
- errortext( -- The errortext( function evaluates an expression, but returns only the error message generated (if any).
- ethernetinterfaces( -- The ethernetinterfaces( function returns a dictionary containing all of the MAC addresses associated with this computer.
- eulersnumber( -- The eulersnumber( function returns the value of Euler's number.
- eurodatestr( -- The eurodatestr( function converts a date to text in European format.
- excludefromrecentmenu -- The excludefromrecentmenu statement excludes the next opened database from the Recent menu.
- execute( -- The execute( function allows a formula to execute a sequence of statements and return a result.
- execute -- The execute statement allows a procedure to call a sequence of statements within the current procedure as a "mini-subroutine".
- executeapplescript -- The executeapplescript statement compiles and runs an AppleScript.
- executeapplescriptformula -- The executeapplescriptformula statement executes an AppleScript, with embedded Panorama formulas.
- executeasap -- The executeasap statement executes the specified code at the first possible opportunity, non-atomically.
- executecatcherrors -- The executecatcherrors statement is the same as the execute statement, except for the fact that if an error occurs while running, it can be trapped by an if error statement immediately following the executecatcherrors statement.
- executelocal -- The executelocal statement is the same as the execute statement, but it shares local variables with the procedure that called it.
- executeperlscript -- The executeperlscript statement executes Perl code.
- executesudounix -- The executesudounix statement executes a UNIX shell command using sudo (root) privileges.
- executeunix -- The executeunix statement executes a UNIX shell command.
- exp( -- The exp( function raises e to a power.
- expand -- The expand statement reveals the next level of collapsed detail records associated with the currently active summary record.
- expandall -- The expandall statement reveals all collapsed detail records associated with the currently active summary record.
- expandemojis( -- The expandemojis( function expands any "emoji cheat" abbreviations into the actual emojis.
- Expanding and Collapsing the Summary Outline -- to see more or less detail.
- export -- The export statement exports the selected rows in the current database into a text file.
- exportallprocedures -- The exportallprocedures statement saves all the procedures in an editable text format.
- exportcell( -- The exportcell( function takes any database field and converts it to text, using the appropriate display pattern if one has been defined for the field.
- exportdataarray( -- The exportdataarray( function converts a data array into a text array (see Data Arrays and Text Arrays).
- exportform( -- The exportform( function exports a form and the form's meta data as a binary object that can be imported with the importform statement.
- exportjson -- The exportjson statement exports the current database in JSON format.
- exportline( -- The exportline( function generates a tab delimited line of data containing all the fields in the current record.
- exportlinenotabs( -- The exportlinenotabs( function generates a tab delimited line of data containing all the fields in the current record. Any tabs within individual fields will be removed.
- exportlinevisiblecells( -- The exportlinevisiblecells( function generates a tab delimited line of data containing all the visible (non hidden) fields in the current record.
- exportprocedure( -- The exportprocedure( function exports a procedure and the procedure's meta data as a binary object that can be imported with the importprocedure statement.
- expressionstacksize -- The expressionstacksize statement does nothing.
- expressiontype( -- The expressiontype( function determines what kind of data is generated by an expression: text, number, etc.
- extendedexpressionstack -- The extendedexpressionstack statement does nothing.
- extensiontype( -- The extensiontype( function returns the type code of the specified file (if any).
- extensiontype -- The extensiontype statement returns the type code of the specified file (if any).
- extract( -- The extract( function extracts a single data item from a text array, and can also be used to count the number of items in the array.
- extrapages( -- The extrapages( function controls the printing of extra data tile pages.
- fact( -- The fact( function computes the factorial of a value.
- false( -- The false( function returns false.
- farcall -- The farcall statement allows a procedure to call a separate procedure within a different database as a subroutine.
- farcallwithin -- The farcallwithin statement allows a procedure to call a mini-procedure within a separate procedure in a different database as a subroutine.
- Favorite Searches -- saving and recalling favorite searches.
- favoritedatabasedialog -- The favoritedatabasedialog statement opens the standard Favorite Databases dialog.
- favoritesbutton -- The favoritesbutton statement handles the Favorites button in a dialog.
- feetandframes( -- The feetandframes( function takes an integer and returns a feet and frame count for 35mm film.
- Field Blueprint Dialog -- examining and modifying the raw specification of a field.
- Field Menu -- manages fields, including adding and removing fields, setting field properties, sorting, morphing, hiding and showing.
- Field Properties Panel -- examining and modifying field attributes.
- Field Properties -- available field attributes.
- Field Width -- adjusting the width of a field in the data sheet.
- field -- The field statement tells Panorama to move to the specified field for the current record.
- fieldalignment( -- The fieldalignment( function returns the alignment of a database field.
- fieldblueprint -- The fieldblueprint statement creates blueprint code for the specified field.
- fieldblueprintsheet -- The fieldblueprintsheet statement opens a sheet to edit the blueprint of the current field.
- fieldformula( -- The fieldformula( function returns the formula associated with a database field.
- fieldname -- The fieldname statement changes the name of the current field.
- fieldnumber( -- The fieldnumber( function returns the number of a database field (starting with 1).
- fieldpattern( -- The fieldpattern( function returns the output pattern associated with a database field.
- Fields -- introduction to database fields.
- fieldstotextvariables -- The fieldstotextvariables statement copies database fields into variables.
- fieldtype -- The fieldtype statement changes the data type of the current field.
- fieldtypes( -- The fieldtypes( function returns a carriage return delimited array with a list of the fields and field data types.
- fieldtypes -- The fieldtypes statement returns a carriage return delimited array with list of fields and field data types.
- fieldvalue( -- The fieldvalue( function grabs the contents of a field in the current record of a database. You can grab data from the current database, or from another database.
- fieldwidth( -- The fieldwidth( function returns the width (in the data sheet) of a database field.
- File Menu -- create, locate, open, close and save databases, import and export text, printing.
- fileappend -- The fileappend statement appends new data to an existing disk file.
- fileattributes( -- The fileattributes( function returns attributes of the specified file or folder (date, owner, permissions, etc.).
- filebookmark( -- The filebookmark( function converts a file or folder path into a binary data value that persistently links to the file, even if it is later moved or renamed.
- filecatalog( -- The filecatalog( function builds a text array listing the files in a folder, including any subfolders of that folder.
- filecatalog -- The filecatalog statement creates a list of files in a folder, including any subfolders of that folder
- filedate( -- The filedate( function returns the modification date of a file.
- filedisplayname( -- The filedisplayname( function returns the display name for the specified file or folder.
- fileerase -- The fileerase statement erases a disk file or a folder, removing it from the hard disk.
- fileexists( -- The fileexists( function returns true if a file exists, false if it does not.
- fileexistspath( -- The fileexistspath( function tests to see if a file exists.
- fileextension( -- The fileextension( function extracts the extension (if any) from a partial or complete path and filename.
- filefolder( -- The filefolder( function returns the folder ID of the folder that contains the specified file.
- fileglobal -- The fileglobal statement creates one or more fileglobal variables.
- fileglobalvalue( -- The fileglobalvalue( function accesses a fileglobal or permanent variable from other databases.
- fileidnumber( -- The fileidnumber( function returns the id number for the specified file or folder.
- fileinfo( -- The fileinfo( function returns information about a file (or folder) on the disk, including the size, creation and modification date and time, type, creator and lock status.
- fileload( -- The fileload( function reads the entire contents of any file on disk.
- fileloadpartial( -- The fileloadpartial( function reads a portion of the contents of any file on disk.
- filemenubar -- The filemenubar statement creates a custom menu bar or context menu for the current database (see Custom Menus).
- filename( -- The filename( function extracts the filename from a complete path and filename.
- filepath( -- The filepath( function extracts the path from a combined path and filename.
- filerename -- The filerename statement renames and/or moves a file or folder.
- Files and Folders -- organization of files and folders
- filesave -- The filesave statement saves data directly into a disk file.
- filesize( -- The filesize( function determines the size of any file on disk.
- filesuperdate( -- The filesuperdate( function returns the modification date and time of a file.
- filetime( -- The filetime( function returns the modification time of a file.
- filetypecreator( -- The filetypecreator( function returns the type and creator code of the specified file (if any).
- fill -- The fill statement fills every visible cell in the active field with the specified value.
- fillall -- The fillall statement modifies the operation of the following fill statement so that all records are modified, not just visible records.
- Financial Calculations -- financial calculations based on interest rates.
- Find & Open -- searching for a database on the hard drive and opening it.
- Find & Replace Dialog -- finding and replacing a word or phrase (with an option to use a regular expression).
- Find/Select Dialog -- using a dialog to search for specific data.
- find -- The find statement locates the first visible record in the active database for which the specified condition is true.
- findabove -- The findabove statement locates the next previous record (above the current record) in the active database for which the specified condition is true.
- findbackwards -- The findbackwards statement locates the last visible record in the active database for which the specified condition is true.
- findbelow -- The findbelow statement locates the next visible record (below the current record) in the active database for which the specified condition is true.
- findid -- The findid statement locates a record in the active database by its ID number (see info("serverrecordid").
- findnth -- The findnth statement finds the nth (2nd, 3rd, 4th, etc.) record that matches a true-false test.
- findopendialog -- The findopendialog statement opens the standard Find & Open dialog.
- findrelated -- The findrelated statement finds information that matches the current record in a related database.
- findreplacedialog -- The findreplacedialog statement opens the Find & Replace dialog.
- findselect -- The findselect statement opens the standard Find/Select dialog.
- findselectdialog -- The findselectdialog statement opens the standard Find/Select dialog.
- finishtimecheck -- The finishtimecheck statement finishes a performance monitoring session.
- firstcolumn -- The firstcolumn statement moves to the first column in the data sheet (leftmost column).
- firstdayofweek( -- The firstdayofweek( function returns the user's preference for first day of the week.
- firstline( -- The firstline( function extracts the first line from the text.
- firstrecord -- The firstrecord statement makes the first visible (selected) record in the database the active record.
- firstword( -- The firstword( function extracts the first word from the text.
- fix( -- The fix( function converts a number to an integer, truncating toward zero.
- Fixed Image Object -- is used for fixed images (images that never change).
- fixed -- The fixed function converts a floating point number to fixed point.
- fixedwidth( -- The fixedwidth( function makes the text a fixed width, padding with spaces if necessary.
- fixedwidthright( -- The fixedwidthright( function makes the text a fixed width, padding on the left with spaces if necessary.
- fixsuperdates -- The fixsuperdates statement fixes Panorama 6 SuperDates in current field.
- float( -- The float( function converts a fixed point number to a floating point number.
- folder( -- The folder( function creates a Folder ID that unambiguously describes the location of a folder on the hard disk.
- foldercontains( -- The foldercontains( function checks to see if a folder contains a specified file. See also the pathcontains( function.
- foldercontents( -- The foldercontents( function returns a list of all of the contents of a folder.
- foldercount( -- The foldercount( function returns the total number of files within a folder (including any subfolders).
- folderexists( -- The folderexists( function returns true if a folder exists, false if it does not.
- folderinfo -- The folderinfo statement calculates the total size of a folder, and the number of files in the folder.
- folderpath( -- The folderpath( function converts a Folder ID into the HFS path of that folder.
- foldersepchar( -- The foldersepchar( function returns the separator character used between folders.
- foldersize( -- The foldersize( function calculates the size of a folder (in bytes).
- Font Awesome Icons -- are over 600 ready-made icons built right into Panorama.
- fontcharacters( -- The fontcharacters( function returns a string (text) containing all of the characters supported by the specified font.
- fontinfo( -- The fontinfo( function returns a dictionary with information about a specified font.
- fontinformation -- The fontinformation statement accesses information about a font (see also the fontinfo( function).
- Fonts -- setting the font and text size of form text objects.
- for -- The for statement is used at the beginning of a loop that loops a fixed number of times.
- forcelockrecord -- The forcelockrecord statement immediately locks the current record.
- forcesynchronize -- The forcesynchronize statement force synchronizes the local database with Panorama Server (downloads all records, not just recently modified ones).
- forcesynchronizeall -- The forcesynchronizeall statement force synchronizes all open databases.
- forceunlockallrecords -- The forceunlockallrecords statement immediately unlocks all records in the current database.
- forceunlockdatabaserecord -- The forceunlockdatabaserecord statement immediately unlocks an arbitrary record in the specified server database.
- forceunlockrecord -- The forceunlockrecord statement immediately unlocks the current record.
- Form Object Appearance -- changing the color, fill, stroke, opacity and drop shadow attributes of selected objects.
- Form Object Blueprint -- display and edit raw object specifications
- Form Object Code -- associating programming code with an object
- Form Properties -- specify the name of the form, and various form options.
- formatphone( -- The formatphone( function formats a US phone number using the standard *(aaa) nnn-nnnn* format.
- formblueprint -- The formblueprint statement creates blueprint code for the specified form.
- formblueprintsheet -- The formblueprintsheet statement opens a sheet to edit the blueprint of the current form.
- formcleanview -- The formcleanview statement cleans up extraneous NSView objects in the current form.
- formcolor -- The formcolor statement changes the background color of the current form.
- formconstructordialog -- The formconstructordialog statement opens a generic form constructor dialog.
- formobjectblueprint -- The formobjectblueprint statement creates blueprint code for specified form object.
- formoptionsblueprintsheet -- The formoptionsblueprintsheet statement opens a dialog sheet to edit the blueprint of the current form options.
- Forms -- display data with a customizable graphic layout.
- formtodatamode -- The formtodatamode statement switches the current form window to data mode.
- formtographicsmode -- The formtographicsmode statement switches the current form window to graphics mode.
- Formula Search -- searching with a formula.
- Formula Workshop -- formula workshop wizard for testing and experimenting with formulas.
- formulabuffer -- The formulabuffer statement does nothing.
- formulacalc -- The formulacalc statement allows you to evaluate a formula that you were not able to code into the procedure when it was being written.
- formulafields( -- The formulafields( function returns a list of fields used in a formula.
- formulafill -- The formulafill statement fills every visible cell in the active field with the result of the specified formula.
- formulafillallfields -- The formulafillallfields statement fills every visible cell in all fields with the result of the specified formula.
- formulaidentfiers( -- The formulaidentfiers( function returns a list of identifiers (fields and variables) used in a formula.
- formulamerge -- The formulamerge statement merges data into a template.
- Formulas -- basics of formulas: components and grammar.
- formulastrings( -- The formulastrings( function returns a data array of strings (text constants) used in a formula.
- formulasum -- The formulasum statement calculates a total by scanning a database, returning the accumulated sum of evaluating a formula over and over again for each scanned record.
- formulatokencount( -- The formulatokencount( function returns a count of the number of tokens in a formula.
- formulavalue( -- The formulavalue( function calculates the result of a formula based on data in the current record of any open database. This is similar to the fieldvalue( function, but allows any formula to be used, rather than just a single field.
- formulavalue -- The formulavalue statement calculates the result of a formula. Usually this is done with an assignment statement (for example `x=2 * y` ), but the formulavalue statement gives you more flexibility. You can specify what database is to be used for the calculation (an assignment statement always uses the current database) and you can specify the formula using a variable, making it easy to change on the fly. This statement also gives you more control over how errors are handled.
- formulavariables( -- The formulavariables( function returns a list of variables used in a formula.
- formxy -- The formxy statement programmatically scrolls a form to a new position.
- fullpath( -- The fullpath( function converts a filename or relative path (starting with the : or / symbol) into a full HFS path, including the disk name.
- Functions -- index of all functions available for use in Panorama formulas.
- functionvalue -- The functionvalue statement returns a value calculated by a procedure using the call(, callwithin( or execute( functions.
- fv( -- The fv( function (short for future value) calculates the future value of an investment.
- generatedataarray( -- The generatedataarray( function generates a new data array based on a formula (see Data Arrays and Text Arrays).
- Generating & Analyzing HTML -- generating HTML code from data, and extracting data from structured HTML.
- Generating Summaries Manually -- manually generating summary records in 3 steps (Group, Calculate, Outline).
- Geography -- working with geographic information, including zip codes and lat/long coordinates.
- getaddress -- The getaddress statement divides the last line of an address into separate components.
- getapplicationinfo( -- The getapplicationinfo( function retrieves the value of an item in the application's plist, or a list of all plist items.
- getautonumber( -- The getautonumber( function returns the automatically generated number for the next record that will be added to the database.
- getautonumber -- The getautonumber statement returns the automatically generated number for the next record that will be added to the database.
- getbit( -- The getbit( function returns the value of a bit within a number.
- getbutton -- The getbutton statement retrieves the coordinates of the last button that was pressed (in global screen co-ordinates).
- getcitystatezip -- The getcitystatezip statement divides the last line of an address into separate components.
- getclick -- The getclick statement returns the location of the mouse in global coordinates (coordinates from the top left corner of the screen).
- getcookie( -- The getcookie( function returns the value of a cookie submitted to the server.
- getcookielist( -- The getcookielist( function returns a list of cookies submitted to the server.
- getdictionarykey( -- The getdictionarykey( function returns the key of an item in the dictionary, given its value). This is essentially the opposite of the getdictionaryvalue( function (see Data Dictionaries).
- getdictionarykey -- The getdictionarykey statement returns the key of an item in the dictionary, given its value. This is essentially the opposite of the getdictionaryvalue( function (see Data Dictionaries).
- getdictionaryvalue( -- The getdictionaryvalue( function returns the value of an item in the dictionary, given its key (see Data Dictionaries).
- getdictionaryvalue -- The getdictionaryvalue statement returns the value of an item in the dictionary, given its key (see Data Dictionaries).
- getfieldproperties( -- The getfieldproperties( function returns a dictionary containing all of the properties of the specified field. (See the setfieldproperties statement if you want to change one or more field properties.)
- getfieldproperties -- The getfieldproperties statement returns a dictionary that contains all of the properties of the specified field.
- getformcustompreference( -- The getformcustompreference( function returns the value of a form custom preference.
- getformcustompreferencenames( -- The getformcustompreferencenames( function returns a list of custom preferences associated with a form.
- getformoption( -- The getformoption( function returns information about a form.
- getformulatext -- The getformulatext statement converts a formula into text without special quote characters.
- getglobaldictionary( -- The getglobaldictionary( function converts a global dictionary into a regular dictionary.
- getinternalbutton -- The getinternalbutton statement retrieves the coordinates of the last button that was pressed (in form relative coordinates).
- getlocalbutton -- The getlocalbutton statement retrieves the coordinates of the last button that was pressed (in window relative coordinates).
- getlocalclick -- The getlocalclick statement returns the location of the most recent mouse click in local coordinates (coordinates from the top left corner of the current form).
- getmaxwindow -- The getmaxwindow statement retrieves the position and size of the largest possible window on the main screen.
- getname -- The getname statement divides a person's full name into separate components.
- getpreferenceclass( -- The getpreferenceclass( function retrieves the class name of a preference value.
- getpreferencevalue( -- The getpreferencevalue( function retrieves the value of a preference.
- getprocedureoption( -- The getprocedureoption( function returns information about a procedure.
- getproceduretext( -- The getproceduretext( function gets the contents (source code) of a procedure.
- getproceduretext -- The getproceduretext statement gets the contents (source) of a procedure and places it in a variable.
- getscrap -- The getscrap statement will display a dialog with a text entry area. The entered text is placed in the clipboard.
- getscrapok -- The getscrapok statement will display a dialog with a text entry area. The entered text is placed in the clipboard.
- getserverlog( -- The getserverlog( function retrieves information from one or more server logs.
- getserverlog -- The getserverlog statement retrieves information from one or more server logs.
- getstructurevalue( -- The getstructurevalue( function extracts a value from a structure of nested Data Dictionaries and/or Data Arrays.
- gettaglocation -- The gettaglocation statement locates the first matching tag within some text.
- gettaglocations -- The gettaglocations statement locates all matching tags within some text.
- gettext -- The gettext statement will display a dialog with a text entry area.
- gettextdialog -- The gettextdialog statement displays a configurable modal dialog that asks the user to enter an item of text.
- gettextokcancel -- The gettextokcancel statement displays a modal dialog that asks the user to enter an item of text.
- getuploadeddata( -- The getuploadeddata( function is used in server code to access data uploaded with the UploadDataToServer statement.
- getwebcolor( -- The getwebcolor( function calculates an RGB color from a Netscape style web color.
- getwebcolor -- The getwebcolor statement will calculate an RGB color from a Netscape style web color.
- getwebtabletemplate( -- The getwebtabletemplate( function converts a web table template (created by the Text Export Wizard) into the format compatible with the HTMLDataTable statement.
- getwebtabletemplate -- The getwebtabletemplate statement converts a web table template (created by the Text Export Wizard) into the format compatible with the HTMLDataTable statement.
- getwebtemplate( -- The getwebtemplate( function retrieves the web template (a dictionary) associated with a form (if any).
- getwebtemplate -- The getwebtemplate statement retrieves the web template (a dictionary) associated with a form (if any).
- getwebtemplatetext( -- The getwebtemplatetext( function retrieves the text of the web template (a dictionary) associated with a form (if any).
- getwebtemplatetext -- The getwebtemplatetext statement retrieves the text of the web template (a dictionary) associated with a form (if any).
- getwindow -- The getwindow statement retrieves the position and size of the current window.
- giantmessage -- The giantmessage statement displays a message alert.
- Global Dictionaries -- alertnate high performance method to store multiple data items, much faster than regular data dictionaries.
- global -- The global statement creates one or more global variables.
- globaldictionarybuild -- The globaldictionarybuild statement builds a global dictionary by scanning a database.
- globaldictionarykeys( -- The globaldictionarykeys( function returns a cr()-separated array containing the keys in a global dictionary, or the names of all global dictionaries.
- globaldictionaryvalue( -- The globaldictionaryvalue( function returns the value of an item in a global dictionary, given its key (see Global Dictionaries).
- globalmenubar -- The globalmenubar statement creates a custom menu bar or context menu for all windows (intended only for internal use by ProVUE Development).
- globalvalue( -- The globalvalue( function returns the value of a global variable.
- goform -- The goform statement switches the current window to a different form.
- goto -- The goto statement allows a procedure to arbitrarily jump from one spot to another within the procedure.
- gotofielddialog -- The gotofielddialog statement opens the standard dialog for jumping to a specific field (in the Fields menu).
- grabfieldtype( -- The grabfieldtype( function returns the type of a database field in any open database.
- grabformula -- The grabformula statement evaluates a formula using data from another database.
- grabwebformitems -- The grabwebformitems statement grabs multiple web form items and stuffs the values into fields and/or variables.
- Graphics Mode -- is used to edit the graphic design of a form.
- graphicsmode -- The graphicsmode statement switches a form into graphics mode.
- gray( -- The gray( function returns a shade of gray as a Panorama color value (see Colors).
- green( -- The green( function extracts the green intensity from a color.
- groupdatepattern( -- The groupdatepattern( function converts a number representing a date into text in a special format for use with the summarytable( and crosstab( functions. The function uses a pattern to control how the date is formatted (see Date Patterns).
- groupdown -- The groupdown statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in descending order (high to low).
- Grouping Objects -- allows you to manipulate multiple objects as if they were a single object.
- groupseq( -- The groupseq( function returns the sequence number within a summary level.
- groupup -- The groupup statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in ascending order (low to high).
- growl -- The growl statement displays a notification.
- growlmessage -- The growlmessage statement displays a notification.
- h( -- The h( function extracts the horizontal position from a point (see point(, Graphic Coordinates).
- Handling Empty Selections in Code -- dealing with an empty selection data set.
- Help Menu -- contains items that will help you learn and use Panorama.
- hex( -- The hex( function converts a text item containing a hexadecimal number into a standard number (decimal).
- hexbyte( -- The hexbyte( function converts a limited range of decimal numbers to a two-digit hexadecimal number expressed as a text string.
- hexlong( -- The hexlong( function converts a decimal number to an eight-digit hexadecimal number expressed as a text string
- hexstr( -- The hexstr( function converts a number to text formatted as a hexadecimal number.
- hextobinary( -- The hextobinary( function converts a sequence of hexadecimal digits into a raw binary data value.
- hexword( -- The hexword( function converts a decimal number to a four-digit hexadecimal number expressed as a text string.
- hfspath( -- The hfspath( function converts a UNIX path into an HFS path.
- hiddenfields( -- The hiddenfields( function returns a list of hidden fields in the curent data sheet window
- hide -- The hide statement temporarily disables the output of text and graphics.
- hideaccessorypanel -- The hideaccessorypanel statement closes the current window's accessory panel.
- hidecurrentfield -- The hidecurrentfield statement hides the current field in the data sheet.
- hidefieldsbetween -- The hidefieldsbetween statement shows all fields except those in between specified numbers.
- hidelineitemfields -- The hidelineitemfields statement hides all line item fields.
- hideotherapplications -- The hideotherapplications statement hides all other applications, leaving only Panorama visible.
- hidepanorama -- The hidepanorama statement hides Panorama X, making all windows disappear.
- hidethesefields -- The hidethesefields statement hides specific fields in the data sheet, making all others visible.
- Hiding and Showing Fields -- temporarily hiding fields in the data sheet.
- homepath( -- The homepath( function returns the HFS path of a subfolder of the current users home folder.
- homesubfolder( -- The homesubfolder( function returns the folder id of a subfolder of the current user's home folder.
- hostdatabases -- The hostdatabases statement downloads a list of available databases on a Panorama X Server.
- hostdownload -- The hostdownload statement downloads a shared file to this computer, prompting the user for the location.
- hostedfiles( -- The hostedfiles( function returns a list of open databases associated with a specified host (server).
- Hotkey Workshop -- tool that assists in composing a definehotkeys statement.
- Hotkeys -- setting up user defined hotkeys.
- hsb( -- The hsb( function creates a color by combining hue, saturation, and brightness components. See Colors.
- HTML Export -- custom exports into an HTML file.
- htmlarraytable -- The htmlarraytable statement generates an HTML table from an arrray.
- htmlbold( -- The htmlbold( function takes the text and adds `` and `` tags to it.
- htmlcolor( -- The htmlcolor( function converts a color name into a hex HTML color (RRGGBB format).
- htmlcolorarray( -- The htmlcolorarray( function generates a text array of HTML colors that gradually transition from one color to another.
- htmldatamerge -- The htmldatamerge statement uses a template to generate HTML you want from a database.
- htmldatatable -- The htmldatatable statement generates an HTML table from selected data in the current database.
- htmldecode( -- The htmldecode( function converts HTML text into regular text by converting any special HTML entities (`&`, `©`, etc.) into the corresponding characters.
- htmlencode( -- The htmlencode( function converts standard text into HTML text by converting any special characters into the equivalent HTML entities.
- htmlextractimages -- The htmlextractimages statement extracts the image URLs from an HTML page.
- htmlextractlinks -- The htmlextractlinks statement extracts the links from an HTML page.
- htmlformitemnames -- The htmlformitemnames statement returns a list of form input elements (INPUT tags, etc.) within an HTML page.
- htmlitalic( -- The htmlitalic( function takes the text and adds `` and `` tags to it.
- htmlrgb( -- The htmlrgb( function converts text formatted as an HTML color into a Panorama color value (see Colors).
- htmlrgbstr( -- The htmlrgbstr( function converts a color to text formatted as an HTML color.
- htmltablecell( -- The htmltablecell( function extracts the data from a cell in an HTML table.
- htmltablecellexists( -- The htmltablecellexists( function returns true if an HTML table contains the specified cell, false if it doesn't.
- htmltablecellraw( -- The htmltablecellraw( function extracts the data from a cell in an HTML table (including tags, if any).
- htmltableheight( -- The htmltableheight( function calculates the height (number of rows) in an HTML table.
- htmltablerow( -- The htmltablerow( function extracts the data from a row in an HTML table.
- htmltablerowraw( -- The htmltablerowraw( function extracts the raw data (including tags, if any) from a row in an HTML table.
- htmltabletoarray -- The htmltabletoarray statement converts an HTML table into a text array.
- htmltablewidth( -- The htmltablewidth( function calculates the width (number of columns) in an HTML table.
- hue( -- The hue( function extracts the hue from a color.
- if -- The if statement decides what code to execute next.
- ifselect -- The ifselect statement combines the select and if info("empty") operations into a single statement.
- ignore( -- The ignore( function ignores all but the first parameter, which is passed through.
- Image Display Animations -- animated images.
- Image Display Colors and Gradients -- displaying pure colors and gradients
- Image Display Data Buttons -- checkboxes and radio buttons created from custom images.
- Image Display Object -- is used for dynamic images (images that change depending on the data).
- Image Display Push Buttons -- push buttons created from custom images.
- imagedimensions( -- The imagedimensions( function returns the dimensions (height and width) of an image file.
- imageinfo( -- The imageinfo( function returns information about an image file on disk.
- Implicitly Triggered Procedures -- Procedures that are triggered automatically when the user performs some normal Panorama action are said to be "implicitly triggered."
- Import Database -- importing another database into the current database.
- import( -- The import( function returns a line or element of imported data. This function works in conjunction with repetitive operations like importtext, arrayfilter(, characterfilter( etc.
- importcell( -- The importcell( function returns one cell of imported data.
- importdataarray( -- The importdataarray( function converts a text array into a data array (see Data Arrays and Text Arrays).
- importdatabase -- The importdatabase statement imports data from another database into the current database.
- importdatabasedialog -- The importdatabasedialog statement opens the standard Import Database dialog.
- importdictprocedures -- The importdictprocedures statement converts source code exported by the ExportAllProcedures statement into a dictionary.
- importform -- The importform statement imports a form into a database.
- Importing Binary Data from Panorama 6 -- Importing Binary Data from Panorama 6
- importjson -- The importjson statement imports a JSON array into the current database.
- importjsonline -- The importjsonline statement imports a JSON record into the current record.
- importline -- The importline statement imports a line of text into the current record.
- importprocedure -- The importprocedure statement imports a procedure into a database.
- importrawdata -- The importrawdata statement imports raw binary data into an existing database.
- importtext -- The importtext statement imports text into an existing database.
- increment -- The increment statement increments a field or variable.
- Index -- index of all help topics.
- infinity( -- The infinity( function returns infinity.
- info("accessorypanelisopen") -- The info("accessorypanelisopen") function returns the status of the current window's accessory panel, if any.
- info("accessorypanelwidth") -- The info("accessorypanelwidth") function returns the current width of the current window's accessory panel, if any.
- info("activeobject") -- The info("activeobject") function returns the name of the currently active text editor or word processor object (if any).
- info("activeobjectid") -- The info("activeobjectid") function returns the object ID of the currently active text editor or text list object, if any.
- info("activesuperobject") -- The info("activesuperobject") function returns the name of the currently active text editor or word processor object, if any.
- info("angleunits") -- The info("angleunits") function returns the current angular measurement units.
- info("applicationsfolder") -- The info("applicationsfolder") function returns the path to the current user's Applications folder.
- info("applicationsupportfolder") -- The info("applicationsupportfolder") function returns the path to the current user's Application Support folder (inside the Library folder).
- info("arraybuildstatus") -- The info("arraybuildstatus") function returns the status of the most recently executed superarraybuild statement.
- info("availablescreenrectangle") -- The info("availablescreenrectangle") function returns a rectangle defining the edges of the main screen, after deducting for the space of the menu bar and dock (if visible).
- info("bof") -- The info("bof") function returns true if the active record is currently on the first visible (selected) record.
- info("buttonrectangle") -- The info("buttonrectangle") function returns a rectangle defining the edges of the most recently clicked button.
- info("cachefolder") -- The info("cachefolder") function returns the path to the current user's Cache folder (in the Library folder).
- info("callerslocalvariables") -- The info("callerslocalvariables") function returns a list of local variables defined in the procedure that called the current procedure.
- info("canmodifydatabasedesign") -- The info("canmodifydatabasedesign") function returns true if the user has permission to modify the database design.
- info("canusestandardui") -- The info("canusestandardui") function returns true if the user has permission to use standard Panorama UI when using this database.
- info("click") -- The info("click") function returns the location of the last mouse click in screen relative coordinates.
- info("clickedobjectid") -- The info("clickedobjectid") function returns the object ID of the clicked object.
- info("clickedobjectname") -- The info("clickedobjectname") function returns the name of the button that was just clicked.
- info("clickedwindownumber") -- The info("clickedwindownumber") function returns the window number of that was just clicked.
- info("clonewindow") -- The info("clonewindow") function returns true if the current window was opened as a "clone" window.
- info("collapsible") -- The info("collapsible") function checks to see if the current record is collapsible.
- info("colornames") -- The info("colornames") function returns a list of color names that can be used as a text object background and with the htmlcolor( function.
- info("computername") -- The info("computername") function returns the name of the computer (as set up in the System Preferences Sharing panel).
- info("computerserialnumber") -- The info("computerserialnumber") function returns the computer's serial number.
- info("countrycode") -- The info("countrycode") function returns the country code for the current location.
- info("csvseparator") -- The info("csvseparator") function returns the current CSV field separator character (comma or semicolon).
- info("currencycode") -- The info("currencycode") function returns the currency code for the current location.
- info("currencysymbol") -- The info("currencysymbol") function returns the currency symbol for the current location.
- info("customfunctions") -- The info("customfunctions") function returns a list of all available custom functions.
- info("customstatements") -- The info("customstatements") function returns a list of all available custom statements.
- info("databasefilename") -- The info("databasefilename") function returns the name of the current database.
- info("databasename") -- The info("databasename") function returns the name of the current database excluding any filename extension (if any).
- info("datasheetwindownumbers") -- The info("datasheetwindownumbers") function returns the unique ID numbers of all open data sheet windows.
- info("datasheetwindows") -- The info("datasheetwindows") function returns a carriage return separated list of all open Data Sheet windows.
- info("datatype") -- The info("datatype") function returns the data type of the current field.
- info("decimalseparator") -- The info("decimalseparator") function returns the current decimal separator character (period or comma).
- info("defaultdatepattern") -- The info("defaultdatepattern") function returns the default date pattern used for displaying dates.
- info("defaultfloatformat") -- The info("defaultfloatformat") function returns the default format for converting floating point numbers to text.
- info("defaultmaxdatasheetcolumns") -- The info("defaultmaxdatasheetcolumns") function default maximum number of allowed data sheet columns.
- info("defaultvoice") -- The info("defaultvoice") function returns the current default system voice.
- info("desktopfolder") -- The info("desktopfolder") function returns the path to the user's desktop folder.
- info("dialogsheet") -- The info("dialogsheet") function returns true if the currently active window is a dialog sheet.
- info("dialogtrigger") -- The info("dialogtrigger") function returns the name of the last button pressed in a standard alert or dialog.
- info("disablebackgroundsearch") -- The info("disablebackgroundsearch") function returns true if all background searches have been disabled.
- info("disabledfields") -- The info("disabledfields") function returns a list of disabled fields in the current database (fields that cannot be edited).
- info("documentsfolder") -- The info("documentsfolder") function returns the path to the current user's Documents folder.
- info("downloadsfolder") -- The info("downloadsfolder") function returns the path to the current user's Downloads folder.
- info("dropdatabase") -- The info("dropdatabase") function returns the name of the database that contains the form data was dropped on.
- info("dropfiles") -- The info("dropfiles") function returns a list of files dragged onto a Drag Receiver form object (see Drag and Drop).
- info("dropform") -- The info("dropform") function returns the name of the form data was dropped on.
- info("dropobject") -- The info("dropobject") function returns the name of the object that data was dropped on.
- info("droptext") -- The info("droptext") function returns text dragged onto a Drag Receiver form object (see Drag and Drop).
- info("droptypes") -- The info("droptypes") function returns a list of all the data types dragged onto a Drag Receiver form object (see Drag and Drop).
- info("dropvcard") -- The info("dropvcard") function returns the text of any VCards dragged onto a Drag Receiver form object (see Drag and Drop).
- info("dropwindow") -- The info("dropwindow") function returns the name of the window that contains the form data was dropped on.
- info("dropwindownumber") -- The info("dropwindownumber") function returns the number of the window that contains the form data was dropped on.
- info("empty") -- The info("empty") function returns true or false depending on the result of the last select operation. If no records were selected the function will return true, otherwise it will return false.
- info("enabledfields") -- The info("enabledfields") function returns a list of enabled fields in the current database (fields that can be edited).
- info("eof") -- The info("eof") function returns true if the active record is currently the last visible (selected) record.
- info("error") -- The info("error") function returns the most recent error message.
- info("errorparameter") -- The info("errorparameter") function returns the parameter that caused a runtime error.
- info("errorstack") -- The info("errorstack") function returns the contents of the procedure stack after an error.
- info("errorstatement") -- The info("errorstatement") function returns the name of the statement that Panorama was trying to run at the time an error occurred.
- info("eventtype") -- The info("eventtype") function returns the type of the last event (mouse click, keyboard press, etc.).
- info("executeerrorsource") -- The info("executeerrorsource") function can be used in Error Handling code when an error occurs in code running via the execute statement or its siblings.
- info("expandable") -- The info("expandable") function checks to see if the current record is expandable.
- info("expressionstacksize") -- The info("expressionstacksize") function returns the fake size of expression stack.
- info("fieldcount") -- The info("fieldcount") function returns the number of fields in the current database.
- info("fieldname") -- The info("fieldname") function returns the name of the current field.
- info("fieldnumber") -- The info("fieldnumber") function returns the number of the current field (starting from 1).
- info("fields") -- The info("fields") function returns a carriage return delimited list of fields in the current database.
- info("files") -- The info("files") function returns a list of all open database files.
- info("filesystemmonitors") -- The info("filesystemmonitors") function lists the active file system monitors.
- info("filevariables") -- The info("filevariables") function builds a carriage return separated text array containing a list of the currently allocated fileglobal variables in the current database.
- info("focusobject") -- The info("focusobject") function returns the name of the currently active text editor or word processor object, if any.
- info("focusobjectid") -- The info("focusobjectid") function returns the object ID of the currently active text editor or text list object, if any.
- info("foldersepchar") -- The info("foldersepchar") function returns the separator character used between folders.
- info("fonts") -- The info("fonts") function returns a list of all fonts installed on this computer.
- info("formcolor") -- The info("formcolor") function returns the background color of the current form.
- info("formevent") -- The info("formevent") function returns the last event that occurred to the current form.
- info("formname") -- The info("formname") function returns the name of the current form.
- info("formobjectcommonproperties") -- The info("formobjectcommonproperties") function returns a list of properties that are common to all types of form objects.
- info("formulabuffer") -- The info("formulabuffer") function returns the fake size of the formula buffer.
- info("formulamemory") -- The info("formulamemory") function function returns the fake size of the formula memory.
- info("formwindownumbers") -- The info("formwindownumbers") function returns the unique ID numbers of all open form windows.
- info("formwindows") -- The info("formwindows") function returns a carriage return separated list of all open form windows.
- info("formxy") -- The info("formxy") function returns a point that indicates how much the current form is scrolled (if at all).
- info("found") -- The info("found") function returns true or false depending on whether the last find or next statement was successful.
- info("globalvariables") -- The info("globalvariables") function builds a carriage return separated text array containing a list of the currently allocated global variables.
- info("guid") -- The info("guid") function returns a unique identifier string.
- info("hiddenfields") -- The info("hiddenfields") function returns a carriage return delimited list of fields that are currently hidden in the current data sheet.
- info("horizontalscrollbar") -- The info("horizontalscrollbar") function returns true if the current window's horizontal scrollbar is enabled, false if it is disabled.
- info("httpheaders") -- The info("httpheaders") function returns a dictionary with information about a just completed HTTP download.
- info("httprequestinprogress") -- The info("httprequestinprogress") function returns true if this code is running on Panorama X Server, and the server is responding to a web client request.
- info("javascriptvalue") -- The info("javascriptvalue") function returns the value passed from JavaScript code in a web browser object.
- info("keyboard") -- The info("keyboard") function returns the last key that was pressed.
- info("keycode") -- The info("keycode") function returns a special numeric code that represents the last key that was pressed.
- info("labels") -- The info("labels") function lists the labels in the current procedure.
- info("languagecode") -- The info("languagecode") function returns the language code for the current location.
- info("libraryfolder") -- The info("libraryfolder") function returns the path to the current user's Library folder.
- info("localhostname") -- The info("localhostname") function returns the computer's local host name.
- info("localtimezone") -- The info("localtimezone") function returns the local time zone for the current location of your computer.
- info("localvariables") -- The info("localvariables") function builds a carriage return separated text array containing a list of the currently allocated local variables.
- info("loggedinaccountemail") -- The info("loggedinaccountemail") function returns the currently logged in account ID (email address).
- info("loggedinaccountrole") -- The info("loggedinaccountrole") function returns the currently logged in account role.
- info("magicwindow") -- The info("magicwindow") function returns the name of the currently designated "magic window," if any.
- info("magnification") -- The info("magnification") function returns the current magnification of the current form.
- info("matrixcell") -- The info("matrixcell") function returns the current cell number within a matrix object.
- info("matrixcelldata") -- The info("matrixcelldata") function returns the data associated with the current matrix object cell.
- info("matrixcellrecordid") -- The info("matrixcellrecordid") function returns the record id of the cell in a matrix that was clicked on.
- info("matrixcellselected") -- The info("matrixcellselected") function returns the selection status of the current matrix object cell.
- info("matrixclickedframe") -- The info("matrixclickedframe") function identifies which section of a matrix was clicked on.
- info("matrixclickedframeform") -- The info("matrixclickedframeform") function returns the form that contains the matrix frame, or `""` if the current form contains the frame.
- info("matrixclickedobject") -- The info("matrixclickedobject") function identifies which named object in a matrix was clicked on (if any).
- info("matrixclickedobjectid") -- The info("matrixclickedobjectid") function returns the object id of the object in a matrix that was clicked on (or zero if none).
- info("matrixclickinfo") -- The info("matrixclickinfo") function identifies what section and what named object was clicked on in a matrix.
- info("matrixcolumn") -- The info("matrixcolumn") function returns the current column number within a matrix object.
- info("matrixdata") -- The info("matrixdata") function returns the data associated with the current matrix object.
- info("matrixname") -- The info("matrixname") function returns the name of the matrix object being drawn, if any.
- info("matrixrow") -- The info("matrixrow") function returns the current row number within a matrix object.
- info("matrixseparator") -- The info("matrixseparator") function function returns the separator associated with the current matrix.
- info("measurementsystem") -- The info("measurementsystem") function returns the measurement system for the current location.
- info("menuidentifier") -- The info("menuidentifier") function returns the identifier of the most recently chosen menu item (if any).
- info("milliseconds") -- The info("milliseconds") function returns the number of milliseconds (1/1000th second) since the system started up.
- info("modaldialogopen") -- The info("modaldialogopen") function returns true if a modal dialog window is currently open.
- info("modifiedfield") -- The info("modifiedfield") function returns the name of the field that was just modified.
- info("modifiers") -- The info("modifiers") function returns the status of the modifier keys.
- info("mouse") -- The info("mouse") function returns the current location of the mouse in screen relative coordinates.
- info("mousedown") -- The info("mousedown") function returns true or false depending on whether the mouse is currently down.
- info("moviesfolder") -- The info("moviesfolder") function returns the path to the current user's Movies folder.
- info("musicfolder") -- The info("musicfolder") function returns the path to the current user's Music folder.
- info("noshow") -- The info("noshow") function returns true if noshow is currently turned on, false if it is not.
- info("notification") -- The info("notification") function returns information about the just clicked notification.
- info("osversion") -- The info("osversion") function returns the operating system version and build number.
- info("pagecount") -- The info("pagecount") function calculates the total number of pages that will be printed.
- info("pagenumber") -- The info("pagenumber") function returns the current report page number.
- info("pagesetuporientation") -- The info("pagesetuporientation") function returns the printing page orientation for the current database.
- info("pagesetuppaperheight") -- The info("pagesetuppaperheight") function returns the printing paper height for the current database.
- info("pagesetuppaperwidth") -- The info("pagesetuppaperwidth") function returns the printing paper width for the current database.
- info("pagesetupscale") -- The info("pagesetupscale") function returns the printing scale factor for the current database.
- info("panoramabuild") -- The info("panoramabuild") function returns the date and time when Panorama was compiled (as a SuperDate).
- info("panoramabundleversion") -- The info("panoramabundleversion") function returns the bundle version of Panorama.
- info("panoramafolder") -- The info("panoramafolder") function returns the location of the folder containing the currently running copy of Panorama.
- info("panoramaisactive") -- The info("panoramaisactive") function returns true if Panorama is the frontmost application (in other words, if the Panorama menu bar is visible).
- info("panoramaname") -- The info("panoramaname") function returns the name of the currently running copy of Panorama.
- info("panoramauptime") -- The info("panoramauptime") function returns the number of seconds since Panorama launched.
- info("panoramaversion") -- The info("panoramaversion") function returns the version number of Panorama.
- info("parameters") -- The info("parameters") function returns the number of parameters passed to a subroutine.
- info("picturesfolder") -- The info("picturesfolder") function returns the path to the current user's Pictures folder.
- info("posixtasks") -- The info("posixtasks") function list of POSIX shell tasks running in the background.
- info("preferencedomains") -- The info("preferencedomains") function returns a carriage return delimited list of available preferences domains.
- info("preferences") -- The info("preferences") function returns a list of all currently active preference settings.
- info("printer") -- The info("printer") function returns the current default printer.
- info("printers") -- The info("printers") function returns a list of all available printers.
- info("printsequence") -- The info("printsequence") function returns the record sequence number of the record being printed.
- info("proceduredatabase") -- The info("proceduredatabase") function returns the name of the database that contains the currently running procedure.
- info("procedurelibraries") -- The info("procedurelibraries") function returns a carriage return separated array listing all of the custom statement libraries that are currently installed.
- info("procedurename") -- The info("procedurename") function returns the name of the currently running procedure.
- info("procedureselectedtext") -- The info("procedureselectedtext") function returns the selected source code in the current procedure window.
- info("procedureselectionend") -- The info("procedureselectionend") function returns the ending position of the selected source code in the current procedure window.
- info("procedureselectionlength") -- The info("procedureselectionlength") function returns the length of the selected source code in the current procedure window.
- info("procedureselectionstart") -- The info("procedureselectionstart") function returns the starting position of the selected source code in the current procedure window.
- info("procedurestack") -- The info("procedurestack") function returns the contents of Panorama's procedure call stack.
- info("proceduretext") -- The info("proceduretext") function returns the source code in the current procedure window.
- info("procedurewindownumbers") -- The info("procedurewindownumbers") function returns the unique ID numbers of all open procedure windows.
- info("procedurewindows") -- The info("procedurewindows") function returns a carriage return separated list of all open procedure windows.
- info("processidentifier") -- The info("processidentifier") function returns the process id number that Panorama is running under.
- info("processname") -- The info("processname") function returns the process name that Panorama is running under.
- info("publicfolder") -- The info("publicfolder") function returns the path to the current user's Public folder.
- info("quitinprogress") -- The info("quitinprogress") function returns true if Panorama is in the process of quitting.
- info("ram") -- The info("ram") function returns the amount of physical RAM in this computer.
- info("rawdatabasedata") -- The info("rawdatabasedata") function returns the binary data of the current database.
- info("rawrecord") -- The info("rawrecord") function returns the binary data of the current record.
- info("rawrecordid") -- The info("rawrecordid") function returns a number that represents the location of the current record within the database.
- info("records") -- The info("records") function returns the total number of records in the current database.
- info("runningatomic") -- The info("runningatomic") function returns true if the current procedure is running as an "atomic" procedure.
- info("runninghandler") -- The info("runninghandler") function returns true if the current procedure is running as a "handler" procedure.
- info("runningonserver") -- The info("runningonserver") function returns true if code is running on Panorama X Server, false if running on client.
- info("runningunderterminal") -- The info("runningunderterminal") function returns the name of the terminal program if Panorama was launched under one, otherwise it returns empty text.
- info("screenrectangle") -- The info("screenrectangle") function returns a rectangle defining the edges of the main screen.
- info("scrollpoint") -- The info("scrollpoint") function returns the distance the current form is scrolled horizontally and vertically.
- info("searchformula") -- The info("searchformula") function returns the most recent search formula used in a find statement, if any.
- info("selectduplicatesortwarning") -- The info("selectduplicatesortwarning") function works with the selectduplicatesnowarning statement to ascertain whether or not the database was sorted correctly when last search for duplicates was performed.
- info("selected") -- The info("selected") function returns the number of selected records in the current database.
- info("serverconnection") -- The info("serverconnection") function returns true if the currently active database successfully connected to the server when it opened.
- info("serverconnectionstatus") -- The info("serverconnectionstatus") function returns the status of the connection between this database and the server.
- info("serverrecordid") -- The info("serverrecordid") function returns the unique ID number for the current record.
- info("serverrecordts") -- The info("serverrecordts") function returns the internal time stamp associated with the current record.
- info("serverupdate") -- The info("serverupdate") function returns true if the server update option is currently turned on (this is the default).
- info("showlater") -- The info("showlater") function determines whether or not Panorama is currently deferring display.
- info("sounds") -- The info("sounds") function returns a carriage return delimited list of all currently playing sounds.
- info("speaking") -- The info("speaking") function returns true if talking is occuring right now.
- info("speechrate") -- The info("speechrate") function returns the current Panorama speech rate (words per minute).
- info("speechvoice") -- The info("speechvoice") function returns the current default system voice.
- info("speechvolume") -- The info("speechvolume") function returns the current Panorama speech volume.
- info("stopped") -- The info("stopped") function returns true or false depending on the whether the last uprecord, downrecord, left or right statement succeeded or failed.
- info("summary") -- The info("summary") function returns the summary level of the current record, from 0 (data record) to 7.
- info("taperecorder") -- The info("taperecorder") function returns information about the current procedure recording (if any).
- info("tempfolder") -- The info("tempfolder") function returns the path to the current user's temporary folder (for files you plan to use only for a short time).
- info("texteditortrigger") -- The info("texteditortrigger") function returns the reason why a Text Editor object triggered a procedure.
- info("thousandsseparator") -- The info("thousandsseparator") function returns the current thousands separator character (period or comma).
- info("tickcount") -- The info("tickcount") function returns the number of ticks (1/60th second) since the system started up.
- info("timelimitremaining") -- The info("timelimitremaining") function returns the amount of time available (in seconds) before a loop will time out.
- info("timerinfo") -- The info("timerinfo") function returns a dictionary that contains all of the properties of the currently running timer.
- info("timers") -- The info("timers") function returns a carriage return separated list of all active timers.
- info("timezoneabbreviations") -- The info("timezoneabbreviations") function returns a dictionary of time zone abbreviations supported by the system.
- info("timezones") -- The info("timezones") function returns a list of time zone regions recognized by the system.
- info("toolbar") -- The info("toolbar") function returns true if the current window's toolbar is visible, false if it is hidden.
- info("toolbarvisible") -- The info("toolbarvisible") function returns true if the current window has a visible tool bar.
- info("trigger") -- The info("trigger") function returns information about how the current procedure was triggered.
- info("typeofwindow") -- The info("typeofwindow") function determines what type of view the current window contains.
- info("unixgroupid") -- The info("unixgroupid") function returns the UNIX group ID of the current user.
- info("unixuserid") -- The info("unixuserid") function returns the UNIX user ID of the current user.
- info("unixusername") -- The info("unixusername") function returns the short user name of the logged in user.
- info("unsharedrecordid") -- The info("unsharedrecordid") function returns the minimum ID for unshared records.
- info("uptime") -- The info("uptime") function returns the number of seconds since the computer was last booted.
- info("urltaskinfo") -- The info("urltaskinfo") function returns information about a just completed HTTP download.
- info("user") -- The info("user") function returns the name of the user of this computer.
- info("userfolder") -- The info("userfolder") function returns the path to the current user's home folder.
- info("verticalscrollbar") -- The info("verticalscrollbar") function returns true if the current window's vertical scrollbar is enabled, false if it is disabled.
- info("visible") -- The info("visible") function returns true if the current record is visible and false if it is invisible.
- info("visiblefields") -- The info("visiblefields") function returns a carriage return delimited list of fields that are currently visible in the current data sheet.
- info("voices") -- The info("voices") function returns a list of available speech synthesis voices on this system.
- info("volumes") -- The info("volumes") function returns a list of all of the currently mounted volumes (disks) on the computer.
- info("webbrowserlinklabel") -- The info("webbrowserlinklabel") function returns the url of the link right clicked in a Web Browser object.
- info("webbrowserlinkurl") -- The info("webbrowserlinkurl") function returns the url of the link right clicked in a Web Browser object.
- info("webclientsessioninprogress") -- The info("webclientsessioninprogress") function returns true if this code is running on Panorama X Server, and the server is responding to a web client request.
- info("windowdepth") -- The info("windowdepth") function returns the color depth of the current window.
- info("windowname") -- The info("windowname") function returns the name of the current window.
- info("windownumber") -- The info("windownumber") function returns the unique ID number of the current window.
- info("windownumbers") -- The info("windownumbers") function returns the unique ID numbers of all open windows.
- info("windowoptions") -- The info("windowoptions") function returns the names of any currently enabled window options,
- info("windowrectangle") -- The info("windowrectangle") function returns a rectangle defining the edges of the current window. The rectangle is in screen relative coordinates.
- info("windows") -- The info("windows") function builds a carriage return separated text array containing a list of all the currently open windows.
- info("windowtype") -- The info("windowtype") function returns a numeric value based on what type of view the current window contains.
- info("windowvariables") -- The info("windowvariables") function returns a carriage return separated text array listing the windowglobal variables defined for the current window.
- info("windowview") -- The info("windowview") function determines what type of view the current window contains.
- info( -- The info( function returns miscellaneous bits of information about the system, the current database, the current window, etc.
- initializedictionary( -- The initializedictionary( function builds a new dictionary and initializes it with zero or more key/value entries (see Data Dictionaries).
- initializedictionary -- The initializedictionary statement builds a new dictionary and initializes it with one or more key/value entries (see Data Dictionaries).
- initializedictionaryvalue( -- The initializedictionaryvalue( function builds a new dictionary and initializes it with one or more entries (see Data Dictionaries). This function is deprecated, we recommend using the initializedictionary( function instead.
- inrectangle( -- The inrectangle( function checks to see if a point is inside a rectangle.
- insertbelow -- The insertbelow statement inserts a new record below the current record.
- insertbelowcarriagereturn -- The insertbelowcarriagereturn statement inserts a new record below the current record and moves to the first column.
- insertfield -- The insertfield statement inserts a new field into the database in front of the current field.
- insertnewproceduremark -- The insertnewproceduremark statement inserts a new mark into the current procedure.
- insertrecord -- The insertrecord statement inserts a new record above the current record.
- Installing and Launching Panorama Server -- instructions for getting Panorama Server up and running, as well as best practices for configuring system settings on a server computer.
- installpanoramacgi -- The installpanoramacgi statement installs Panoramax.cgi for use with external web server.
- int( -- The int( function converts a number to an integer, truncating toward negative infinity.
- integralpoint( -- The integralpoint( function converts point coordinates to integers.
- integralrectangle( -- The integralrectangle( function converts rectangle coordinates to integers.
- Internet Access -- accessing information from web servers.
- intersectionrectangle( -- The intersectionrectangle( function creates a rectangle by combining two rectangles. The new rectangle is the area where the two rectangles overlap (if any).
- Introduction to Panorama X Team Server -- using a server extends the reach of Panorama beyond a single computer to a network of connected computers, or even across the entire Internet. This topic introduces the concepts needed to understand the operation of the Panorama X Team Server system, including multi-user database sharing and database web publishing.
- ipaddress -- The ipaddress statement returns the current IP address of the computer, or "" if not connected.
- javascriptconstant( -- The javascriptconstant( function converts an expression into a JavaScript literal.
- javascriptstring( -- The javascriptstring( function converts a text string into a JavaScript string
- Join Databases -- joining another database into the current database (relational join).
- join -- The join statement joins data from another database into the current database.
- joindialog -- The joindialog statement opens the standard Join Database dialog.
- joinonerecord -- The joinonerecord statement joins matching data from another database into the current record.
- jsonexport( -- The jsonexport( function converts a Panorama dictionary or data array into JSON.
- jsonexportline( -- The jsonexportline( function exports the current database record in JSON format.
- jsonimport( -- The jsonimport( function converts JSON into a Panorama dictionary or data array.
- jsonscriptstring( -- The jsonscriptstring( function converts text into a JSON string literal
- kcadd( -- The kcadd( function takes a keycode for 35mm film and adds a number of frames to it and returns a keycode as a string.
- kcdiff( -- The kcdiff( function calculates the number of frames between two frames of 35mm film, using inclusive counts (submitted by chris watts)
- kcframes( -- The kcframes( function returns an integer based on a feet and frames count for 35mm film.
- kcoutfromlength( -- The kcoutfromlength( function answers the question "what will the last frame be if i start my cut at the incode and my shot is some number of frames long"?
- labelize( -- The labelize( function returns the value of a field or variable along with a label. This saves typing when you need to display fields or variables when logging and debugging.
- labelizeformula( -- The labelizeformula( function returns the value of a formula along with the formula itself as a label.
- labelizeinfo( -- The labelizeinfo( function returns the value of an info( function, along with the function itself as a label.
- labelizepattern( -- The labelizepattern( function formats a text value using a label and a pattern.
- lastcolumn -- The lastcolumn statement move to the last column in the data sheet (rightmost column).
- lastline( -- The lastline( function extracts the last line from the text.
- lastlookupdatabase( -- The lastlookupdatabase( function returns the name of the database referenced in the most recent lookup.
- lastrecord -- The lastrecord statement makes the last visible (selected) record in the database the active record.
- lastword( -- The lastword( function extracts the last word from the text.
- latlongdistance( -- The latlongdistance( function calculates the distance between two points on the earth (or any other sphere).
- launch -- The launch statement launches an application.
- left( -- The left( function extracts characters from the left edge of the text.
- left -- The left statement makes the previous field active in the active window.
- length( -- The length( function counts the number of characters in a text value (also called a string).
- let -- The let statement creates a local variable and assigns a value to it.
- letfileglobal -- The letfileglobal statement creates a fileglobal variable and assigns a value to it.
- letglobal -- The letglobal statement creates a global variable and assigns a value to it.
- letpermanent -- The letpermanent statement creates a permanent variable and assigns a value to it.
- letservervariable -- The letservervariable statement creates a server variable and assigns a value to it.
- letwindowglobal -- The letwindowglobal statement creates a windowglobal variable and assigns a value to it.
- lf( -- The lf( function generates a line feed.
- lftocr( -- The lftocr( function converts linefeeds into carriage returns.
- like -- The like operator checks to see if the text on the left matches the wildcard pattern specified on the right.
- limit( -- The limit( function checks to see if a value is between a minimum and maximum value. If it is, the value is returned unchanged. If it is below the minimum, the minimum value is returned. If it is above the maximum the maximum value is returned.
- Limiting the Maximum Number of Data Sheet Columns -- adjusting the maximum number of columns displayed in data sheet windows.
- Line Item Fields -- are used for repeating items within a record
- Line Item Grid Constructor -- creates a grid of form elements for displaying and editing line item fields.
- Line Object -- draws a line within a form.
- linecount( -- The linecount( function counts the number of carriage return separated lines in the text.
- lineitemarray( -- The lineitemarray( function converts the data in a set of line item fields into a text array (see Text Arrays).
- linescontain( -- The linescontain( function checks to see if any line in a carriage return separated array matches the specified value.
- linesnotcontain( -- The linesnotcontain( function is the reverse of the linescontain( function.
- linesort( -- The linesort( function sorts lines of text in ascending order.
- linestrip( -- The linestrip( function removes any blank lines from the text.
- Linking with Another Database -- techniques for relating multiple database files so that they work together.
- listchoices( -- The listchoices( function builds a text array containing a list of all the values stored in a specified field.
- listdictionarykeys( -- The listdictionarykeys( function returns a list of the keys in a dictionary collection.
- listdictionarynames -- The listdictionarynames statement returns a list of the names (keys) in a dictionary (see Data Dictionaries).
- listfiles( -- The listfiles( function builds a text array listing the files in a folder.
- listpanoramafiles( -- The listpanoramafiles( function returns a list of panorama database files in the specified folder.
- listtextfiles( -- The listtextfiles( function returns a list of text files in the specified folder.
- listwebtables( -- The listwebtables( function returns the list of web tables (generated by the Text Export wizard) in the specified database.
- listwebtables -- The listwebtables statement generates a list of web tables (generated by the Text Export wizard) in the specified database.
- listwebtemplates( -- The listwebtemplates( function retrieves a list of web templates in the specified database, if any.
- listwebtemplates -- The listwebtemplates statement retrieves a list of web templates in the specified database, if any.
- listwindownumbers( -- The listwindownumbers( function builds a text array containing a list of window ID numbers for all the open windows associated with a particular file.
- listwindows( -- The listwindows( function builds a text array containing a list of all the open windows associated with a particular file.
- littleendian( -- The littleendian( function returns true if Panorama is running on a "little endian" processor.
- littleendianbinaryvalue( -- The littleendianbinaryvalue( function converts little endian binary data (a byte, word, longword, or longlongword) into an unsigned number (see Binary Data).
- littleendianbinaryvalue( -- The littleendianbinaryvalue( function converts little endian binary data (a byte, word, or longword) into an unsigned number (see Binary Data).
- LMSL -- is the specification language for Live Menus.
- loadallprocedures -- The loadallprocedures statement loads all the procedures from a dictionary into the current database. If a procedure doesn't exist it will be created.
- loadcustomfunctions -- The loadcustomfunctions statement reloads all ProVUE defined custom functions.
- loadlibrary -- The loadlibrary statement loads a library database into memory.
- loadurl( -- The loadurl( function loads a resource from the internet.
- loadurl -- The loadurl statement loads a resource from the internet.
- local -- The local statement creates one or more local variables.
- localpanoramaxserverisrunning( -- The localpanoramaxserverisrunning( function returns true if Panorama X Server is currently running on this computer, false if it is not running.
- localpanoramaxservername( -- The localpanoramaxservername( function returns the name of the Panorama X server on the local computer, if any.
- localpanoramaxservers( -- The localpanoramaxservers( function returns the names of all Panorama X servers that are running on the local network.
- localparameters -- The localparameters statement creates one or more local variables and assigns parameter values to them.
- localvalue( -- The localvalue( function returns the value of a local variable.
- lockcurrentrecord( -- The lockcurrentrecord( function attempts to lock the current record, returns true if successful, false if failed.
- lockedrecordlist -- The lockedrecordlist statement returns a list of records locked in the current database.
- lockorstop -- The lockorstop statement attempts to lock the current record. If the record is currently locked by another user, the procedure stops with an error
- lockrecord -- The lockrecord statement attempts to lock the current record, and waits if it is currently locked by another user.
- log( -- The log( function computes the natural logarithm (base e ) of a value.
- log10( -- The log10( function computes the common logarithm (base 10) of a value.
- Logging Server Activity -- recording server activities for later analysis.
- longdatestr( -- The longdatestr( function converts a date to text by spelling out the month.
- longlongword( -- The longlongword( function converts a number into a 64 bit longword (8 bytes) of binary data (see Binary Data).
- longlongwordarray( -- The longlongwordarray( function extracts a value from an array of 64 bit longlongwords (see [Binary Data]).
- longtimestr( -- The longtimestr( function converts a number to text in am/pm time format, including seconds.
- longword( -- The longword( function converts a number into a 32 bit longword (4 bytes) of binary data (see Binary Data).
- longwordarray( -- The longwordarray( function extracts a value from an array of 32 bit longwords (see [Binary Data]).
- Looking up Data Directly from the Server -- local in-memory vs. server lookups.
- lookup( -- The lookup( function searches a database for a value, then returns other information from the same record. For example, the lookup( function can look up a phone number given a customer name, or look up a price given a part number.
- lookupall( -- The lookupall( function builds a text array containing one item for every record in the target database where the data in the keyField matches the keyData. Each item in the text array contains the value extracted from the dataField for that record. If the data field is a numeric or date field, it is converted to text using the default patterns for that field.
- lookupalldouble( -- The lookupalldouble( function is similar to the lookupall( function, but it returns two fields from the target database instead of just one.
- lookupalloctet( -- The lookupalloctet( function is similar to the lookupall( function, but it returns eight fields from the target database instead of just one.
- lookupallquadruple( -- The lookupallquadruple( function is similar to the lookupall( function, but it returns four fields from the target database instead of just one.
- lookupallquintuplet( -- The lookupallquintuplet( function is similar to the lookupall( function, but it returns five fields from the target database instead of just one.
- lookupallseptuplet( -- The lookupallseptuplet( function is similar to the lookupall( function, but it returns seven fields from the target database instead of just one.
- lookupallsextet( -- The lookupallsextet( function is similar to the lookupall( function, but it returns six fields from the target database instead of just one.
- lookupalltriple( -- The lookupalltriple( function is similar to the lookupall( function, but it returns three fields from the target database instead of just one.
- lookuplast( -- The lookuplast( function searches the selected records in a database for a value, then returns other information from the same record. For example, the lookuplast( function can look up a phone number given a customer name, or look up a price given a part number. Unlike the lookup( function which searches from the top of the database, the lookuplast( function searches backwards from the bottom.
- lookuplastselected( -- The lookuplastselected( function searches the selected records in a database for a value, then returns other information from the same record. For example, the lookuplastselected( function can look up a phone number given a customer name, or look up a price given a part number. Unlike the lookupselected( function which searches from the top of the database, the lookuplastselected( function searches backwards from the bottom.
- lookupmoredata( -- The lookupmoredata( function looks up an additional data field based on the previous lookup.
- lookupmoreformula( -- The lookupmoreformula( function looks up additional data based on a previous lookup.
- lookupselected( -- The lookupselected( function searches the selected records in a database for a value, then returns other information from the same record. For example, the lookupselected( function can look up a phone number given a customer name, or look up a price given a part number.
- loop -- The loop statement is used at the beginning of a loop.
- looparray -- The looparray statement is used at the beginning of a loop that loops over the elements of an array.
- loopdataarray -- The loopdataarray statement is used at the beginning of a loop that loops over the elements of a data array.
- loopindex -- The loopindex statement allows a procedure to determine how many times a loop has been repeated.
- loopwhile -- The loopwhile statement is used at the beginning of a loop.
- loremipsum( -- The loremipsum( function creates one or more paragraph blocks of "lorem ipsum" dummy text.
- lower( -- The lower( function converts text to lower case.
- macoscomputername -- The macoscomputername statement returns the name of this computer.
- mactoutf8( -- The mactoutf8( function translates text from Panorama format to UTF8 (Unicode).
- mactoutf8 -- The mactoutf8 statement translates text from Panorama format to UTF8 (Unicode).
- magicformwindow -- The magicformwindow statement designates an open window as the temporary active window for the purposes of info( functions and graphic statements.
- magicwindow -- The magicwindow statement designates an open window as the temporary active window for the purposes of info( functions and graphic statements.
- magnification -- The magnification statement changes the magnification of a form.
- makeabsolutepath -- The makeabsolutepath statement converts a relative path (relative to the current database) to an absolute path.
- makefileglobals -- The makefileglobals statement creates one or more fileglobal variables, and assigns a value to each new variable.
- makefilesecret -- The makefilesecret statement closes all of the windows associated with a file, but keeps the file open in memory.
- makefolder -- The makefolder statement creates a new folder, and if necessary, also creates any enclosing folders needed to create the specified new folder.
- makeformwebtemplate -- The makeformwebtemplate statement converts a Panorama form into the equivalent HTML/CSS.
- makeglobals -- The makeglobals statement creates one or more global variables, and assigns a value to each new variable.
- makeinteger( -- The makeinteger( function makes a random integer with up to the specified # of digits (may be less).
- makelocals -- The makelocals statement creates one or more local variables, and assigns a value to each new variable.
- makemergeformula( -- The makemergeformula( function builds a formula from an “auto-wrap" style merge template.
- makemergeformula -- The makemergeformula statement makes a formula from a template.
- makenewform -- The makenewform statement creates a new form in the current database.
- makenewprocedure -- The makenewprocedure statement creates a new procedure in the current database.
- makenumberedarray( -- The makenumberedarray( function generates a numeric sequenced text array.
- makenumberedarray -- The makenumberedarray statement generates a numeric sequenced text array.
- makepackage -- The makepackage statement creates a new package, and if necessary, also creates any enclosing folders needed to create the specified new package.
- makesecret -- The makesecret statement makes the current database disappear, while leaving it open in memory.
- Manually Uploading a Quick Patch to the Server -- uploading a procedure or form.
- maprectangle( -- The maprectangle( function maps the position and size of a rectangle within a template rectangle into the same relative position and size within a goal rectangle.
- mapurl( -- The mapurl( function returns a URL to display a map location.
- Mark Menu -- allows you to set bookmarks in source code to help navigate to specific spots in a long program.
- match -- The match operator checks to see if the text on the left matches the wildcard pattern specified on the right.
- matchexact -- The matchexact operator checks to see if the text on the left matches the wildcard pattern specified on the right.
- Matrix Clicking -- handling clicks in a Matrix Object.
- Matrix Constructor -- quickly creating a Matrix Object from a template.
- Matrix Database Integration -- synchronizing a Matrix Object with a database.
- Matrix Geometry -- customizing the size and geometry of Matrix Object elements.
- Matrix Header and Horizontal Scrolling -- setting up a custom header for a Matrix Object grid.
- Matrix Object Frame -- setting up the arrangement of items within a Matrix Object.
- Matrix Object -- displaying a grid of items with a custom arrangement.
- Matrix Programming -- programming a Matrix object.
- matrixbutton -- The matrixbutton statement helps implement buttons in a matrix object.
- matrixbuttonhelper -- The matrixbuttonhelper statement helps implement buttons in a matrix object.
- matrixclick -- The matrixclick statement will run the code belonging to an object that was clicked within a matrix frame.
- matrixclickedobjectid -- The matrixclickedobjectid statement helps implement buttons in a matrix object.
- matrixredrawclickedcell -- The matrixredrawclickedcell statement redraws the matrix cell that was just clicked.
- max( -- The max( function compares a series of values and returns the largest value.
- maximum -- The maximum statement calculates the maximum and sub-maximums for the current field.
- md5( -- The md5( function calculates the MD5 hash of a binary or text data item.
- measuretext( -- The measuretext( function returns the size of a string of text in a particular font and size.
- Memory Usage -- memory usage.
- menu( -- The menu( function creates a menu (see Custom Menus).
- menuitem( -- The menuitem( function creates a single menu item (see Custom Menus).
- menuitems( -- The menuitems( function converts a semicolon separated array into a live menu specification.
- Menus -- overview of Panorama X menu bars.
- menuseparator( -- The menuseparator( function generates a menu item separator
- mergedictionaries( -- The mergedictionaries( function merges the contents of two or more dictionaries (see Data Dictionaries).
- mergedictionaries -- The mergedictionaries statement merges the contents of two or more dictionaries (see Data Dictionaries).
- mergefieldsdialog -- The mergefieldsdialog statement opens the standard Merge Fields dialog.
- Merging Adjacent Fields -- merging two fields into one.
- message -- The message statement displays a modal alert window with a message.
- mid( -- The mid( function extracts characters from the middle of the text.
- min( -- The min( function compares a series of values and returns the smallest value.
- minimum -- The minimum statement calculates the minimum and sub-minimums for the current field.
- mixedupperword( -- The mixedupperword( function converts lower case words to Initial Caps, but leaves mixed case words alone.
- mod -- The mod operator computes the remainder (modulo) after integer division.
- Modifiable Object Properties -- describes the properties of graphic objects that can be modified by a program (dimensions, color, font, title, etc.).
- modifyfileattributes -- The modifyfileattributes statement modifies one or more attributes of a file (or folder).
- money( -- The money( function converts a number to text, formatted as money.
- month1st( -- The month1st( function computes the first day of a month.
- monthlength( -- The monthlength( function computes the length (number of days) of a month.
- monthmath( -- The monthmath( function takes a date and computes the date that is one or more months before or after the original date.
- monthvalue( -- The monthvalue( function extracts the month from a date as a numeric value.
- Morph All Fields Dialog -- morphing the contents of the entire database.
- Morph Date Field Operations -- date morphing operations.
- Morph Field Dialog -- morphing the contents of an entire field.
- Morph Field Favorites -- saving and recalling favorite data morphing operations.
- Morph Numeric Field Operations -- numeric data morphing operations.
- Morph Text Field Operations -- text data morphing operations.
- morphalldialog -- The morphalldialog statement opens the standard MorphAll dialog.
- morphdialog -- The morphdialog statement opens the standard Morph dialog.
- Mouse and Click Status -- accessing the mouse (location, buttons) and keyboard status.
- movefieldbefore -- The movefieldbefore statement moves the current field to a new position.
- moveobjects -- The moveobjects statement will move an object or group of objects up, down, left or right on the form.
- moverecorddown -- The moverecorddown statement moves the current record down one line.
- moverecordup -- The moverecordup statement moves the current record up one line.
- nan( -- The nan( function checks to see if a numeric value is invalid.
- nanerror( -- The nanerror( function converts invalid numeric values into an error.
- nanzero( -- The nanzero( function converts invalid numeric values into zero.
- naturaldate( -- The naturaldate( function converts a number representing a date into text using "natural" formatting.
- New -- List of new features that did not exist in Panorama 6.
- newdatabase -- The newdatabase statement creates a new database.
- newdatabaseusingblueprint -- The newdatabaseusingblueprint statement creates a new database from a blueprint.
- newdatabasewithfields -- The newdatabasewithfields statement creates a new database with one or more fields.
- newdatabasewithjson -- The newdatabasewithjson statement creates a new database using a JSON file.
- newdatabasewithtemplate -- The newdatabasewithtemplate statement creates a new database with a template.
- newdatabasewithtextfieldnames -- The newdatabasewithtextfieldnames statement creates a new database from a text file. The text file must contain the field names in the first line.
- newdatabasewithtextfile -- The newdatabasewithtextfile statement creates a new database from a plain text file. The fields will be named A, B, C, etc.
- newformobject -- The newformobject statement creates a new graphic object in a form.
- newformusingblueprint -- The newformusingblueprint statement creates a new form from a blueprint.
- Newly Opened Database Window Arrangement -- customizing the arrangement and location of windows when a database is opened.
- newsearchgadget -- The newsearchgadget statement creates a search gadget in the current form.
- nextdaylightsavingstimetransition( -- The nextdaylightsavingstimetransition( function returns the next date on which a transition to or from daylight savings time occurs.
- nextmatch -- The nextmatch statement locates the next visible record in the active database for which the condition specified in the most recent Find statement is true.
- nextvalue -- The nextvalue statement advances a variable or field to the next value in a list.
- noactionmenu( -- The noactionmenu( function suppresses the Action menu.
- noimplicitassignment -- The noimplicitassignment statement does nothing, and is only retained for compatibility with earlier versions.
- noinstrumentationmenu( -- The noinstrumentationmenu( function supresses the Instrumentation menu.
- Non Decimal Numbers -- working with numbers in alternative (non-decimal) bases, including binary, octal and hexadecimal.
- nop -- The nop statement does nothing (*n*o *op*eration).
- normalexpressionstack -- The normalexpressionstack statement does nothing.
- noshow -- The noshow statement temporarily disables the output of text and graphics.
- not( -- The not( function reverses a Boolean value
- not -- The not operator reverses a boolean value.
- notbetween( -- The notbetween( function checks to see if a value is not between two other values.
- notcontains -- The notcontains operator returns true if the value on the left does not contain the value on the right, false if it does.
- notmatch -- The notmatch operator checks to see if the text on the left does not match the wildcard pattern specified on the right.
- notmatchexact -- The notmatchexact operator checks to see if the text on the left doesn't match the wildcard pattern specified on the right.
- noundo -- The noundo statement does nothing (it used to disable undo).
- now( -- The now( function returns the current time (number of seconds since midnight).
- nowatchcursor -- The nowatchcursor statement does nothing, and is only retained for compatibility with earlier versions.
- nowizardmenu( -- The nowizardmenu( function suppresses the Wizards menu.
- noyes -- The noyes statement displays a modal alert window with a message and two buttons: No and Yes.
- nslog -- The nslog statement sends a message to the console log.
- nsnotify -- The nsnotify statement delivers a notification.
- nsrect( -- The nsrect( function defines a rectangle using the same parameter order as the Cocoa NSMakeRect( function.
- nsrectstr( -- The nsrectstr( function converts a rectangle into text in the format x,y,width,height
- nth( -- The nth( function converts a number into an ordinal.
- nthline( -- The nthline( function extracts the nth line from the text.
- nthword( -- The nthword( function extracts a word from the middle of the text.
- Numbers -- Working with numeric values in a formula, and converting between numbers and text.
- Numeric Data -- numeric data (fixed and floating point).
- Numeric Patterns -- control how a number is displayed or converted to text.
- Numeric Search Options -- searching numbers within a database.
- numsandwich( -- The numsandwich( function is similar to the sandwich function, but for numbers. If the value is zero the result is zero, but if the value is not zero the result is the value plus the extra.
- obfuscate( -- The obfuscate( function randomizes the letters and digits in text.
- Object Inspector Panel -- is used to view and modify the attributes of selected objects in a form.
- Object Library -- is used to create new objects in a form.
- Object Names -- can be used to identify an object in a program.
- object -- The object statement selects an object (based on the object name).
- objectaction -- The objectaction statement allows a procedure to communicate with an object on the current form.
- objectid -- The objectid statement selects one graphic object in the current form based on an ID number.
- objectinfo( -- The objectinfo( function returns information about a graphic object: its location, size, color, font, etc.
- objectinfoarray( -- The objectinfoarray( function builds a text array of form object properties
- objectnumber -- The objectnumber statement identifies one graphic object from a set of selected graphic objects in the current form.
- Objects Menu -- used to select, modify and arrange graphics objects in a form.
- obscuredigits( -- The obscuredigits( function obscures digits in a number (usually a credit card number) with Xs.
- okcancel -- The okcancel statement displays a modal alert window with a message and two buttons: Ok and Cancel.
- onerror -- The onerror statement can be used to catch all errors that are not trapped by if error or try statements.
- onescomplement( -- The onescomplement( function returns the one's complement of a 64 bit number (all bits are reversed)
- onespace( -- The onespace( function removes all leading & trailing spaces and any extra spaces between words, so that there is exactly one and only one space between each word.
- onewhitespace( -- The onewhitespace( function removes all leading spaces and any extra whitespace between words, making sure that there is one and only one space between each word.
- onfailedresume -- The onfailedresume statement is used to setup a semi-graceful recovery if a resume statement fails because there was no pause statement.
- Open Favorites -- quickly open commonly used databases.
- Open Recent -- quickly re-open recently used databases.
- Open View -- using the Open View window to quickly access any form, procedure or data sheet.
- openanything -- The openanything statement opens a document or application.
- openasyncprogresswindow -- The openasyncprogresswindow statement opens a floating progress window for asynchronous operations (urltask(, timers).
- openclonewindow -- The openclonewindow statement opens a clone of the current window.
- opendatabase -- The opendatabase statement opens a database file.
- opendialog -- The opendialog statement opens a form from the current database as a modal dialog box.
- opendialogsheet -- The opendialogsheet statement opens a form from the current database as a sheet dialog (attached to the current window).
- openfarform -- The openfarform statement opens a form in another database.
- openfile -- The openfile statement opens a database file. It can also import data from a text file, another database, or a variable into the current database.
- openfiledialog -- The openfiledialog statement pauses and displays the standard “open file” dialog.
- openform -- The openform statement opens a form in the current database in a new window.
- Opening a Database in Diagnostic Mode -- opening a database so that no implicit code is triggered.
- openlivecoursecalendar -- The openlivecoursecalendar statement Opens the Live Course Calendar window.
- openmapwindow -- The openmapwindow statement opens a window displaying a map of a location.
- openplain -- The openplain statement opens a database without opening any pre-saved windows, just the data sheet.
- openpreferenceswindow -- The openpreferenceswindow statement opens the Panorama Preferences window.
- openprocedure -- The openprocedure statement opens a procedure in the current database in a new window.
- opensavedwindows -- The opensavedwindows statement opens windows that were open the last time file was saved.
- opensecret -- The opensecret statement opens a database invisibly, without opening its windows.
- openserverfile -- The openserverfile statement opens a database (used on the server).
- opensheet -- The opensheet statement opens the data sheet window for the current database in a new window.
- opensoftwareupdatewindow -- The opensoftwareupdatewindow statement opens the Panorama Software Update window.
- opentextfile -- The opentextfile statement imports data from a text file or a variable into the current database.
- openurl -- The openurl statement opens a URL (usually a web page or to create an e-mail message).
- openurlinbackground -- The openurlinbackground statement opens a URL (usually a web page or to create an e-mail message) without bringing forward the app that handles the URL (in other words, Panorama remains the frontmost application).
- openviewdialog -- The openviewdialog statement opens the standard Open View dialog (in the View Menu).
- openviewsearch -- The openviewsearch statement opens a View Search window.
- openwebmap -- The openwebmap statement opens a web browser window displaying a map of a location.
- openwith -- The openwith statement opens a document with a specific application.
- openwithterminal -- The openwithterminal statement opens an application in a new Terminal.app window (useful for debugging).
- openwizard -- The openwizard statement opens a wizard, just as it would be opened by selecting that wizard from the menubar.
- Operators -- index of all operators available for use in Panorama formulas.
- optionclick( -- The optionclick( function returns true if the option key was held down the last time the mouse was clicked.
- or -- The or operator returns true if either operand is true, or false if both are false.
- originalwindow -- The originalwindow statement goes back to the window remembered by the RememberWindow statement.
- os9( -- The os9( function returns true if running on OS 9.
- oswindows( -- The oswindows( function returns true if running on Microsoft Windows, otherwise false
- osx( -- The osx( function returns true if running on OS X, otherwise false
- outcode( -- The outcode( function adds one frame to a timecode.
- outlinelevel -- The outlinelevel statement expands or collapses the entire database to show a specific level of data or summary level.
- Oval Object -- draws an oval or circle within a form.
- padzero( -- The padzero( function makes the text a fixed width, padding on the left with zeros if necessary.
- pagesetup -- The pagesetup statement displays the page setup dialog.
- Panorama Database Exchange -- Panorama Database Exchange allows you to download databases uploaded by other Panorama users.
- Panorama Menu -- get and set information about Panorama itself, including the version number, licensing information, and memory usage.
- Panorama X vs. Panorama 6 -- Early release status report.
- panoramaappvisibility -- The panoramaappvisibility statement allows the Panorama X dock and menu bar to be hidden.
- panoramamacid( -- The panoramamacid( function returns the MAC address registered with Panorama for this computer.
- panoramastartupdatabases -- The panoramastartupdatabases statement opens any databases specified for startup.
- panoramaxservercgisuffix( -- The panoramaxservercgisuffix( function adds the Panorama server cgi suffix to a url
- panoramaxservercgiurl( -- The panoramaxservercgiurl( function returns the URL associated with a Panorama X server cgi.
- panoramaxservers( -- The panoramaxservers( function returns an array of available Panorama servers.
- panoramaxserverurl( -- The panoramaxserverurl( function returns the URL associated with a Panorama X server.
- parameter( -- The parameter( function is used to transfer data between a main procedure and a subroutine.
- parameterentity( -- The parameterentity( function returns the entity (field or variable) associated with a subroutine parameter, if any.
- partialdatabaseupdate -- The partialdatabaseupdate statement updates one or more components of an existing database.
- paste -- The paste statement pastes the contents of the clipboard into the current field.
- pastecell -- The pastecell statement pastes the contents of the clipboard into the current cell.
- pasteline -- The pasteline statement inserts a new record containing the contents of the clipboard.
- pasterecord -- The pasterecord statement inserts a new record containing the contents of the clipboard.
- pathcontains( -- The pathcontains( function checks to see if a folder contains a specified file (or folder).
- pathcontents( -- The pathcontents( function lists the contents of a folder (specified by a path)
- pathexists( -- The pathexists( function checks to see if a path exists.
- pathseparator( -- The pathseparator( function returns the type of separator character used in a file path (either / or :).
- pattern( -- The pattern( function converts a number into text using a pattern.
- pause -- The pause statement temporarily pauses a procedure.
- pausespeaking -- The pausespeaking statement pauses any talking that is currently happening.
- percentescape( -- The percentescape( function encodes specified characters using percent encoding.
- percentunescape( -- The percentunescape( function decodes text that contains percent encoding.
- Perl Scripting -- writing and using Perl scripts.
- perl( -- The perl( function executes a perl program and returns the result (stdout).
- perl -- The perl statement executes a Perl script (program).
- perlconstant( -- The perlconstant( function encodes text for use as a constant in a Perl program.
- perlscriptstring( -- The perlscriptstring( function converts text into a Perl string literal.
- permanent -- The permanent statement creates one or more permanent variables.
- Permanently Deleting a Database from the Server -- remove a database from the server.
- Permanently Detaching a Shared Database from the Server -- unshare a shared database.
- php( -- The php( function executes a PHP program and returns the result.
- php -- The php statement executes a PHP script (program).
- phpconstant( -- The phpconstant( function encodes text for use as a contant in a php program.
- pi( -- The pi( function returns the value of pi .
- pinrectangle( -- The pinrectangle( function pins a rectangle within the bounds of a larger rectangle.
- places( -- The places( function converts a number to text with a specific number of places after the decimal point.
- playsound -- The playsound statement starts playing a sound file.
- pleaseselectall -- The pleaseselectall statement makes sure that all records are selected.
- pluralpattern( -- The pluralpattern( function converts a number to text using a pattern, making adjustments for pluralization.
- pmt( -- The pmt( function (short for payment) calculates the periodic payment required to pay off a loan.
- point( -- The point( function combines vertical and horizontal co-ordinates into a single binary value that describes the position of a point (see Graphic Coordinates).
- pointstr( -- The pointstr( function converts a point value into text in the format v,h (for example 34,56).
- pointsval( -- The pointsval( function converts a dimension to points (possibly from inches or centimeters).
- Polygon Object -- draws a polygon within a form.
- Popup Menu Button Object -- is used to create popup menus anywhere on a form.
- popup -- The popup statement makes a pop-up menu appear anywhere on the screen.
- popupatmouse -- The popupatmouse statement displays a pop-up menu at the current mouse location.
- popupbelowbutton -- The popupbelowbutton statement displays a pop-up menu in response to clicking on a button.
- popupbutton -- The popupbutton statement displays a pop-up menu in response to clicking on a button.
- popupbynumber -- The popupbynumber statement makes a pop-up menu appear anywhere on the screen.
- popupclick -- The popupclick statement displays a pop-up menu at the current mouse location.
- popupdoublefieldchoices -- The popupdoublefieldchoices statement displays a pop-up menu listing values in a specified field, with submenus containing values from a second field.
- popupfieldchoices -- The popupfieldchoices statement displays a pop-up menu listing values in a specified field.
- popupsharingmenu -- The popupsharingmenu statement pops up a menu for the toolbar sharing icon.
- posixpath( -- The posixpath( function converts a path and filename into a POSIX path that can be used as a parameter to a shell command.
- posixscript( -- The posixscript( function executes a POSIX shell script using NSTask and returns the result.
- posixtask( -- The posixtask( function executes a POSIX shell script in the background using NSTask.
- posixtask -- The posixtask statement executes a POSIX shell script in the background using NSTask.
- post -- The post statement assigns a value to a field in another database.
- postadjust -- The postadjust statement adjusts the value of a numeric field in another database, by adding (or subtracting) a number.
- posttorelated -- The posttorelated statement posts data in the current record to the corresponding record in a related database.
- posturl( -- The posturl( function loads a resource from the internet, with form data.
- posturl -- The posturl statement loads a resource from the internet, with form data.
- Preference Values -- reading and writing system preference values.
- preferences( -- The preferences( function retreives a list of preferences that have been stored.
- Preventing Endless Loops -- setting up a timeout limit to prevent endless loops.
- previousmatch -- The previousmatch statement locates the previous (closer to the top) visible record in the active database for which the condition specified in the most recent Find statement is true.
- print -- The print statement prints the database.
- Printing Multiple Column Reports -- printing reports with two, three or more columns (for example mailing labels).
- Printing Multiple Page Records -- Panorama can print up to 9 pages for each record in a custom report (for example multi page invoices, etc.)
- Printing Summary Information -- printing a database that has been organized into categories with summary records.
- Printing -- printing reports, mailing labels, etc.
- printonemultiple -- The printonemultiple statement prints a form over and over again without advancing from record to record. Instead of advancing from record to record, a variable is incremented each time the form is printed. This statement is designed for printing calendars or thumbnails.
- printonerecord -- The printonerecord statement prints the the currently active record.
- printpdf -- The printpdf statement prints the current database to a PDF file.
- printpreview -- The printpreview statement previews what printing the current window will look like.
- printpreviewonerecord -- The printpreviewonerecord statement previews what printing the current record will look like.
- printtopdf -- The printtopdf statement prints the current database to a PDF file.
- printusingform -- The printusingform statement allows the current database to be printed using a different form than the one currently being displayed.
- Procedure Editor -- editing named procedures.
- Procedure Recorder -- recording database actions as code.
- procedureexists( -- The procedureexists( function checks to see whether a procedure exists or not.
- procedureinsertfieldname -- The procedureinsertfieldname statement inserts a field name into a procedure, adding chevrons if necessary.
- procedureinsertformname -- The procedureinsertformname statement inserts a form name into a procedure, adding quotes.
- procedureinsertprocedurename -- The procedureinsertprocedurename statement inserts a procedure name into a procedure, adding quotes if necessary.
- procedureinserttext -- The procedureinserttext statement inserts text into the current procedure.
- Procedures -- basics of procedures for automation.
- proceduresearch -- The proceduresearch statement searches for text in a procedure.
- proceduresearchexact -- The proceduresearchexact statement searches for text in a procedure.
- proceduresearchnext -- The proceduresearchnext statement searches for text in a procedure, starting from the current location.
- proceduresearchnextexact -- The proceduresearchnextexact statement searches for text in a procedure, starting from the current location.
- proceduresetselection -- The proceduresetselection statement changes the text selection in the current procedure editor window.
- Program Access to Databases -- using a program to create, open, import or export databases.
- Program Error Handling -- handling errors and exceptions that occur when a program is running.
- Program Menu -- assists with running and debugging code, and with developing custom dialogs.
- Programmable Database Administration -- using a program to access and/or modify the structure of a database.
- Programmable Form Management -- using a program to work with forms.
- Programmable Graphics -- using program code to create and modify graphic objects in a form.
- Programmable Outlines -- using a program to create and manipulate data outlines.
- Programmable Printing -- using program code to print reports, mailing labels, etc.
- Programmable Searching -- using program code to search and select data.
- Programmable Sorting -- using program code to sort a database.
- Programmable Text Export -- using a program to export text from a database.
- Programmable Window Management -- using a program to arrange windows.
- Programming Database Fields -- using a program to add and remove database fields.
- Programming -- basics of programming with Panorama X.
- Progress Indicator Object -- is used to create progress indicators
- progressalert -- The progressalert statement displays a progress alert if an operation is going to take a long time.
- progressbar -- The progressbar statement updates a progress bar on the current form.
- Propagate & Unpropagate -- propagating/unpropagating data within a column.
- propagate -- The propagate statement fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell above it.
- propagateup -- The propagateup statement fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell below it.
- provueserverisup( -- The provueserverisup( function checks whether provue.com is online and operating.
- provueserverisup -- The provueserverisup statement checks whether provue.com is online and operating.
- Push Button Object -- triggers a procedure when it is pushed.
- pv( -- The pv( function (short for present value) calculates the present value of an income or debit stream of payments.
- python( -- The python( function executes a python program and returns the result (stdout).
- python -- The python statement executes a Python script (program).
- pythonconstant( -- The pythonconstant( function encodes text for use as a constant in a python program.
- quarter1st( -- The quarter1st( function computes the first day of a quarter.
- quartervalue( -- The quartervalue( function extracts the quarter from a date as a numeric value.
- quit -- The quit statement quits Panorama.
- quoted( -- The quoted( function returns a quoted version of the supplied text.
- Quotes -- text constants embedded into a formula
- radian -- The radian statement tells Panorama that all angles in trigonometric functions should be calculated using radians rather than degrees.
- radians2degrees( -- The radians2degrees( function converts an angle from radians to degrees.
- radianstodegrees( -- The radianstodegrees( function converts an angle from radians to degrees.
- radix( -- The radix( function converts a text item containing a number in a radix between 2 and 36 into a decimal number.
- radixstr( -- The radixstr( function converts a number into a text item containing the equivalent number in a radix between 2 and 36.
- randomarrayelement( -- The randomarrayelement( function returns a random element from an array.
- randominteger( -- The randominteger( function generates a random integer between the starting and ending values.
- randomletter( -- The randomletter( function returns a random letter.
- randomline( -- The randomline( function returns a random line from multiple lines of text.
- randomword( -- The randomword( function returns a random word from a list of words.
- rangecontains( -- The rangecontains( function checks to see if the text contains any characters in the specified range.
- rangematch( -- The rangematch( function returns true (-1) if the text matches a specified range.
- rangenotmatch( -- The rangenotmatch( function returns false (0) if the text matches a specified range.
- Ranking Summaries -- ranking summary values
- rawtags( -- The rawtags( function is an internal function used by other tag functions.
- rbottom( -- The rbottom( function extracts the position of the bottom edge of a rectangle (see rectangle(, Graphic Coordinates).
- Rearranging Field Order -- rearranging the order of fields in the data sheet.
- recalculatefield -- The recalculatefield statement recalculates all values in current field based on field's formula (selected records only).
- recompile -- The recompile statement recompiles all procedures in a database.
- recompiledatabase -- The recompiledatabase statement recompiles all of the procedures in a specified database.
- recompilelibraries -- The recompilelibraries statement recompiles all Panorama libraries.
- Recompiling Code -- recompiling code & formulas
- Record Locking and Editing Shared Data -- coordinating data entry across multiple simultaneous users.
- Record Locking in Procedure Code -- implicit and explicit management of record locking.
- Record Search Options -- searching via record attributes.
- Recording Code Triggers in Debug Instrumentation -- the code triggers option automatically tracks whenever any code is triggered, whether from a menu, a button, or implicitly (for example when data is entered).
- Recording Control Flow in Debug Instrumentation -- configure debug instrumentation to automatically log when control flow is non-linear, for example a call, return, goto, etc.
- recordislocked( -- The recordislocked( function tests whether the current record is locked on this client.
- Records Menu -- add and remove database records.
- Rectangle Object -- draws a rectangle or square within a form.
- rectangle( -- The rectangle( function defines a rectangle from four dimensions.
- rectangleadjust( -- The rectangleadjust( function adjusts all four edges of a rectangle independently
- rectanglealign( -- The rectanglealign( function aligns a small rectangle at one of nine positions within a larger rectangle.
- rectanglecenter( -- The rectanglecenter( function adjusts a rectangle so that it is centered inside of another rectangle.
- rectangleinset( -- The rectangleinset( function insets a rectangle by a specified amount.
- rectangleoffset( -- The rectangleoffset( function offsets a rectangle to a new position.
- rectanglesize( -- The rectanglesize( function defines a rectangle from its upper left hand corner and its height and width.
- rectanglesizestr( -- The rectanglesizestr( function converts a rectangle into text in the format top,left,height,width.
- rectanglestr( -- The rectanglestr( function converts a rectangle into text in the format top,left,bottom,right.
- rectangletweak( -- The rectangletweak( function transforms a rectangle by changing its position and/or size.
- red( -- The red( function extracts the red intensity from a color.
- Refining a Selection -- selecting a subset or superset of a previous selection."
- refreshcrosstabdatabase -- The refreshcrosstabdatabase statement refreshes a crosstab database.
- refreshsummarydatabase -- The refreshsummarydatabase statement refreshes a summary database.
- regexarray( -- The regexarray( function applies a regular expression to a text value, then builds an array containing all of the substrings that match the regular expression (see Regular Expressions).
- regexarrayexact( -- The regexarrayexact( function applies a regular expression to a text value, then builds an array containing all of the substrings that match the regular expression (see Regular Expressions).
- regexliteral( -- The regexliteral( function adds \ characters to text as necessary so that it can be used as a literal in a regular expression.
- regexmatch -- The regexmatch operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
- regexmatchexact -- The regexmatchexact operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
- regexreplace( -- The regexreplace( function replaces text with new text. The text to be replaced is determined by a regular expression.
- regexreplaceexact( -- The regexreplaceexact( function replaces text with new text. The text to be replaced is determined by a regular expression.
- regexreplacefirst( -- The regexreplacefirst( function replaces the first occurrence of a regular expression pattern with new text.
- regexreplacefirstexact( -- The regexreplacefirstexact( function replaces the first occurrence of a regular expression pattern with new text.
- registercustomfunction -- The registercustomfunction statement defines a new custom function.
- Regular Expressions -- Regular expressions can be used to look for a specified pattern in text and then specify what to do with each pattern match that is found
- regulardate( -- The regulardate( function extracts a regular date (number of days from January 1, 4713 B.C.) from a superdate.
- regulartime( -- The regulartime( function extracts a regular time (seconds since midnight) from a superdate.
- related( -- The related( function searches for a record in a related database that matches the current record in the current database based on a relational specification (based on one or more key fields or formulas in each database), then uses a formula to return other information from the same record. This is similar to the lookup( function, but instead of using an individual field for the key, a relation is used (see Relational Database Management).
- relatedarray( -- The relatedarray( function builds an Text Array by scanning a database and creating an array element for every record that matches a relational specification (based on one or more key fields or formulas). This is similar to the arraybuild( function, but instead of using an individual field for the key, a relation is used (see Relational Database Management).
- relatedrecordid( -- The relatedrecordid( function returns the record id of a record in a related database that matches the current record in the current database based on a relational specification.
- Relational Database Management -- linking together multiple databases based on common data.
- Relational Workshop -- tool that assists in composing relational lookup(, superlookup(, lookupall( and arraybuild( functions.
- Release Notes -- detailed list of what's new in every Panorama X version.
- rememberwindow -- The rememberwindow statement remembers the currently active window, so that you can get back to it later.
- remotepanoramaxservers( -- The remotepanoramaxservers( function returns the names of all Panorama X servers that are remotely accessible from this computer.
- removeallsummaries -- The removeallsummaries statement removes all summary records.
- removedetail -- The removedetail statement removes data records from the current database, leaving only summary records. It can also delete low level summary records, leaving only higher levels.
- removepreferencevalues -- The removepreferencevalues statement deletes one or more preference values.
- removeprefix( -- The removeprefix( function checks to see if a text item starts with a prefix. if it does, the prefix is removed.
- removeremotehost -- The removeremotehost statement makes a remote host unavailable to this computer.
- removeselected -- The removeselected statement deletes all selected records from the database.
- removesuffix( -- The removesuffix( function checks to see if a text item ends with a suffix. if it does, the suffix is removed.
- removesummaries -- The removesummaries statement removes summary records from the current database.
- removeunselected -- The removeunselected statement deletes all unselected records from the database.
- renamedictionarykey( -- The renamedictionarykey( function changes the key (name) of one or more values in a dictionary (see Data Dictionaries).
- renderwebform( -- The renderwebform( function renders a Panorama web form into HTML, merging data into the template as necessary.
- renderwebform -- The renderwebform statement renders a Panorama web form into HTML, merging data into the template as necessary.
- renderwebtable( -- The renderwebtable( function renders a web table using records selected with WebSelect in the current database.
- renderwebtable -- The renderwebtable statement renders a web table using records selected with WebSelect in the current database.
- reorderfieldsdialog -- The reorderfieldsdialog statement opens the Reorder Fields dialog.
- rep( -- The rep( function assembles a text item by repeating a smaller text item over and over again.
- repeatloopif -- The repeatloopif statement decides whether to continue with a loop or to start over again from the top.
- replace( -- The replace( function replaces text with new text.
- replacefirst( -- The replacefirst( function replaces the first occurence of some text with new text.
- replacemultiple( -- The replacemultiple( function replaces multiple words and phrases in a text value.
- replaceword( -- The replaceword( function replaces a word with a new word.
- replacewordexact( -- The replacewordexact( function replaces a word with a new word.
- Report Tile Object -- component for assembling a custom report.
- Reports -- Panorama has a very flexible system for printing custom reports, labels and forms.
- resetallrecordidts -- The resetallrecordidts statement resets the internal record id and time stamps for every record in the current database.
- Restricting Server Access -- limiting Panorama X Server access to authorized users.
- resume -- The resume statement resumes a procedure that has been temporarily halted with the pause statement.
- resumeaftertask -- The resumeaftertask statement resumes after a waitfortask statement.
- resumespeaking -- The resumespeaking statement resumes speaking after a pause.
- resynchronize -- The resynchronize statement synchronizes the local database with Panorama Server. This is the same as choosing Synchronize from the File menu.
- retrywebform -- The retrywebform statement retries a web form that has missing or invalid data.
- return -- The return statement ends a subroutine.
- returnerror -- The returnerror statement passes an error back to the current subroutines calling procedure.
- Reveal in Finder -- reveal the location of a database in the Finder.
- revealinfinder -- The revealinfinder statement reveals a file or folder in the Finder.
- revealmultipleinfinder -- The revealmultipleinfinder statement reveals one or more files or folders in the Finder.
- reverseorder -- The reverseorder statement reverses the order of the records in the database.
- revert -- The revert statement reloads the last saved version of the database from the disk.
- rgb( -- The rgb( function creates a color by combining red, green, and blue primary colors. See Colors.
- rgbstr( -- The rgbstr( function converts a color into text in the format red,green,blue.
- rheight( -- The rheight( function extracts the height of a rectangle (see rectangle(, Graphic Coordinates).
- Rich Text -- is used to display styled text, including bold, italic, colors, tabs, even images.
- richtextdata( -- The richtextdata( function adjusts text so that it will display properly in rich text even if it contains a < character.
- richtextdisplay( -- The richtextdisplay( function works with Text Display objects to display text with multiple styles, fonts, colors and alignments.
- right( -- The right( function extracts characters from the right edge of the text.
- right -- The right statement moves the cursor to the next field in the active window.
- rleft( -- The rleft( function extracts the position of the left edge of a rectangle (see rectangle(, Graphic Coordinates).
- rnd( -- The rnd( function generates a random number between 0 and 1.
- round( -- The round( function rounds a number to a specified increment.
- Rounded Rectangle Object -- draws a rectangle with round corners within a form.
- rright( -- The rright( function extracts the position of the right edge of a rectangle (see rectangle(, Graphic Coordinates).
- rtop( -- The rtop( function extracts the position of the top edge of a rectangle (see rectangle(, Graphic Coordinates).
- ruby( -- The ruby( function executes a ruby program and returns the result (stdout).
- ruby -- The ruby statement executes a Ruby script (program).
- rubyconstant( -- The rubyconstant( function encodes a value for use as a constant in a Ruby program.
- rudemessage -- The rudemessage statement displays a message alert.
- runcustommenu -- The runcustommenu statement runs the *.CustomMenu* procedure.
- rundialog -- The rundialog statement uses a form as a template to display a modal dialog window. The statement supervises the operation of the dialog until it is closed.
- rundialogmenus -- The rundialogmenus statement enables custom menus in a modal dialog.
- runfieldcalculations -- The runfieldcalculations statement performs any automatic calculations associated with the current field.
- runfieldcode -- The runfieldcode statement runs the automatic code associated with the specified field.
- runfieldsideeffects -- The runfieldsideeffects statement performs any side effects associated with the current field (calculations, procedures, etc.).
- runmodifyfill -- The runmodifyfill statement runs the .ModifyFill procedure (if it exists).
- Running Difference -- calculating a running difference down an entire database column.
- Running Total -- calculating a running total down an entire database column.
- runningappinfo( -- The runningappinfo( function returns information about applications that are currently running on this computer.
- runningdifference -- The runningdifference statement calculates the running difference for the current field.
- runningtotal -- The runningtotal statement calculates the running total for the current field.
- rwidth( -- The rwidth( function extracts the width of a rectangle (see rectangle(, Graphic Coordinates).
- safefileerase -- The safefileerase statement deletes a file if it exists, but no error if it doesn't exist.
- safeselect -- The safeselect statement makes visible only those records for the active database for which the specified condition is true. If no records match, the previous selection is retained.
- safeselectwithin -- The safeselectwithin statement makes visible only those previously selected records in the active database for which the specified condition is true. If no records match, the previous selection is retained.
- sandwich( -- The sandwich( function assembles a text item from three smaller items.
- saturation( -- The saturation( function extracts the saturation from a color.
- save -- The save statement saves the database to disk.
- saveacopyas -- The saveacopyas statement saves a copy of the currently active file under a new name. The original database remains open in memory under its original name.
- saveallprocedures -- The saveallprocedures statement saves all the procedures in the specified database into a dictionary.
- saveandclose -- The saveandclose statement saves and closes a database file.
- saveas -- The saveas statement saves a copy of the currently active file under a new name. The original file remains unchanged.
- saveblueprint -- The saveblueprint statement save a blueprint of a database's structure.
- savedialog -- The savedialog statement displays a modal dialog that allows a user to specify the name and location of a new file.
- savefiledialog -- The savefiledialog statement pauses a procedure and displays the standard “save file” dialog.
- savelocalvariables -- The savelocalvariables statement saves local variables as a procedure.
- saveoneprocedure -- The saveoneprocedure statement saves a specific procedure in the specified database into a dictionary.
- saveopenprocedures -- The saveopenprocedures statement saves all the open procedures in the specified database into a dictionary.
- savepartialdatabase -- The savepartialdatabase statement saves specified components of the current database, leaving other components out.
- savewebtemplate -- The savewebtemplate statement saves a web template (a dictionary) associated with a form.
- scaleselectedobjects -- The scaleselectedobjects statement scale the selected objects by a specified factor.
- scanlibraries -- The scanlibraries statement scans all libraries and registers all of the custom statements in them.
- scanlibrary -- The scanlibrary statement scans a library and registers all of the custom statements in it.
- Scientific Calculations -- performing scientific calculations (trigonometry, logarithms, etc.)
- scientificnotation( -- The scientificnotation( function converts a number to text, formatted in scientific notation.
- scopes( -- The scopes( function returns the current scope of a variable, as well as any hidden scopes.
- scopevalue( -- The scopevalue( function returns the value of a variable in the specified scope.
- scrapcalc -- The scrapcalc statement calculates a formula and stores the result in the clipboard. (Note: The same effect can be achieved by putting the word clipboard on the left side of an assignment.)
- scriptbglog -- The scriptbglog statement specifies a path/file for output from STDOUT from embedded programs run in the background (Perl, Ruby, Python, PHP).
- Scripting Language Configuration -- configuring the scripting languages available to Panorama (Perl, PHP, Python and Ruby).
- Scripting Panorama X with AppleScript -- embedding Panorama code into AppleScript (allowing Panorama to be controlled from other programs).
- Scripting -- embedding scripting languages (AppleScript, shell scripts, Python, Ruby, PHP, Perl, etc.) into Panorama program code.
- scripttimeout -- The scripttimeout statement sets the maximum runtime allowed for an embedded program (AppleScript, ShellScript, Perl, Ruby or Python).
- Scroll Bar Object -- is used to create scroll bars.
- Search Menu -- is used search for data, to select records, and to find and replace text within the current field.
- search( -- The search( function searches through an item of text looking for a character, word or phrase. If it finds an exact match (including upper/lower case) with the character, word or phrase, it returns its position within the text item. If it does not find the character, word or phrase, it returns zero.
- searchanycase( -- The searchanycase( function searches through an item of text looking for a character, word or phrase. If it finds a match (upper/lower case may be different) with the character, word or phrase, it returns its position within the text item. If it does not find the character, word or phrase, it returns zero.
- Searching -- searching a database to find or select information.
- secsminshours( -- The secsminshours( function this converts a time (number of seconds) into an approximate text value.
- Segmented Button Object -- is used to created segmented buttons.
- Select Duplicates Dialog -- opens the standard Select Duplicates dialog sheet.
- select -- The select statement makes visible only those records for the active database for which the specified condition is true.
- selectadditional -- The selectadditional statement adds unselected records to a previously selected group if they match the true-false test.
- selectall -- The selectall statement makes every record in the database visible.
- selectallobjects -- The selectallobjects statement selects all the graphic objects in the current form.
- selectduplicates -- The selectduplicates statement selects records containing duplicate information in the database.
- selectduplicatesdialog -- The selectduplicatesdialog statement opens the standard Select Duplicates dialog.
- selectduplicatesnowarning -- The selectduplicatesnowarning statement selects records containing duplicate information in the database.
- selectedformobjectsblueprintsheet -- The selectedformobjectsblueprintsheet statement opens a sheet to edit the blueprint of the currently selected objects.
- Selecting Form Objects -- so that they can be modified.
- Selecting with the Context Menu -- searching for information related to the current cell.
- selectnoobjects -- The selectnoobjects statement unselects all the graphic objects in the current form.
- selectobjects -- The selectobjects statement uses a formula to select one or more objects in the current form.
- selectrecordsrelatedto -- The selectrecordsrelatedto statement selects records in the current database that are related to any record in another database.
- selectrelated -- The selectrelated statement selects information that matches the current record in a related database.
- selectreverse -- The selectreverse statement makes every visible record invisible, and every invisible record visible.
- selectwithin -- The selectwithin statement uses a Boolean formula to exclude records from a previously selected group.
- selectzipdistancetool -- The selectzipdistancetool statement selects records near the current record, based on zip codes.
- sendaction -- The sendaction statement sends an action message to the Cocoa responder chain.
- sendarrayemail -- The sendarrayemail statement sends a single e-mail to multiple recipients.
- sendbackward -- The sendbackward statement sends the selected form objects one layer towards the back.
- sendbulkemail -- The sendbulkemail statement sends a single e-mail to multiple recipients.
- sendemail -- The sendemail statement sends an e-mail. It gives access to the maximum number of options available.
- sendoneemail -- The sendoneemail statement sends a single e-mail to a single recipient.
- sendtoback -- The sendtoback statement sends the selected form objects to the back.
- seq( -- The seq( function returns sequential numbers (1, 2, 3, etc.).
- sequence -- The sequence statement fills every visible cell in the current field with a numeric sequence.
- Server Administration Wizard -- this wizard is used to monitor the operation of Panorama servers (both local and remote servers can be monitored), including monitoring server status, checking database status and downloading databases, and monitoring the status of user sessions.
- Server Variables (Shared Variables) -- sharing variable values across multiple users.
- serverdatabaseconsoledump -- The serverdatabaseconsoledump statement dumps the raw contents of the specified database on the server to the console in comma delimited format.
- serverdatabasename( -- The serverdatabasename( function returns the server database name associated with a shared database.
- serverformulafill -- The serverformulafill statement fills a specified subset of records in a shared database.
- serverjournalcode -- The serverjournalcode statement writes code to journal file.
- serverjournalcurrentrecord -- The serverjournalcurrentrecord statement writes the current record to journal file.
- serverlog -- The serverlog statement adds a line to one or more server logs.
- serverlookup( -- The serverlookup( function searches a shared database for a value, then returns other information from the same record. Similar to the lookup( function, but the search is performed on the server instead in the local computer's memory.
- serverlookupall( -- The serverlookupall( function builds a text array containing one item for every record in the target database where the data in the keyField matches the keyData. Similar to the lookupall( function but retreives the data directly from the server computer, instead of from the local computer's memory.
- servername( -- The servername( function returns the name of the server associated with a shared database.
- serverrunning( -- The serverrunning( function returns true if this code is running on a Panorama server, or false if it is running in single user mode or on a client.
- serverstatus( -- The serverstatus( function returns a dictionary describing the current status of Panorama X Server.
- serversuperlookup( -- The serversuperlookup( function searches a database for a record that matches a query formula, then uses a second formula to return other information from the same record. This is identical to the superlookup( function, but instead of searching in the local computer's memory, the search is done on the server to ensure that the most up-to-date information is returned.
- serverupdate -- The serverupdate statement temporarily disables record locking and server updates when using a shared database.
- servervariable( -- The servervariable( function returns the value of a server variable (a permanent variable on the server).
- servervariablenames( -- The servervariablenames( function returns the names of all server variables associated with a database.
- servervariables( -- The servervariables( function returns the names and values of all server variables associated with a database. The names and values are returned in a dictionary.
- set -- The set statement performs an assignment, much like an equals sign or the assign statement. However, the destination of the assignment can be calculated on the fly.
- setactivedatabase -- The setactivedatabase statement makes a database active (without changing the configuration of the windows).
- setappleeventvalue -- The setappleeventvalue statement may be used in a procedure that responds to an AppleEvent (this includes AppleScript programs), the statement specifies the value to be returned by the event.
- setautonumber -- The setautonumber statement changes the automatically generated number for the next record that will be added to database. This allows you to generate numbers out of sequence, or to start the sequence at a specific value.
- setbannericon -- The setbannericon statement sets the icon on the right side of the toolbar banner.
- setbannermessage -- The setbannermessage statement sets the text in the toolbar banner to an arbitrary message.
- setbannerprogressbar -- The setbannerprogressbar statement displays progress in the toolbar banner.
- setbit( -- The setbit( function sets or clears one bit within a number, without disturbing any of the other bits.
- setcallerslocal -- The setcallerslocal statement allows a subroutine to modify a local variable in the procedure that called it.
- setcookie -- The setcookie statement set the value of a cookie to send back to the client..
- setdatabaseoptions -- The setdatabaseoptions statement modifies one or more properties of a database.
- setdefaultfloatformat -- The setdefaultfloatformat statement sets the default format for converting floating point values to text (unsupported).
- setdialogtrigger -- The setdialogtrigger statement changes the value returned by the info("dialogtrigger") function.
- setdictionaryvalue -- The setdictionaryvalue statement changes a value in a dictionary (see Data Dictionaries).
- seterror -- The seterror statement changes the error message returned by info("error").
- setfield -- The setfield statement performs an assignment, much like an equals sign or the assign statement. However, the destination field of the assignment can be calculated on the fly.
- setfieldnames -- The setfieldnames statement changes the names of all database fields at once.
- setfieldproperties -- The setfieldproperties statement modifies one or more properties (name, data type, formula, etc.) of the current field.
- setfileglobal -- The setfileglobal statement sets the value of a fileglobal variable (optionally in another database).
- setfilevariable -- The setfilevariable statement sets the value of a fileglobal variable in another database.
- setformcustompreference -- The setformcustompreference statement sets the value of a form custom preference.
- setformoptions -- The setformoptions statement modifies one or more properties of a form (name, viewing mode, etc.).
- setglobal -- The setglobal statement sets a value into a global variable. The name of the global variable is calculated on the fly.
- setglobaldictionaryvalues -- The setglobaldictionaryvalues statement sets one or more key/value pairs in a global dictionary.
- sethiddenwebformitem -- The sethiddenwebformitem statement adds a hidden field to a form on a web page.
- setlocal -- The setlocal statement sets a value into a local variable. The name of the local variable is calculated on the fly.
- setlocalsfromdictionary -- The setlocalsfromdictionary statement converts a dictionary into a collection of local variables. The names and values of the local variables will be derived from the dictionary contents.
- setparameter -- The setparameter statement is used to transfer data from a subroutine back to the main procedure that called it.
- setpermanentvariable -- The setpermanentvariable statement sets the value of a permanent variable in another database. The database must be open. An empty value will choose the currently active database.
- setpreferencevalues -- The setpreferencevalues statement creates and/or modifies a preference value.
- setprocedureoptions -- The setprocedureoptions statement modifies one or more properties of a procedure (source code, Action menu options, etc.).
- setproceduretext -- The setproceduretext statement changes the text of the currently open procedure.
- setrectangleheight( -- The setrectangleheight( function changes the height of a rectangle, leaving the width unchanged.
- setrectanglesize( -- The setrectanglesize( function changes the height and width of a rectangle, leaving the position of the top left hand corner unchanged.
- setrectanglewidth( -- The setrectanglewidth( function changes the width of a rectangle, leaving the height unchanged.
- setrectedges -- The setrectedges statement changes the edges of the specified rectangle.
- setreportcolumns -- The setreportcolumns statement allows a procedure to control the number of columns of a report, and the direction (across or down).
- settagdata -- The settagdata statement changes the contents of a tag.
- settagparameter -- The settagparameter statement sets the value of a tag parameter in a list of tag parameters.
- settimechecklongtime -- The settimechecklongtime statement sets the threshold for a slow task during a performance monitoring session.
- Setting up a Computer as a Panorama X Client -- instructions for setting up a new client computer so that it can access a Panorama X server.
- settrigger -- The settrigger statement changes the value returned by the info("trigger") function.
- setwaitinglocal -- The setwaitinglocal statement assigns a value to a local variable in the parent procedure of an asynchronous task, allowing the asynchronouse code to pass a value back to the code that spawned it.
- setwindow -- The setwindow statement specifies the dimensions (size and location) of the next window that is opened (with openform, opensheet, openprocedure etc.).
- setwindowglobal -- The setwindowglobal statement sets the value of a windowglobal variable (optionally in another window).
- setwindowoptions -- The setwindowoptions statement changes the attributes of the current window (tool bar, scroll bars, etc.).
- setwindowrectangle -- The setwindowrectangle statement specifies the dimensions of the next window that is opened by a procedure.
- setxtagvalue -- The setxtagvalue statement changes the contents of a tag.
- setzlog -- The setzlog statement turns instrumentation coverage on or off for a specific procedure (or all procedures within a database).
- sha1( -- The sha1( function calculates the SHA-1 hash of a binary or text data item.
- sha256( -- The sha256( function calculates the SHA-256 hash of a binary or text data item.
- sha512( -- The sha512( function calculates the SHA-512 hash of a binary or text data item.
- Shared Database Synchronization -- data synchronization across multiple users.
- shareddatabasebookmarkedpath( -- The shareddatabasebookmarkedpath( function retrieves the local path and filename of a server database (if any).
- sharedusers( -- The sharedusers( function returns a list of users that are currently using the specified database.
- Sharing Icon & Context Menu -- operation of the sharing icon and pop-up menu (in the toolbar).
- shellscript( -- The shellscript( function executes a UNIX shell script and returns the result.
- shellscript -- The shellscript statement executes a UNIX shell script.
- shellscriptwithterminal -- The shellscriptwithterminal statement runs a shell script in a new Terminal.app window (useful for debugging).
- shiftclick( -- The shiftclick( function returns true if the shift key was held down the last time the mouse was clicked.
- Shifting Data Left & Right -- sliding data left and right.
- shortcall -- The shortcall statement allows a procedure to call a sequence of statements within the current procedure as a "mini-subroutine".
- shortstandardviewmenu( -- The shortstandardviewmenu( function generates a Live Menu specification for a truncated version of Panorama’s standard View menu.
- show -- The show statement resumes the output of text and graphics after it has been disabled and then forces Panorama to redisplay all windows in the current database.
- showaccessorypanel -- The showaccessorypanel statement opens the current window's accessory panel.
- showallfields -- The showallfields statement makes every field in the data sheet visible.
- showcolumns -- The showcolumns statement forces Panorama to display specified fields.
- showfields -- The showfields statement forces Panorama to display specified fields.
- showfieldsbetween -- The showfieldsbetween statement hides all fields except those in between specified numbers.
- showhidefieldsdialog -- The showhidefieldsdialog statement opens the standard Show/Hide Fields dialog (in the Fields menu).
- showlater -- The showlater statement defers the display of text and graphics until the procedure is finished.
- showline -- The showline statement forces Panorama to redisplay the current record in all windows in the current database.
- showother -- The showother statement forces Panorama to update some data on the screen.
- showpage -- The showpage statement forces Panorama to redisplay all windows in the current database.
- showrecordcounter -- The showrecordcounter statement forces Panorama to redisplay the record counter in all windows in the current database.
- showrectangle -- The showrectangle statement refreshes all or part of the current form window.
- showthesefields -- The showthesefields statement makes specific fields in the data sheet visible, hiding all others.
- showvariables -- The showvariables statement forces Panorama to update the display of one or more variables on every form in the active database.
- showwindowvariables -- The showwindowvariables statement forces Panorama to update the display of one or more variables in the currently active form.
- signedbinaryvalue( -- The signedbinaryvalue( function converts binary data (a byte, word, longword, or longlongword) into a signed number (see Binary Data).
- sin( -- The sin( function calculates the sine of an angle.
- sinh( -- The sinh( function calculates the hyperbolic sine of a numeric value.
- size -- The size statement changes the data sheet text size.
- sizeof( -- The sizeof( function calculates the amount of memory used by a field or a variable.
- slidedata -- The slidedata statement slides the columns at and to the right of the current column.
- Slider Object -- is used to create sliders and knobs.
- Smart Dates -- keyboard entry of dates.
- Smart Resize -- adjusts the sizes and locations of the other selected objects to match the change of one object.
- snip( -- The snip( function removes (snips!) one or more characters from the middle of an item of text.
- sortdialog -- The sortdialog statement opens the standard Sort dialog.
- sortdown -- The sortdown statement sorts the database by the current field. The database is sorted in descending order (high to low).
- sortdownwithin -- The sortdownwithin statement sorts the database by the current field, leaving any previous sorts intact. The database is sorted in descending order (high to low).
- Sorting Data -- sorting data into a specific order.
- sortup -- The sortup statement sorts the database by the current field. The database is sorted in ascending order (low to high).
- sortupwithin -- The sortupwithin statement sorts the database by the current field, leaving any previous sorts intact. The database is sorted in ascending order (low to high).
- soundduration( -- The soundduration( function returns the duration (in seconds) of the specified playing sound.
- sounddurationhhmmss( -- The sounddurationhhmmss( function returns the duration (in hours:minutes:seconds) of the specified playing sound.
- soundex( -- The soundex( function computes a four character code that roughly corresponds to the phonetic pronunciation of the word.
- soundinfo( -- The soundinfo( function returns a dictionary that contains all of the properties of a sound.
- soundplaying( -- The soundplaying( function returns true if the specified sound is currently playing, false if it is paused or not playing at all.
- soundposition( -- The soundposition( function returns the current playback position (in seconds) of the specified playing sound.
- soundpositionhhmmss( -- The soundpositionhhmmss( function returns the current playback position (in hours:minutes:seconds) of the specified playing sound.
- soundprogress( -- The soundprogress( function returns the progress of the played sound from 0 to 1.
- soundslike -- The soundslike operator compares two words to see if they "sound like" each other.
- soundstatus( -- The soundstatus( function returns the status of the specified sound: stopped, playing or paused.
- soundvolume( -- The soundvolume( function returns the current volume of the specified playing sound.
- Source Menu -- used to assist in editing program code.
- speak -- The speak statement speaks a word or phrase.
- speakaddress -- The speakaddress statement buffers up a street address to be spoken later by the speaknow statement.
- speakcharacters -- The speakcharacters statement buffers up one or more characters to be spoken later by the speaknow statement.
- speakcharactersslowly -- The speakcharactersslowly statement buffers up one or more characters to be spoken later by the speaknow statement. Instead of speaking words, each individual character is spoken separately and slowly.
- speakdate -- The speakdate statement buffers up a date to be spoken later by the speaknow statement.
- speakdigitpairs -- The speakdigitpairs statement buffers up one or more digit pairs to be spoken later by the speaknow statement.
- speakdigits -- The speakdigits statement buffers up one or more digits to be spoken later by the speaknow statement.
- speakdollars -- The speakdollars statement buffers up a dollar amount to be spoken later by the speaknow statement.
- speakdollarsandcents -- The speakdollarsandcents statement buffers up a dollar and cents amount to be spoken later by the speaknow statement.
- speakletters -- The speakletters statement buffers up one or more characters to be spoken later by the speaknow statement. Letters will be spoken individually, as upper or lower case. Numbers will be spoken as individual digits.
- speaknow -- The speaknow statement speaks any buffered speech.
- speakphonenumber -- The speakphonenumber statement buffers up a phone number to be spoken later by the speaknow statement.
- speakscript -- The speakscript statement speaks a speech synthesis script created in the Database Options dialog.
- speakstate -- The speakstate statement buffers up a US State to be spoken later by the speaknow statement.
- speakthisrecord -- The speakthisrecord statement speaks the current record in the database (using the default speech script).
- speakwords -- The speakwords statement buffers up one or more words to be spoken later by the speaknow statement.
- specialkey( -- The specialkey( function returns the unicode value for special keys on the keyboard.
- Speech Programming -- using program code to convert data to speech (voice).
- speechrate -- The speechrate statement changes the speech rate (words per minute).
- speechscripts -- The speechscripts statement returns a lists of speech scripts in a database.
- speechvoice -- The speechvoice statement changes the default speech voice.
- speechvolume -- The speechvolume statement changes the default speech volume.
- speedcopy -- The speedcopy statement copies multiple adjacent fields from a record in one database to a record in another.
- splitfielddialog -- The splitfielddialog statement opens the standard Split Field dialog.
- splitlines -- The splitlines statement takes a chunk of text and splits it into two or more smaller chunks.
- splitmenutrigger -- The splitmenutrigger statement splits info("trigger") into separate menu name and menu item variables.
- Splitting a Field -- splitting a field into two fields.
- sqr( -- The sqr( function calculates the square root of a value.
- standardactionmenu( -- The standardactionmenu( function generates a Custom Menu specification for Panorama's standard Action menu.
- standardclassicsetupmenu( -- The standardclassicsetupmenu( function generates a customizable Custom Menu specification for Panorama's classic Setup menu.
- standardconstructgraphicsmenu( -- The standardconstructgraphicsmenu( function generates a Custom Menu specification for Panorama’s standard Construct menu (in Graphics Mode).
- standardeditmenu( -- The standardeditmenu( function generates a customizable Custom Menu specification for Panorama's standard Edit menu.
- standardfieldsmenu( -- The standardfieldsmenu( function generates a customizable Custom Menu specification for Panorama's standard Fields menu.
- standardfilemenu( -- The standardfilemenu( function generates a customizable Custom Menu specification for Panorama's standard File menu.
- standardhelpmenu( -- The standardhelpmenu( function generates a customizable Custom Menu specification for Panorama's standard Help menu.
- standardinstrumentationmenu( -- The standardinstrumentationmenu( function generates a Custom Menu specification for Panorama’s standard Instrumentation menu.
- standardpanoramamenu( -- The standardpanoramamenu( function generates a Custom Menu specification for Panorama's standard Panorama menu.
- standardrecordsmenu( -- The standardrecordsmenu( function generates a customizable Custom Menu specification for Panorama's standard Records menu.
- standardsearchmenu( -- The standardsearchmenu( function generates a customizable Custom Menu specification for Panorama's standard Search menu.
- standardsetupmenu( -- The standardsetupmenu( function generates a customizable Custom Menu specification for Panorama's standard Setup menu.
- standardsortmenu( -- The standardsortmenu( function generates a customizable Custom Menu specification for Panorama's standard Sort menu.
- standardtextmenu( -- The standardtextmenu( function generates a customizable Custom Menu specification for Panorama's standard Text menu.
- standardviewmenu( -- The standardviewmenu( function generates a Custom Menu specification for Panorama's standard View menu.
- standardwindowmenu( -- The standardwindowmenu( function generates a customizable Custom Menu specification for Panorama's standard Window menu.
- standardwizardsmenu( -- The standardwizardsmenu( function generates a Custom Menu specification for Panorama's standard Wizards menu.
- Star Object -- draws a star within a form.
- startbonjour -- The startbonjour statement starts monitoring the local network for available hosts.
- startdatabasechange -- The startdatabasechange statement adds undo support to a procedure.
- startfilesystemmonitor -- The startfilesystemmonitor statement sets up and starts a repeating task that will be performed whenever a file and/or folder is modified.
- startgraphicschange -- The startgraphicschange statement adds undo support to a procedure.
- startnewdatabasegeneration -- The startnewdatabasegeneration statement starts a new generation of the current database to the server (must be a shared database).
- startstoprecorder -- The startstoprecorder statement starts or stops recording into the current procedure.
- starttimecheck -- The starttimecheck statement starts a performance monitoring session.
- starttimer -- The starttimer statement sets up and starts a repeating task that will be performed periodically when Panorama is not otherwise busy.
- startupdatecheck -- The startupdatecheck statement starts background check for available Panorama update.
- stashwebformitems -- The stashwebformitems statement takes the variables created with the GrabWebFormItems statement and assigns them to fields in the current record.
- state( -- The state( function returns the name of the state associated with a US zip code.
- stateabbreviations( -- The stateabbreviations( function returns a list of US state abbreviations.
- statelookup( -- The statelookup( function converts a two letter abbreviation for a US state into the full state name.
- Statements -- index of all statements available for use in Panorama procedures.
- statename( -- The statename( function converts a two letter abbreviation for a US state into the full state name.
- statusmessage -- The statusmessage statement displays a message in the status bar at the bottom of the procedure window.
- stdout -- The stdout statement sends one or more characters to standard output.
- Stepper Object -- is used to create numeric steppers for use with Text Editor objects.
- stop -- The stop statement stops all running procedures immediately.
- stopalert -- The stopalert statement displays a modal alert window with a warning icon, a message and one or more buttons.
- stopbonjour -- The stopbonjour statement cancels monitoring of the local network for available hosts.
- stopfilesystemmonitor -- The stopfilesystemmonitor statement stops a repeating task that has been set up to be performed whenever a file and/or folder is modified.
- stoploopif -- The stoploopif statement decides whether to continue with a loop or to exit the loop immediately.
- stopposixtask -- The stopposixtask statement stops a POSIX shell script that is running in the background.
- stopspeaking -- The stopspeaking statement stops any talking that is currently happening.
- stoptimer -- The stoptimer statement stops and deletes a timer that was set up with the StartTimer statement.
- str( -- The str( function converts a number into text, with no formatting.
- straightquotes( -- The straightquotes( function converts any "smart quotes" in the text into straight quotes.
- stringreverse( -- The stringreverse( function reverses the order of a string of text characters.
- stringreverse -- The stringreverse statement reverses the characters in a string of text. The original text is replaced in situ.
- strip( -- The strip( function strips off leading and trailing blanks and other whitespace (carriage returns, tabs, etc.)
- stripaccents( -- The stripaccents( function removes accents from any characters in the text.
- stripchar( -- The stripchar( function extracts characters you don't want from a text item.
- stripdiacriticals( -- The stripdiacriticals( function strips diacritical marks from text.
- striphtmltags( -- The striphtmltags( function removes all HTML tags from the text.
- stripprintable( -- The stripprintable( function strips non-printable characters from text.
- striptoalpha( -- The striptoalpha( function removes everything but alphabetic letters from a text item.
- striptonum( -- The striptonum( function removes everything but numeric digits from a text item.
- subfolder( -- The subfolder( function returns the folder id of a subfolder of a specified folder
- submenu( -- The submenu( function creates a submenu (see Custom Menus).
- subpath( -- The subpath( function returns the HFS path of a subfolder of a specified folder.
- Subroutines -- writing code that can be called from other code.
- sum( -- The sum( function adds up all instances of a line item field in the current record.
- Summarize & Analyze Dialog -- is a one stop dialog for creating and filling in summary records based on pre-selected criteria.
- Summarize & Analyze Favorites -- saving and recalling favorite summaries.
- Summary Records -- are temporary records used for calculating totals, subtotals, and other summary information.
- Summary Workshop -- tool for quickly summarizing, analyzing and charting large amounts of data.
- summarydatabaseselectoriginal -- The summarydatabaseselectoriginal statement selects original data corresponding to a cell in an exported summary table database.
- summarylevel -- The summarylevel statement changes the summary level of the current line.
- summaryselectoriginalformula -- The summaryselectoriginalformula statement returns the formula that will select the original data associated with a summary table row.
- summarytable( -- The summarytable( function scans a database to build a text array containing summary breakdown information: totals, averages, etc.
- summarytablepopup -- The summarytablepopup statement handles a click on a summary table text list.
- superalert -- The superalert statement will display a custom alert.
- superarraybuild -- The superarraybuild statement scans a database to create a text array. This statement is is similar to arraybuild, but with a number of additional options (see Text Arrays).
- superchoicedialog -- The superchoicedialog statement will display a dialog with a list of choices that can be selected. You can control the size of the alert, as well as several appearance options. If the alert has more than one button, info("dialogtrigger") will contain the name of the button that was pressed.
- superdate( -- The superdate( function converts a regular date and a regular time into a superdate.
- superdatepattern( -- The superdatepattern( function converts a number containing a superdate to text, allowing you to specify the patterns for both the date and the time conversion to text.
- SuperDates -- date and time combined into a single value.
- superdatesecondsstr( -- The superdatesecondsstr( function converts a number containing a superdate to text, including the seconds.
- superdatestr( -- The superdatestr( function converts a number containing a superdate (date + time) to text.
- superdateunixtime( -- The superdateunixtime( function converts a Panorama superdate into a 13 digit UNIX epoch date/time (including milliseconds).
- supergetpassword -- The supergetpassword statement will display a dialog with a text entry area for a password.
- supergettext -- The supergettext statement will display a dialog with a text entry area.
- superlookup( -- The superlookup( function searches a database for a record that matches a query formula, then uses a second formula to return other information from the same record. This is similar to the lookup( function, but instead of using an individual field for the key and data, any valid true/false (Boolean) formula can be used.
- supernow( -- The supernow( function returns the number representing the current date and time as a superdate.
- Suppressing Display -- temporarily disabling display of changes in a program (to reduce "flickering" and increase performance).
- switch( -- The switch( function chooses from a list of values.
- switchmatch( -- The switchmatch( function chooses from a list of values based on a wildcard match.
- switchmatchexact( -- The switchmatchexact( function chooses from a list of values based on a wildcard match.
- synchronize -- The synchronize statement synchronizes the local database with Panorama Server. This is the same as choosing Synchronize from the File menu.
- synchronizeall -- The synchronizeall statement synchronizes all open databases.
- Synchronizing in Procedure Code -- customizing the data synchronization process.
- System Info Functions -- find out information about the current status of the computer and operating system.
- Tab Panel Appearance -- appearance options for a Tab Panel Object.
- Tab Panel Buttons and Selection -- button options for a Tab Panel Object.
- Tab Panel Constructor -- quickly creating a Tab Panel Object from a template.
- Tab Panel Content -- setting up the content for a Tab Panel Object.
- Tab Panel Forms -- setting up the forms for a Tab Panel Object.
- Tab Panel Object -- switchable tab panels.
- tab( -- The tab( function generates a tab.
- tabarray( -- The tabarray( function extracts the nth element from a tab delimited array.
- table( -- The table( function searches a database for a value, then returns other information from the same record. Unlike the lookup( function, the table( function does not require an exact match. If it does not find an exact match the table( function will use the closest match. For example, the table( function can look up a tax rate given an income amount, or look up a shipping price given a zip code and weight.
- Tag Parsing -- Panorama functions for working with text that contains data delimited by tags, including HTML.
- tagarray( -- The tagarray( function builds an array (see Text Arrays) containing the body of all the specified tags (usually HTML tags) in the text.
- tagcount( -- The tagcount( function counts the number of times a specified tag (usually an HTML tag) appears in the text. See Tag Parsing for more information on HTML tags.
- tagdata( -- The tagdata( function extracts the body of the specified tag (usually an HTML tag) in the text. See Tag Parsing for more information on HTML tags.
- tagend( -- The tagend( function returns the ending position of the specified tag (usually an HTML tag) in the text.
- tagnumber( -- The tagnumber( function checks to see if a specified position is inside of a tag (usually an HTML tag).
- tagparameter( -- The tagparameter( function extracts the value of a tag parameter embedded in some text, where the tag parameter takes the form name=value.
- tagparameterarray( -- The tagparameterarray( function extracts the value of multiple tag parameters embedded in some text, where each tag parameter takes the form name=value.
- tagstart( -- The tagstart( function returns the starting position of the specified tag (usually an HTML tag) in the text.
- tagstrip( -- The tagstrip( function removes tags (usually HTML tags) from within a piece of text.
- tallmessage -- The tallmessage statement displays a message alert.
- tan( -- The tan( function calculates the tangent of an angle.
- tanh( -- The tanh( function calculates the hyperbolic tangent of a numeric value.
- tc24to30( -- The tc24to30( function converts 24 frame timecode to 30 frame non-drop timecode.
- tc30to24( -- The tc30to24( function converts 30 frame non-drop timecode to 24 frame timecode.
- tcadd( -- The tcadd( function accepts a timecode as text, and adds some number of frames, returns a timecode string.
- tcdiff( -- The tcdiff( function calculates the number of frames between two timecodes.
- tcframes( -- The tcframes( function returns a number of frames from zero of a 24fps, 25fps, or 30fps timecode.
- tempfolder( -- The tempfolder( function returns the path to the current user's temporary folder (for files you plan to use only for a short time).
- Temporarily Disconnecting a Shared Database from the Server -- pause database sharing.
- Text Arrays -- A numbered collection of text values.
- Text Display Object -- is used to display text using a formula.
- Text Display Programming -- programming a Text Display Object.
- Text Editor Object -- is used to edit text in a field or variable.
- Text Editor Programming -- programming a Text Editor Object.
- Text Export Wizard -- custom exports into a text or HTML file.
- Text Export -- exporting a database into a text or HTML file.
- Text Formulas -- manipulating text with a formula (concatenation, extraction, rearranging, etc.)
- Text Funnels -- Text funnels strip off the beginning and/or end of a text string based on your specifications.
- Text Import -- importing text into an existing database.
- Text Label Object -- displays a short, fixed, text item within a form.
- Text List Appearance -- customizing the appearance of a Text List Object.
- Text List Constructor -- quickly creating a Text List Object from a template.
- Text List Database Integration -- synchronizing a Text List Object with a database.
- Text List Multiple Columns -- displaying multiple columns in a Text List Object
- Text List Object -- displaying a grid of text.
- Text List Programming -- programming a Text List Object.
- Text List Searching -- searching within a Text List Object.
- Text List Selection -- selecting items in a Text List Object.
- Text Object Background Color/Gradient -- text object background colors and gradients.
- Text Search Options -- searching text within a database.
- textafter( -- The textafter( function extracts the text after the tag.
- textbefore( -- The textbefore( function extracts the text before the tag.
- textdisplay( -- The textdisplay( function works with Text Display Objects to control the color and style of text on the fly.
- textfilter( -- The textfilter( function scans and filters text on a character by character basis.
- textlisttableoptions -- The textlisttableoptions statement sets up text list table options
- textstuff( -- The textstuff( function replaces one or more characters in the middle of a piece of text.
- texttimedifference( -- The texttimedifference( function allows time math to be performed on text values.
- texttimeinterval( -- The texttimeinterval( function allows time math to be performed on text values.
- texttobinary( -- The texttobinary( function converts text into binary data, optionally using a specified encoding.
- throwerror -- The throwerror statement causes an immediate error.
- tildepath( -- The tildepath( function converts a path in the current user's folder to tilde (~) notation.
- Tiles In Action -- basic rules for using tiles to print custom reports.
- Time Arithmetic Formulas -- performing calculations on times, and converting between times and text.
- time( -- The time( function converts text into a number representing a time.
- time24( -- The time24( function takes a time and makes sure it falls within a 24 hour period.
- timecheck -- The timecheck statement identifies an intermediate point in a performance monitoring session.
- timecode( -- The timecode( function returns a timecode string corresponding to an integer.
- timedifference( -- The timedifference( function calculates the difference between two times. It works correctly even if the interval between the two times crosses over midnight.
- timeinterval( -- The timeinterval( function calculates the time interval between two times. It works correctly even if the interval between the two times crosses over midnight.
- timelimit -- The timelimit statement specifies the maximum time a procedure can continue to run after this statement.
- timepattern( -- The timepattern( function converts a number representing a time into text. The function uses a pattern to control how the time is formatted.
- Timer Workshop -- provides a tool for monitoring timers and testing timer configurations.
- timerexists( -- The timerexists( function checks to see whether a timer exists.
- timerinfo( -- The timerinfo( function returns a dictionary that contains all of the properties of a timer.
- Timers -- executing recurring periodic background code at fixed intervals.
- timestampstr( -- The timestampstr( function generates a time stamp string. the format is yyyy.mm.dd.hh.mm.ss.sss. the last three digits are in milliseconds (though this value is only accurate to 1/60th of a second).
- timestr( -- The timestr( function converts a number to text in am/pm time format.
- timezoneabbreviation( -- The timezoneabbreviation( function returns the abbreviation of the specified time zone.
- timezonename( -- The timezonename( function returns the continent and city of the specified time zone.
- titlecase( -- The titlecase( function capitalizes first character of each word, but not articles, prepositions, and conjunctions under 5 characters (unless they are the first or last word in the text).
- today( -- The today( function returns a number corresponding to today's date.
- toggleaccessorypanel -- The toggleaccessorypanel statement opens and closes the current window's accessory panel.
- tokenname( -- The tokenname( function returns the name of a field or variable (instead of the value contained in the field or variables).
- Toolbars -- using and customizing window toolbars.
- topdatawindow -- The topdatawindow statement brings the topmost data window in the specified database to the front.
- total -- The total statement calculates totals and subtotals for the current field.
- Transforming Data -- using program code to modify data in bulk.
- Triggers -- finding out what event triggered the execution of program code.
- trim( -- The trim( function removes characters from the right edge of the text.
- trimleft( -- The trimleft( function removes one or more characters from the left edge of the text.
- trimstart( -- The trimstart( function removes one or more characters from the start of the text.
- true( -- The true( function returns true.
- True/False Formulas -- logical boolean calculations.
- try -- The try statement works with catch and endcatch to trap errors in a sequence of statements.
- tsvtocsv( -- The tsvtocsv( function converts tab separated text into comma separated text.
- tsvtojson( -- The tsvtojson( function converts tab separated text into JSON formatted text.
- tweakobject -- The tweakobject statement tweaks the dimensions of an object (or multiple objects).
- typecreatorcode( -- The typecreatorcode( function returns the 8 character TYPE and CREATOR codes for a filename (if any).
- uncloakeddatabasename( -- The uncloakeddatabasename( function converts the internal server name of a database to the regular "uncloaked" name.
- uncompress -- The uncompress statement uncompresses a `.zip`, `.tar.gz` or `.tar.bz2` file into a file or an entire folder.
- undefine -- The undefine statement destroys one or more variables.
- undefinefileglobal -- The undefinefileglobal statement destroys one or more fileglobal variables.
- undefineglobal -- The undefineglobal statement destroys one or more global variables.
- undefineservervariable -- The undefineservervariable statement destroys a server variable.
- undefinewindowglobal -- The undefinewindowglobal statement destroys one or more windowglobal variables.
- Under Construction -- Nothing to see here, move along.
- Understanding the Run Loop -- explanation of how Panorama code interacts with the run loop to respond to mouse clicks, keyboard presses, display updates and other events that require attention.
- Undo -- using the Undo command to reverse one or more recent actions.
- Unimplemented Statements and Functions -- Unimplemented Statements & Functions
- unionrectangle( -- The unionrectangle( function creates a rectangle by combining two rectangles. The new rectangle is large enough to exactly cover both of the input rectangles.
- uniqueid( -- The uniqueid( function generates ID codes with a text root and a numeric suffix (for example `Jeff261`).
- unixpath( -- The unixpath( function converts an HFS path into a UNIX path.
- unixshellpath( -- The unixshellpath( function converts a path and filename into a POSIX path that can be embedded within the shellscript statement.
- unixshellstring( -- The unixshellstring( function encodes text for use as a parameter to a unix shell command.
- unixtimesuperdate( -- The unixtimesuperdate( function converts a 13 digit UNIX epoch date/time (including milliseconds) into a Panorama superdate.
- unlockrecord -- The unlockrecord statement unlocks the currently active record.
- unpermanent -- The unpermanent statement converts one or more permanent variables into regular fileglobal variables. The variables will no longer be saved as part of the database.
- unpropagate -- The unpropagate statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.
- unpropagateup -- The unpropagateup statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the last (bottom) value.
- until -- The until statement is used at the end of a loop, and can control how many times the loop is executed.
- updateballoonlocations -- The updateballoonlocations statement does nothing.
- Updated -- List of features that have been improved since Panorama 6.
- Updating Panorama X -- checking for and installing newer versions of Panorama X.
- updatingwindow( -- The updatingwindow( function returns true if in a formula that is being displayed on a form, otherwise false.
- uploaddatatoserver -- The uploaddatatoserver statement uploads binary data to the server.
- uploadfiletoserver -- The uploadfiletoserver statement uploads a file or folder to a Panorama server.
- Uploading to the Panorama Database Exchange -- uploading databases to the Panorama Database Exchange.
- uploadnewdatabasegeneration -- The uploadnewdatabasegeneration statement uploads a new generation of the current database to the server (must be a shared database).
- uploadrecord -- The uploadrecord statement uploads the current record to the server, even if it was not locked (for emergency use only).
- upper( -- The upper( function converts text to UPPER CASE (all caps).
- upperword( -- The upperword( function converts text to Initial Caps.
- uprecord -- The uprecord statement moves the cursor up one visible record.
- URL Tool Menu (Web Debugging) -- tool with popup menu to assist with debugging web procedures.
- url( -- The url( function synchronously loads a resource from the internet.
- urldecode( -- The urldecode( function decodes text that contains percent encoded characters.
- urlencode( -- The urlencode( function converts text into a legal URL (by converting spaces into `%20`). WARNING: THIS FUNCTION IS OBSOLETE.
- urlfilename( -- The urlfilename( function extracts the filename from a complete url.
- urlpath( -- The urlpath( function extracts the path from a URL.
- urltask( -- The urltask( function asynchronously loads a resource from the internet.
- urltaskcancel -- The urltaskcancel statement aborts a download initiated with the urltask( function.
- urltaskstatus -- The urltaskstatus statement enables connection error checking in urltask( completion code.
- usebashprofile -- The usebashprofile statement grabs the search path from the `.Bash_profile` file in the user's home folder, so that these paths will be used by scripting languages (Ruby, Python, etc.).
- usecallerslocalvariables -- The usecallerslocalvariables statement temporarily swaps out a subroutine's current local variables with the local variables of the procedure that called this subroutine. The statement can be used only in a subroutine, not in a calling procedure.
- usefunctioncallerslocalvariables -- The usefunctioncallerslocalvariables statement temporarily swaps out a procedures current local variables with the local variables of the procedure that called this the call(, callwithin( or execute( function.
- usemylocalvariables -- The usemylocalvariables statement reverses the action of the UseCallersLocalVariables statement, switching back to the current procedure's normal local variables.
- Using an External Web Server -- instructions for using Panorama Server in conjunction with an external web server (for example Apache, Nginx, etc.).
- Using Fields in a Formula -- accessing database fields within a formula.
- Using Panorama X with Internet Monitoring Software -- configuring network mintoring/blocking software (Little Snitch, Hands Off, etc.) for proper Panorama X operation.
- uspssecondaryunits( -- The uspssecondaryunits( function returns a list of USPS (United States Postal Service) secondary suffix designation abbreviations.
- uspsstreetsuffixes( -- The uspsstreetsuffixes( function returns a list of USPS street suffix abbreviations.
- utf8tomac( -- The utf8tomac( function translates text from UTF8 (Unicode) into Panorama's native text format.
- utf8tomac -- The utf8tomac statement translates text from UTF8 (Unicode) to Panorama format.
- v( -- The v( function returns the vertical position of a point (see point(, Graphic Coordinates).
- val( -- The val( function converts text into a number.
- validnumber( -- The validnumber( function checks to see if a numeric value is valid.
- Values -- the raw material that formulas work with -- numbers and text.
- Variable Height Records -- custom reports with different heights for each record.
- Variables -- storing and retrieving individual items of data, not part of a database.
- Version 0.1.001 (released July 7th, 2012) -- Summary of Version 0.1.001 (released 7/7/2012)
- Version 0.1.002 (released August 12th, 2012) -- Summary of Version 0.1.002 (released 8/12/2012)
- Version 0.1.003 (released December 2nd, 2012) -- Summary of Version 0.1.003 (released 12/2/2012)
- Version 0.1.004 (released December 10th, 2012) -- Summary of Version 0.1.004 (released 12/10/2012)
- Version 0.1.005 (released December 21st, 2012) -- Summary of Version 0.1.005 (released 12/21/2012)
- Version 0.1.006 (released December 26th, 2012) -- Summary of Version 0.1.006 (released 12/26/2012)
- Version 0.1.007 (released May 1st, 2013) -- Summary of Version 0.1.007 (released 5/1/2013)
- Version 0.1.008 (released May 22nd, 2013) -- Summary of Version 0.1.008 (released 5/22/2013)
- Version 0.1.009 (released July 9th, 2013) -- Summary of Version 0.1.009 (released 7/9/2013)
- Version 0.1.010 (released October 14th, 2013) -- Summary of Version 0.1.010 (released 10/14/2013)
- Version 0.1.011 (released December 6th, 2013) -- Summary of Version 0.1.011 (released 12/6/2013)
- Version 0.1.012 (released August 29th, 2015) -- Summary of Version 0.1.012 (released 8/29/2015)
- Version 0.1.013 (released September 6th, 2015) -- Summary of Version 0.1.013 (released 9/6/2015)
- Version 0.1.014 (released September 14th, 2015) -- Summary of Version 0.1.014 (released 9/14/2015)
- Version 0.1.015 (released September 29th, 2015) -- Summary of Version 0.1.015 (released 9/29/2015)
- Version 0.1.016 (released October 12th, 2015) -- Summary of Version 0.1.016 (released 10/12/2015)
- Version 0.1.017 (released November 11th, 2015) -- Summary of Version 0.1.017 (released 11/11/2015)
- Version 0.1.018 (released December 7th, 2015) -- Summary of Version 0.1.018 (released 12/7/2015)
- Version 0.1.019 (released January 28th, 2016) -- Summary of Version 0.1.019 (released 1/28/2016)
- Version 0.1.020 (released February 15th, 2016) -- Summary of Version 0.1.020 (released 2/15/2016)
- Version 0.1.021 (released February 29th, 2016) -- Summary of Version 0.1.021 (released 2/29/2016)
- Version 0.1.022 (released March 1st, 2016) -- Summary of Version 0.1.022 (released 3/1/2016)
- Version 0.1.023 (released May 27th, 2016) -- Summary of Version 0.1.023 (released 5/27/2016)
- Version 0.1.024 (released June 12th, 2016) -- Summary of Version 0.1.024 (released 6/12/2016)
- Version 0.1.025 (released July 21st, 2016) -- Summary of Version 0.1.025 (released 7/21/2016)
- Version 0.1.026 (released August 29th, 2016) -- Summary of Version 0.1.026 (released 8/29/2016)
- Version 0.1.027 (released September 18th, 2016) -- Summary of Version 0.1.027 (released 9/18/2016)
- Version 0.1.028 (released November 9th, 2016) -- Summary of Version 0.1.028 (released 11/9/2016)
- Version 0.1.029 (released December 31st, 2016) -- Summary of Version 0.1.029 (released 12/31/2016)
- Version 0.1.030 (released February 12th, 2017) -- Summary of Version 0.1.030 (released 2/12/2017)
- Version 0.1.031 (released March 3rd, 2017) -- Summary of Version 0.1.031 (released 3/3/2017)
- Version 0.1.032 (released April 3rd, 2017) -- Summary of Version 0.1.032 (released 4/3/2017)
- Version 0.9 (released May 15th, 2017) -- Summary of Version 0.9 (released 5/15/2017)
- Version 0.9.001 (released July 18th, 2017) -- Summary of Version 0.9.001 (released 7/18/2017)
- Version 0.9.002 (released July 27th, 2017) -- Summary of Version 0.9.002 (released 7/27/2017)
- Version 0.9.003 (released September 10th, 2017) -- Summary of Version 0.9.003 (released 9/10/2017)
- Version 0.9.004 (released September 14th, 2017) -- Summary of Version 0.9.004 (released 9/14/2017)
- Version 0.9.005 (released September 19th, 2017) -- Summary of Version 0.9.005 (released 9/19/2017)
- Version 0.9.006 (released September 27th, 2017) -- Summary of Version 0.9.006 (released 9/27/2017)
- Version 0.9.007 (released October 3rd, 2017) -- Summary of Version 0.9.007 (released 10/3/2017)
- Version 0.9.008 (released October 12th, 2017) -- Summary of Version 0.9.008 (released 10/12/2017)
- Version 10.0.0 (released October 18th, 2017) -- Summary of Version 10.0.0 (released 10/18/2017)
- Version 10.0.01 (released December 10th, 2017) -- Summary of Version 10.0.01 (released 12/10/2017)
- Version 10.1 (released August 6th, 2018) -- Summary of Version 10.1 (released 8/6/2018)
- Version 10.1.1 (released August 30th, 2018) -- Summary of Version 10.1.1 (released 8/30/2018)
- Version 10.1.2 (released November 15th, 2018) -- Summary of Version 10.1.2 (released 11/15/2018)
- Version 10.2 (released November 25th, 2024) -- Summary of Version 10.2 (released 11/25/2024)
- Version 10.2.0 b12 (released January 27, 2021) -- Summary of Version 10.2.0 b12 (released 01/27/2021)
- Version 10.2.0 b13 (released February 15, 2021) -- Summary of Version 10.2.0 b13 (released 02/15/2021)
- Version 10.2.0 b14 (released March 14, 2021) -- Summary of Version 10.2.0 b14 (released 03/14/2021)
- Version 10.2.0 b15 (released March 30, 2021) -- Summary of Version 10.2.0 b15 (released 03/30/2021)
- Version 10.2.0 b16 (released April 27, 2021) -- Summary of Version 10.2.0 b16 (released 04/27/2021)
- Version 10.2.0 b17 (released June 23, 2021) -- Summary of Version 10.2.0 b17 (released 06/23/2021)
- Version 10.2.0 b18 (released July 21, 2021) -- Summary of Version 10.2.0 b18 (released 07/21/2021)
- Version 10.2.0 b20 (released August 26, 2021) -- Summary of Version 10.2.0 b20 (released 08/26/2021)
- Version 10.2.0 b21 (released September 20, 2021) -- Summary of Version 10.2.0 b21 (released 09/20/2021)
- Version 10.2.0 b22 (released October 6, 2021) -- Summary of Version 10.2.0 b22 (released 10/06/2021)
- Version 10.2.0 b23 (released October 20, 2021) -- Summary of Version 10.2.0 b23 (released 10/20/2021)
- Version 10.2.0 b24 (released October 21, 2021) -- Summary of Version 10.2.0 b24 (released 10/21/2021)
- Version 10.2.0 b25 (released December 10, 2021) -- Summary of Version 10.2.0 b25 (released 12/10/2021)
- Version 10.2.0 b26 (released June 15, 2022) -- Summary of Version 10.2.0 b26 (released 06/15/2022)
- Version 10.2.0 b27 (released August 11, 2022) -- Summary of Version 10.2.0 b27 (released 08/11/2022)
- Version 10.2.0 b28 (released August 23, 2022) -- Summary of Version 10.2.0 b28 (released 08/23/2022)
- Version 10.2.0 b29 (released September 13, 2022) -- Summary of Version 10.2.0 b29 (released 09/13/2022)
- Version 10.2.0 b30 (released October 30, 2022) -- Summary of Version 10.2.0 b30 (released 10/30/2022)
- Version 10.2.0 b31 (released January 16, 2023) -- Summary of Version 10.2.0 b31 (released 01/16/2023)
- Version 10.2.0 b32 (released January 21, 2023) -- Summary of Version 10.2.0 b32 (released 01/21/2023)
- Version 10.2.0 b33 (released April 30, 2023) -- Summary of Version 10.2.0 b33 (released 04/30/2023)
- Version 10.2.0 b34 (released October 27, 2023) -- Summary of Version 10.2.0 b34 (released 10/27/2023)
- Version 10.2.0 b35 (released December 4, 2023) -- Summary of Version 10.2.0 b35 (released 12/4/2023)
- Version 10.2.0 b36 (released December 25, 2023) -- Summary of Version 10.2.0 b36 (released 12/25/2023)
- Version 10.2.0 b37 (released January 11, 2024) -- Summary of Version 10.2.0 b37 (released 1/11/2024)
- Version 10.2.0 b38 (released April 7, 2024) -- Summary of Version 10.2.0 b38 (released 4/7/2024)
- Version 10.2.0 b39 (released June 26, 2024) -- Summary of Version 10.2.0 b39 (released 06/26/2024)
- Version 10.2.0 b40 (released October 1, 2024) -- Summary of Version 10.2.0 b40 (released 10/01/2024)
- Version 10.2.0 b41 (released October 20, 2024) -- Summary of Version 10.2.0 b41 (released 10/20/2024)
- Version 10.2.0 b42 (released November 11, 2024) -- Summary of Version 10.2.0 b42 (released 11/11/2024)
- Version 10.2.0 b43 (released November 23, 2024) -- Summary of Version 10.2.0 b43 (released 11/23/2024)
- Version 10.2.1 (released January 19, 2025) -- Summary of Version 10.2.1 (released 01/19/2025)
- Version 10.2.2 (released August 8th, 2025) -- Summary of Version 10.2.2 (released 8/8/2025)
- View Menu -- accessing and creating the data sheet, forms and procedures.
- View Organizer -- rearranging, copying and deleting views.
- View Search -- persistent, comprehensive search of procedures and forms in one or multiple databases.
- View-As-List Forms -- displaying a custom data layout as a continuous sheet.
- views( -- The views( function lists views in open databases.
- visiblefieldnumbers( -- The visiblefieldnumbers( function returns a data array of visible fields (by number) in the data sheet.
- visiblefields( -- The visiblefields( function returns a list of visible fields in the data sheet.
- voiceinfo( -- The voiceinfo( function returns information about a speech synthesis voice.
- vtab( -- The vtab( function generates a vertical tab.
- vtabtocr( -- The vtabtocr( function converts vertical tabs (ASCII 0x0B) into carrige returns (ASCII 0x0D).
- wait -- The wait statement pauses the program for a specified period of time.
- waitfortask -- The waitfortask statement temporarily pauses a procedure until the specified task is complete.
- Web Browser Object -- is used to display web pages from within a Panorama form.
- Web Browser Programming -- programming a Web Browser Object (including JavaScript).
- Web Cookies -- web cookies.
- Web Error Pages -- customizing the server response when an error occurs.
- Web Only Databases -- databases that are web published but not shared (no synchronization).
- webdatabaseadminpage -- The webdatabaseadminpage statement generates a web admin HTML page for the current database.
- webdatabasetoform -- The webdatabasetoform statement fills in an HTML form with database field values.
- webfontsubstitutes( -- The webfontsubstitutes( function generates an array of standard font substitutions for web browsers.
- webfontsubstitutes -- The webfontsubstitutes statement generates an array of standard font substitutions for web browsers.
- webformallitems( -- The webformallitems( function returns a list of POST parameters passed from a form to the web server as a carriage return separated list.
- webformerrors( -- The webformerrors( function returns a list of errors that have been collected with the WebFormItemCheck statement.
- webformhiddenitems( -- The webformhiddenitems( function returns a list of the hidden items in the web form submitted to this web procedure.
- webformitem -- The webformitem statement sets a field or variable with the value of a POST web form item (used when processing a web query with Panorama Server).
- webformitembang( -- The webformitembang( function returns an exclamation point, icon or symbol to indicate an error in a web form for data entry.
- webformitembang -- The webformitembang statement sets the text generated by the webformitembang( function.
- webformitemcheck -- The webformitemcheck statement uses a formula to check the validity of a web form item.
- webformitemerror( -- The webformitemerror( function returns the error for a specific web form item, if any (used when processing a web query with Panorama Server).
- webformitemnames( -- The webformitemnames( function returns a list of POST parameters passed from a form to the web server as a carriage return separated list.
- webformitemnames -- The webformitemnames statement returns a list of POST parameters passed from a form to the web server as a carriage return separated list.
- webformitems( -- The webformitems( function returns a list of POST parameters passed from a form to the web server, including both visible and invisible items (but excluding the special items Panorama generates for its own internal use).
- webformitemvalue( -- The webformitemvalue( function gets the value of a POST web form item (used when processing a web query with Panorama Server).
- webformlink( -- The webformlink( function generates a link to a Panorama form on the current web site (the link will open in a new browser window).
- webformlinknewwindow( -- The webformlinknewwindow( function generates a link to a Panorama form on the current web site.
- webformmerge -- The webformmerge statement fills in an HTML form with database values (fields and variables).
- webformmissingfields( -- The webformmissingfields( function lists required fields that were not been entered into a web form.
- webformname( -- The webformname( function when processing data input into a web form, this function returns the name of the Panorama form associated with the web form (if any).
- webformrecordid -- The webformrecordid statement adds a RECORD_ID hidden field to the HTML of a web form.
- webformselection -- The webformselection statement selects data based on input from a web form. The web form must have fields that match the database fields.
- webformtodatabase -- The webformtodatabase statement updates the current database with information from the web form that was just submitted.
- webformvisibleitems( -- The webformvisibleitems( function returns a list of the visible items in the web form submitted to this web procedure.
- webhomesubfolder( -- The webhomesubfolder( function returns the folder ID of a subfolder of the web server's home folder.
- webimagedisplay( -- The webimagedisplay( function used within an Image Display Object to specify both a web image (used when the form is displayed in a web browser from Panorama Server) and a local image file (used when the form is displayed within Panorama).
- weblink( -- The weblink( function builds an HTML link tag
- weblinknewwindow( -- The weblinknewwindow( function builds an HTML link tag
- webmerge -- The webmerge statement merges an external HTML template file with fields and variables from the current record.
- webselect -- The webselect statement selects data on web server using a formula.
- webserverinfo( -- The webserverinfo( function retrieves additional information about the web server and the current browser request.
- webserverinfo -- The webserverinfo statement retrieves additional information about the web server and the current browser request.
- webshare -- The webshare statement perform record locking operations from a web publishing procedure.
- webtagortext( -- The webtagortext( function prepares text for display in a web page.
- webtext( -- The webtext( function converts a number or regular text into text encoded for display in a web browser.
- webthisrecordkey( -- The webthisrecordkey( function makes a key for use with the WebURLSelect statement to specify the current record.
- webthisrecordkey -- The webthisrecordkey statement makes a key for use with the WebURLSelect statement to specify the current record.
- weburlfind -- The weburlfind statement finds a record based on keys in a URL.
- weburlselect -- The weburlselect statement selects one or more records based on keys in a URL.
- week1st( -- The week1st( function computes the first day of a week (Sunday).
- weekvalue( -- The weekvalue( function extracts the week from a date as a numeric value.
- while -- The while statement is used at the end of a loop, and can control how many times the loop is executed.
- white( -- The white( function returns white as a Panorama color value (see Colors).
- Window ID Numbers -- ID numbers for identifying windows.
- Window Menu -- controls the back to front arrangement of windows, it allows you to hide, show, or customize the toolbar (see Toolbar, and allows you minimize or zoom the window to full screen.
- window( -- The window( function returns the name of the current window.
- window -- The window statement brings a Panorama window to the front. It can also open a "secret" invisible window.
- windowbox -- The windowbox statement specifies the dimensions (size and location) of the next window that is opened (with openform, opensheet, openprocedure etc.).
- windowcornerinitialize -- The windowcornerinitialize statement shifts a window to an edge or corner of the main screen.
- windowglobal -- The windowglobal statement creates one or more windowglobal variables.
- windowglobalvalue( -- The windowglobalvalue( function accesses a windowglobal variable from other windows.
- windowinfo( -- The windowinfo( function returns information about an open window: its name, type, database, location, etc.
- windowmenubar -- The windowmenubar statement creates a custom menu bar or context menu for the current window (see Custom Menus).
- windowname -- The windowname statement changes the name of the current window.
- windowtoback -- The windowtoback statement sends a Panorama window to the back, behind all other windows (including non-Panorama windows).
- windowtocorner -- The windowtocorner statement shifts a window to an edge or corner of the main screen.
- word( -- The word( function converts a number into a single word (2 bytes) of binary data (see Binary Data).
- wordarray( -- The wordarray( function extracts a value from an array of 16 bit words (see Binary Data).
- wordcount( -- The wordcount( function returns the number of words in the text.
- Working with Sharing Disruptions -- dealing with network & power outages, disconnections, and other anomalies.
- Working With Summary Records in a Shared Database -- summary records are not shared between users.
- writedialogcode -- The writedialogcode statement scans the current form, and writes the procedure needed to handle this form as a dialog.
- writepreference -- The writepreference statement modifies a preference value.
- xcallbackurl -- The xcallbackurl statement performs an action in another application using the x-callback-url mechanism.
- xor -- The xor operator returns true if one of the two parameters is true, false if neither or both are true.
- xtag( -- The xtag( function generates an HTML/XML tag.
- xtagvalue( -- The xtagvalue( function extracts the text from the first matching HTML or XML tag.
- xytoxy( -- The xytoxy( function converts a point or rectangle from one co-ordinate system to another.
- year1st( -- The year1st( function computes the first day of a year.
- years( -- The years( function converts a number of days into a number of years.
- yearsbetween( -- The yearsbetween( function calculates the number of years between two dates.
- yearvalue( -- The yearvalue( function extracts the year from a date as a numeric value.
- yesno -- The yesno statement displays a modal alert window with a message and two buttons: Yes and No.
- yoke( -- The yoke( function appends two text items together, with a joiner between them if both are non-blank.
- zbpattern( -- The zbpattern( function converts a number to text using a pattern, but returns empty text if the number is zero.
- zeroblank( -- The zeroblank( function tells Panorama to treat zeroes as empty space.
- zipcompress -- The zipcompress statement compresses a file or an entire folder into a zip file (using ditto shell tool).
- zipdistance( -- The zipdistance( function calculates the distance between two zip codes.
- zipinfo -- The zipinfo statement queries the web to obtain information about a zip code.
- zipinfoplus -- The zipinfoplus statement queries the web to obtain information about a zip code.
- ziplatitude( -- The ziplatitude( function returns the latitude of a US zip code.
- ziplongitude( -- The ziplongitude( function returns the longitude of a US zip code.
- zipuncompress -- The zipuncompress statement uncompresses a file or an entire folder from a zip file (using ditto shell tool).
- zlog -- The zlog statement outputs a message to the instrumentation log (if instrumentation is enabled).
- zlogalways -- The zlogalways statement unconditionally outputs a message to the instrumentation log.
- zlogcoverage -- The zlogcoverage statement allows instrumentation coverage to be turned on or off within a procedure.
- zlogdictionary -- The zlogdictionary statement outputs a data dictionary to the instrumentation log (if instrumentation is enabled).
- zlogging( -- The zlogging( function returns true if zlogging is enabled for the current database and procedure, otherwise false.
- zoomalign -- The zoomalign statement moves the current window to one of 9 positions on the computer's primary screen: top left, top center, top right, etc.
- zoomwindow -- The zoomwindow statement moves (*"zooms"*) the current window to a new position and size.
- zoomwindowrectangle -- The zoomwindowrectangle statement modifies the size, location, and options of the current window.