New Features

Here is a list of entirely new features (features that did not exist in Panorama 6).

- 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.
- 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.

- 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.
- activegrid -- The activegrid statement manages the operation of a grid that controls a series of options.
- 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 statement adjusts the value of a server variable. This is an "atomic" operation, so it is multi-user friendly.
- Advanced Server Settings -- Panorama X Server settings for advanced users.
- aggregate( -- The aggregate( function calculates an aggregate (sum (total), count, minimum, maximum or average) by scanning specified records in a database.
- alertmodal -- The alertmodal statement displays a modal alert sheet (not attached to any window) with a message and one or more buttons.
- 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.
- aliaspath( -- The aliaspath( function returns the path an alias points to (or an error if the specified file isn't an alias).
- alpha( -- The alpha( function extracts the alpha (opacity) from a color.
- alphabeticnumber( -- The alphabeticnumber( function converts a number into letters: A, B, C, etc.
- appenddataarrays( -- The appenddataarrays( function appends two or more data arrays to each other (see Data Arrays).
- 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.
- archivecontents( -- The archivecontents( function lists the contents of a compressed archive in *.zip*, *.tar.gz* or *.tar.bz2* format.
- arraycommonprefix( -- The arraycommonprefix( function finds the common prefix (if any) of all items in an array.
- arrayhack( -- The arrayhack( function hacks an array by adding, replacing or removing array elements
- 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.
- 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.
- Automatic Mailing Label Construction -- creates a mailing label.
- Automatic Record Numbering in a Shared Database -- generating unique numbers across multiple users.
- 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.
- bigendianbinaryvalue( -- The bigendianbinaryvalue( function converts big endian binary data (a byte, word, or longword) into an unsigned number (see 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.
- 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.
- 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).
- 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.
- 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.
- cache( -- The cache( function stores a value in a temporary variable.
- 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.
- 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.
- 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.
- cgitest -- The cgitest statement tests a CGI procedure.
- changetimer -- The changetimer statement modifies a repeating task that will be performed periodically when Panorama is not otherwise busy.
- Changing the Design of a Shared Database -- modifying database fields, forms and/or procedures.
- channelcatalog -- The channelcatalog statement creates a list of all channel databases (including the path for each database).
- chart( -- The chart( function converts a table of data into an HTML page with a chart (bar, line, pie, etc.).
- 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.
- 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.
- choosefiledialog -- The choosefiledialog statement displays a modal dialog allowing selection of files or folders.
- 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.
- clearglobaldictionaryvalues -- The clearglobaldictionaryvalues statement clears (removes) all the keys and values from the specified global dictionary.
- 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.
- 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.
- 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.
- Cocoa Objects -- discussion of how objects are implemented in Panorama X compared to earlier versions
- Coding with Debug Instrumentation -- modifying your code to generate debug instrumentation output.
- collapsetosummary -- The collapsetosummary statement collapses to the next higher summary level.
- 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.
- 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.).
- compress -- The compress statement compresses a file or an entire folder.
- Confirmation Alerts -- Configuring alerts to confirm sensitive operations (deletions, etc.).
- constant( -- The constant( function converts an expression into a constant value (that can be plugged into a new formula).
- 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.
- constructtabpanel -- The constructtabpanel statement creates a tab panel in the current form.
- containsword -- The containsword operator returns true if the text contains a specified word, false if it doesn't.
- 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.
- 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.
- count( -- The count( function counts all non-empty instances of a line item field in the current record.
- Crash Proof Debug Instrumentation Monitoring -- real time crash-proof instrumentation monitoring
- Creating a New Database -- creating a new database.
- Creating a Shared Database -- convert a single user database into a shared database.
- 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( -- 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.
- csvquoted( -- The csvquoted( function adds quotes if necessary for CSV text (RFC 4180).
- Customizing Debug Instrumentation Coverage -- specifying what code is being debugged at the moment.
- customstatementdatabase( -- The customstatementdatabase( function returns the name of the library database that defines a custom statement.
- Data Arrays -- A numbered collection of data values.
- Data Input Validation -- validation of data entry (checking for duplicates, etc.)
- 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 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.
- 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.
- datavalidationalert -- The datavalidationalert statement displays an alert when invalid data has been input.
- 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.
- dayofyear( -- The dayofyear( function computes the day within a quarter.
- dbconstructormenu( -- The dbconstructormenu( function used internally by ProVUE
- 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.
- decrypt( -- The decrypt( function decrypts data.
- 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.
- degrees2radians( -- The degrees2radians( function converts an angle from degrees to radians.
- 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.
- deleteselectedobjects -- The deleteselectedobjects statement deletes selected objects from a form.
- 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.
- 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).
- Disable Editing of Individual Fields -- disable editing of inidividual database fields in the data sheet and/or forms.
- 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.
- 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).
- divzeroerror( -- The divzeroerror( function divides two numbers, returns an error if the denominator is zero.
- 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.
- 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.
- dragwithinmatrix -- The dragwithinmatrix statement tracks dragging of a cell within a Matrix or Text List object.
- 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.
- 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.
- 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.
- emptylineitemnumber( -- The emptylineitemnumber( function returns the numeric suffix of the first matching line item field that is empty (if any).
- 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.
- endcatch -- The endcatch statement works with try and catch to trap errors in a sequence of statements.
- endloop -- The endloop statement is used at the end of a loop.
- endshowlater -- The endshowlater statement resumes the immediate display of text and graphics after it has been deferred with the showlater statement.
- 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.
- 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.
- executeasap -- The executeasap statement executes the specified code at the first possible opportunity, non-atomically.
- expandemojis( -- The expandemojis( function expands any "emoji cheat" abbreviations into the actual emojis.
- 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.
- 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.
- farcallwithin -- The farcallwithin statement allows a procedure to call a mini-procedure within a separate procedure in a different database as a subroutine.
- favoritedatabasedialog -- The favoritedatabasedialog statement opens the standard Favorite Databases dialog.
- favoritesbutton -- The favoritesbutton statement handles the Favorites button in a dialog.
- Field Blueprint Dialog -- examining and modifying the raw specification of a field.
- Field Properties Panel -- examining and modifying field attributes.
- 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.
- 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.
- filedisplayname( -- The filedisplayname( function returns the display name for the specified file or folder.
- fileidnumber( -- The fileidnumber( function returns the id number for the specified file or folder.
- fillall -- The fillall statement modifies the operation of the following fill statement so that all records are modified, not just visible records.
- Find & Open -- searching for a database on the hard drive and opening it.
- findabove -- The findabove statement locates the next previous record (above the current 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").
- 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.
- 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.
- fixsuperdates -- The fixsuperdates statement fixes Panorama 6 SuperDates in current field.
- 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.
- 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.
- forceunlockdatabaserecord -- The forceunlockdatabaserecord statement immediately unlocks an arbitrary record in the specified server database.
- 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.
- 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.
- 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.
- formulafields( -- The formulafields( function returns a list of fields used in a 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.
- formulastrings( -- The formulastrings( function returns a data array of strings (text constants) used in a formula.
- formulatokencount( -- The formulatokencount( function returns a count of the number of tokens in a formula.
- formulavariables( -- The formulavariables( function returns a list of variables used in a formula.
- generatedataarray( -- The generatedataarray( function generates a new data array based on a formula (see Data Arrays and Text Arrays).
- getapplicationinfo( -- The getapplicationinfo( function retrieves the value of an item in the application's plist, or a list of all plist items.
- 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.
- getglobaldictionary( -- The getglobaldictionary( function converts a global dictionary into a regular dictionary.
- getpreferenceclass( -- The getpreferenceclass( function retrieves the class name of a preference value.
- getpreferencevalue( -- The getpreferencevalue( function retrieves the value of a preference.
- 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.
- 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.
- Global Dictionaries -- alertnate high performance method to store multiple data items, much faster than regular data dictionaries.
- 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).
- globalvalue( -- The globalvalue( function returns the value of a global variable.
- gotofielddialog -- The gotofielddialog statement opens the standard dialog for jumping to a specific field (in the Fields menu).
- 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).
- Help Menu -- contains items that will help you learn and use Panorama.
- hextobinary( -- The hextobinary( function converts a sequence of hexadecimal digits into a raw binary data value.
- hfspath( -- The hfspath( function converts a UNIX path into an HFS path.
- hideaccessorypanel -- The hideaccessorypanel statement closes the current window's accessory panel.
- 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.
- 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.
- HTML Export -- custom exports into an HTML file.
- 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.
- htmltablerow( -- The htmltablerow( function extracts the data from a row in an HTML table.
- 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 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.
- Import Database -- importing another database into the current database.
- importdataarray( -- The importdataarray( function converts a text array into a data array (see Data Arrays and Text Arrays).
- importdatabasedialog -- The importdatabasedialog statement opens the standard Import Database dialog.
- importform -- The importform statement imports a form into a database.
- importjsonline -- The importjsonline statement imports a JSON record 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.
- 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("activeobjectid") -- The info("activeobjectid") function returns the object ID of the currently active text editor or text list 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("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("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("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("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("decimalseparator") -- The info("decimalseparator") function returns the current decimal separator character (period or comma).
- 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("dialogsheet") -- The info("dialogsheet") function returns true if the currently active window is a dialog sheet.
- 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("dropfiles") -- The info("dropfiles") function returns a list of files dragged onto a Drag Receiver form object (see Drag and Drop).
- 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("dropwindownumber") -- The info("dropwindownumber") function returns the number of the window that contains the form data was dropped on.
- info("enabledfields") -- The info("enabledfields") function returns a list of enabled fields in the current database (fields that can be edited).
- info("eventtype") -- The info("eventtype") function returns the type of the last event (mouse click, keyboard press, etc.).
- info("fieldcount") -- The info("fieldcount") function returns the number of fields in the current database.
- 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("filesystemmonitors") -- The info("filesystemmonitors") function lists the active file system monitors.
- 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("fonts") -- The info("fonts") function returns a list of all fonts installed on this computer.
- info("formobjectcommonproperties") -- The info("formobjectcommonproperties") function returns a list of properties that are common to all types of form objects.
- 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("guid") -- The info("guid") function returns a unique identifier string.
- 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("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("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("magnification") -- The info("magnification") function returns the current magnification of the current form.
- 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("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("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("notification") -- The info("notification") function returns information about the just clicked notification.
- 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("panoramabundleversion") -- The info("panoramabundleversion") function returns the bundle version 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("panoramauptime") -- The info("panoramauptime") function returns the number of seconds since Panorama launched.
- 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("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("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("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("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("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("serverconnectionstatus") -- The info("serverconnectionstatus") function returns the status of the connection between this database and the server.
- 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("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("taperecorder") -- The info("taperecorder") function returns information about the current procedure recording (if any).
- 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("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("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("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("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("voices") -- The info("voices") function returns a list of available speech synthesis voices on this system.
- 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("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.
- initializedictionary( -- The initializedictionary( function builds a new dictionary and initializes it with zero or more key/value entries (see Data Dictionaries).
- insertbelowcarriagereturn -- The insertbelowcarriagereturn statement inserts a new record below the current record and moves to the first column.
- insertnewproceduremark -- The insertnewproceduremark statement inserts a new mark into the current procedure.
- 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.
- integralpoint( -- The integralpoint( function converts point coordinates to integers.
- integralrectangle( -- The integralrectangle( function converts rectangle coordinates to integers.
- 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.
- 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.
- jsonexportline( -- The jsonexportline( function exports the current database record in JSON format.
- jsonscriptstring( -- The jsonscriptstring( function converts text into a JSON string literal
- 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).
- lastlookupdatabase( -- The lastlookupdatabase( function returns the name of the database referenced in the most recent lookup.
- latlongdistance( -- The latlongdistance( function calculates the distance between two points on the earth (or any other sphere).
- launch -- The launch statement launches an application.
- 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.
- lftocr( -- The lftocr( function converts linefeeds into carriage returns.
- Limiting the Maximum Number of Data Sheet Columns -- adjusting the maximum number of columns displayed in data sheet windows.
- Line Item Grid Constructor -- creates a grid of form elements for displaying and editing line item fields.
- 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.
- 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).
- loadcustomfunctions -- The loadcustomfunctions statement reloads all ProVUE defined custom functions.
- 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.
- Logging Server Activity -- recording server activities for later analysis.
- longlongword( -- The longlongword( function converts a number into a 64 bit longword (8 bytes) of binary data (see Binary Data).
- Looking up Data Directly from the Server -- local in-memory vs. server lookups.
- 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.
- 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.
- makemergeformula( -- The makemergeformula( function builds a formula from an “auto-wrap" style merge template.
- makepackage -- The makepackage statement creates a new package, and if necessary, also creates any enclosing folders needed to create the specified new package.
- 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.
- 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.
- 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.
- 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.
- menuitem( -- The menuitem( function creates a single menu item (see Custom Menus).
- menuseparator( -- The menuseparator( function generates a menu item separator
- mixedupperword( -- The mixedupperword( function converts lower case words to Initial Caps, but leaves mixed case words alone.
- modifyfileattributes -- The modifyfileattributes statement modifies one or more attributes of a file (or folder).
- Morph All Fields Dialog -- morphing the contents of the entire database.
- morphalldialog -- The morphalldialog statement opens the standard MorphAll dialog.
- morphdialog -- The morphdialog statement opens the standard Morph dialog.
- movefieldbefore -- The movefieldbefore statement moves the current field to a new position.
- 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.
- 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.
- nextvalue -- The nextvalue statement advances a variable or field to the next value in a list.
- noinstrumentationmenu( -- The noinstrumentationmenu( function supresses the Instrumentation menu.
- nslog -- The nslog statement sends a message to the console log.
- nsnotify -- The nsnotify statement delivers a notification.
- nsrectstr( -- The nsrectstr( function converts a rectangle into text in the format x,y,width,height
- 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.
- objectinfoarray( -- The objectinfoarray( function builds a text array of form object properties
- Objects Menu -- used to select, modify and arrange graphics objects in a form.
- 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.
- 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.
- opendialogsheet -- The opendialogsheet statement opens a form from the current database as a sheet dialog (attached to the current 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.
- openpreferenceswindow -- The openpreferenceswindow statement opens the Panorama Preferences window.
- opensavedwindows -- The opensavedwindows statement opens windows that were open the last time file was saved.
- opensoftwareupdatewindow -- The opensoftwareupdatewindow statement opens the Panorama Software Update window.
- 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.
- 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).
- 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.
- 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.
- pathseparator( -- The pathseparator( function returns the type of separator character used in a file path (either / or :).
- 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.
- 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.
- pi( -- The pi( function returns the value of pi .
- pinrectangle( -- The pinrectangle( function pins a rectangle within the bounds of a larger rectangle.
- playsound -- The playsound statement starts playing a sound file.
- pointsval( -- The pointsval( function converts a dimension to points (possibly from inches or centimeters).
- Polygon Object -- draws a polygon within a form.
- popupsharingmenu -- The popupsharingmenu statement pops up a menu for the toolbar sharing icon.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 Menu -- assists with running and debugging code, and with developing custom dialogs.
- Programming -- basics of programming with Panorama X.
- Progress Indicator Object -- is used to create progress indicators
- provueserverisup( -- The provueserverisup( function checks whether provue.com is online and operating.
- provueserverisup -- The provueserverisup statement checks whether provue.com is online and operating.
- radians2degrees( -- The radians2degrees( function converts an angle from radians to degrees.
- rawtags( -- The rawtags( function is an internal function used by other tag functions.
- 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.
- 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.
- rectangleinset( -- The rectangleinset( function insets a rectangle by a specified amount.
- rectangleoffset( -- The rectangleoffset( function offsets a rectangle to a new position.
- rectangletweak( -- The rectangletweak( function transforms a rectangle by changing its position and/or size.
- 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.
- 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
- 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.
- remotepanoramaxservers( -- The remotepanoramaxservers( function returns the names of all Panorama X servers that are remotely accessible from this computer.
- removepreferencevalues -- The removepreferencevalues statement deletes one or more preference values.
- removeremotehost -- The removeremotehost statement makes a remote host unavailable to this computer.
- reorderfieldsdialog -- The reorderfieldsdialog statement opens the Reorder Fields dialog.
- replacefirst( -- The replacefirst( function replaces the first occurence of some text with new text.
- 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.
- 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.
- resumeaftertask -- The resumeaftertask statement resumes after a waitfortask statement.
- resumespeaking -- The resumespeaking statement resumes speaking after a pause.
- 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.
- 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.
- runcustommenu -- The runcustommenu statement runs the *.CustomMenu* procedure.
- 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).
- runningappinfo( -- The runningappinfo( function returns information about applications that are currently running on this computer.
- 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.
- saveandclose -- The saveandclose statement saves and closes a database file.
- 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.
- savepartialdatabase -- The savepartialdatabase statement saves specified components of the current database, leaving other components out.
- scaleselectedobjects -- The scaleselectedobjects statement scale the selected objects by a specified factor.
- 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.
- 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).
- 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.
- Segmented Button Object -- is used to created segmented buttons.
- Select Duplicates Dialog -- opens the standard Select Duplicates dialog sheet.
- 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.
- 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.
- 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.
- sendbackward -- The sendbackward statement sends the selected form objects one layer towards the back.
- sendtoback -- The sendtoback statement sends the selected form objects to the back.
- 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.
- serverjournalcode -- The serverjournalcode statement writes code to journal file.
- serverjournalcurrentrecord -- The serverjournalcurrentrecord statement writes the current record to journal file.
- 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.
- 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.
- 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.
- 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.
- 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.
- setcallerslocal -- The setcallerslocal statement allows a subroutine to modify a local variable in the procedure that called it.
- setdefaultfloatformat -- The setdefaultfloatformat statement sets the default format for converting floating point values to text (unsupported).
- 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.
- setfileglobal -- The setfileglobal statement sets the value of a fileglobal variable (optionally 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.
- 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.
- 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.).
- 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.
- 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.
- 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.).
- 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).
- Sharing Icon & Context Menu -- operation of the sharing icon and pop-up menu (in the toolbar).
- shellscriptwithterminal -- The shellscriptwithterminal statement runs a shell script in a new Terminal.app window (useful for debugging).
- Shifting Data Left & Right -- sliding data left and right.
- shortstandardviewmenu( -- The shortstandardviewmenu( function generates a Live Menu specification for a truncated version of Panorama’s standard View menu.
- showaccessorypanel -- The showaccessorypanel statement opens the current window's accessory panel.
- showfieldsbetween -- The showfieldsbetween statement hides all fields except those in between specified numbers.
- showlater -- The showlater statement defers the display of text and graphics until the procedure is finished.
- showrectangle -- The showrectangle statement refreshes all or part of the current form window.
- 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).
- 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.
- sortdialog -- The sortdialog statement opens the standard Sort dialog.
- 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.
- 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.
- specialkey( -- The specialkey( function returns the unicode value for special keys on the keyboard.
- speechrate -- The speechrate statement changes the speech rate (words per minute).
- speechvoice -- The speechvoice statement changes the default speech voice.
- speechvolume -- The speechvolume statement changes the default speech volume.
- standardactionmenu( -- The standardactionmenu( function generates a Custom Menu specification for Panorama's standard Action menu.
- standardconstructgraphicsmenu( -- The standardconstructgraphicsmenu( function generates a Custom Menu specification for Panorama’s standard Construct menu (in Graphics Mode).
- standardfieldsmenu( -- The standardfieldsmenu( function generates a customizable Custom Menu specification for Panorama's standard Fields 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.
- 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.
- startupdatecheck -- The startupdatecheck statement starts background check for available Panorama update.
- statename( -- The statename( function converts a two letter abbreviation for a US state into the full state name.
- 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.
- 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.
- stopposixtask -- The stopposixtask statement stops a POSIX shell script that is running in the background.
- stoptimer -- The stoptimer statement stops and deletes a timer that was set up with the StartTimer statement.
- 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.
- stripaccents( -- The stripaccents( function removes accents from any characters in the text.
- stripdiacriticals( -- The stripdiacriticals( function strips diacritical marks from text.
- summarydatabaseselectoriginal -- The summarydatabaseselectoriginal statement selects original data corresponding to a cell in an exported summary table database.
- 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.
- superdateunixtime( -- The superdateunixtime( function converts a Panorama superdate into a 13 digit UNIX epoch date/time (including milliseconds).
- 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.
- 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.
- Synchronizing in Procedure Code -- customizing the data synchronization process.
- 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.
- Temporarily Disconnecting a Shared Database from the Server -- pause database sharing.
- Text Display Programming -- programming a Text Display Object.
- 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 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.
- textfilter( -- The textfilter( function scans and filters text on a character by character basis.
- textlisttableoptions -- The textlisttableoptions statement sets up text list table options
- 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.
- timecheck -- The timecheck statement identifies an intermediate point in a performance monitoring session.
- timelimit -- The timelimit statement specifies the maximum time a procedure can continue to run after this statement.
- 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.
- 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).
- 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.
- 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.
- 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.
- 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.
- unixpath( -- The unixpath( function converts an HFS path into a UNIX path.
- unixtimesuperdate( -- The unixtimesuperdate( function converts a 13 digit UNIX epoch date/time (including milliseconds) into a Panorama superdate.
- Updating Panorama X -- checking for and installing newer versions of Panorama X.
- uploaddatatoserver -- The uploaddatatoserver statement uploads binary data to the server.
- uploadfiletoserver -- The uploadfiletoserver statement uploads a file or folder to a Panorama server.
- 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).
- 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.
- 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.
- 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.
- Using an External Web Server -- instructions for using Panorama Server in conjunction with an external web server (for example Apache, Nginx, etc.).
- Using Panorama X with Internet Monitoring Software -- configuring network mintoring/blocking software (Little Snitch, Hands Off, etc.) for proper Panorama X operation.
- validnumber( -- The validnumber( function checks to see if a numeric value is valid.
- View Search -- persistent, comprehensive search of procedures and forms in one or multiple databases.
- 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.
- voiceinfo( -- The voiceinfo( function returns information about a speech synthesis voice.
- 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.
- webfontsubstitutes( -- The webfontsubstitutes( function generates an array of standard font substitutions for web browsers.
- 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).
- webserverinfo( -- The webserverinfo( function retrieves additional information about the web server and the current browser request.
- Window ID Numbers -- ID numbers for identifying windows.
- 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.
- writepreference -- The writepreference statement modifies a preference value.
- xcallbackurl -- The xcallbackurl statement performs an action in another application using the x-callback-url mechanism.
- 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.
- 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.

See Also

- Release Notes -- detailed list of what's new in every Panorama X version.
- Updated -- List of features that have been improved since Panorama 6.