Statements

All of the statements supported in Panorama procedures are listed below:

- 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.
- activeobjectaction -- The activeobjectaction statement allows a procedure to communicate with the object on the current form that is currently being edited (if any).
- addfield -- The addfield statement adds a new field to the current database (on the end).
- addlines -- The addlines statement adds a specified number of records to the end of a database.
- addmultiplerecords -- The addmultiplerecords statement Adds multiple records.
- addrecord -- The addrecord statement adds a new record at the end of the current database.
- addrelatedrecord -- The addrelatedrecord statement adds a new record to the related database corresponding to the current database.
- addremotehost -- The addremotehost statement makes a remote host available to this computer.
- 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.
- alert -- The alert statement displays a modal alert window with a message and one or more buttons.
- alertcanceldelete -- The alertcanceldelete statement displays a modal alert window with a message and two buttons: Cancel and Delete.
- alertcancelok -- The alertcancelok statement displays a modal alert window with a message and two buttons: Cancel and Ok.
- alertdeletecancel -- The alertdeletecancel statement displays a modal alert window with a message and two buttons: Delete and Cancel.
- alertmodal -- The alertmodal statement displays a modal alert sheet (not attached to any window) with a message and one or more buttons.
- alertnoyes -- The alertnoyes statement displays a modal alert window with a message and two buttons: No and Yes.
- alertok -- The alertok statement displays a modal alert window with a message and one button: Ok
- alertokcancel -- The alertokcancel statement displays a modal alert window with a message and two buttons: Ok and Cancel.
- alertoksmall -- The alertoksmall statement displays a modal alert window with a message and one button: Ok
- alertrevertcancel -- The alertrevertcancel statement displays a modal alert window with a message and two buttons: Revert and Cancel.
- alertsavecancel -- The alertsavecancel statement displays a modal alert window with a message and two buttons: Save and Cancel.
- alertsheet -- The alertsheet statement displays an alert sheet (attached to the current window) with a message and one or more buttons. Note: with the introduction of OS 11, Big Sur, sheets no longer appear to slide down from the title bar, but open a dialog centered on the active window.
- alerttimestampmismatches -- The alerttimestampmismatches statement display mismatched time stamps.
- alertyesno -- The alertyesno statement displays a modal alert window with a message and two buttons: Yes and No.
- alertyesnocancel -- The alertyesnocancel statement displays a modal alert window with a message and three buttons: Yes, No and Cancel.
- analyzedialog -- The analyzedialog statement opens the standard Analyze dialog.
- append -- The append statement appends a text string to a field or variable.
- appenddictionaryvalue -- The appenddictionaryvalue statement appends a value to an item in a dictionary (see Data Dictionaries).
- appendline -- The appendline statement appends a text string to a field or variable on a new line.
- applescript -- The applescript statement executes an AppleScript.
- arrayboth -- The arrayboth statement creates a new array from two existing arrays. The new array contains only items that are in both of the original arrays.
- arraybuild -- The arraybuild statement builds an array by scanning a database and creating an array element for every record (including invisible records) in the database (see Text Arrays).
- arraydeduplicate -- The arraydeduplicate statement removes duplicate elements from an array (see Text Arrays).
- arraydifference -- The arraydifference statement creates a new array from two existing text arrays. The new array contains only items that are in the first array but not in the second array.
- arrayfilter -- The arrayfilter statement processes each element of an array with a formula (see Text Arrays).
- arrayintegersort -- The arrayintegersort statement sorts all the numeric elements of a text array in proper numeric order.
- arraymultisort -- The arraymultisort statement sorts a two-dimensional array on the key of one or more of its columns.
- arraynumericsort -- The arraynumericsort statement sorts all the numeric elements of a text array in proper numeric order.
- arraynumerictotal -- The arraynumerictotal statement totals all the numeric elements of a text array.
- arrayrandomize -- The arrayrandomize statement reorders an array in random order.
- arrayrelocate -- The arrayrelocate statement moves one or more items in a text array to a new position.
- arrayselectedbuild -- The arrayselectedbuild statement builds an array by scanning a database and creating an array element for every visible (selected) record in the database (see Text Arrays).
- arraysort -- The arraysort statement sorts the elements in an array (see Text Arrays).
- arraystrip -- The arraystrip statement strips blank elements from an array.
- arraytoggle -- The arraytoggle statement "toggles" a value within an array.
- arrayunpropagate -- The arrayunpropagate statement scans an array from top to bottom, removing duplicate values in a row.
- 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 statement performs an assignment, much like an equals sign or the assign statement. However, the assignglobal statement only performs the assignment to a global variable.
- assignlocal -- The assignlocal statement performs an assignment, much like an equals sign or the assign statement. However, the assignlocal statement only performs the assignment to a local variable.
- assignservervariable -- The assignservervariable statement assigns a value to a permanent variable on the server. If the server variable does not already exist, it will be created.
- assignwindowglobal -- The assignwindowglobal statement performs an assignment, much like an equals sign or the assign statement. However, the assignwindowglobal statement only performs the assignment to a windowglobal variable.
- autoallfieldwidths -- The autoallfieldwidths statement automatically sets the width of all fields based on the data in each field.
- autofieldwidth -- The autofieldwidth statement automatically sets the width of the current field based on the data in it.
- automaticfieldchoices -- The automaticfieldchoices statement updates the current field's Choice list with actual data in the database.
- average -- The average statement calculates averages and sub-averages for the selected records in the current field.
- batchassign -- The batchassign statement assigns a bunch of fields/variables to another bunch of fields/variables.
- batchreplace -- The batchreplace statement performs multiple find and replace operations on a piece of text.
- beep -- The beep statement makes the computer speaker beep once.
- bestfitrectangle -- The bestfitrectangle statement fits a rectangle within a boundary rectangle, enlarging or reducing as necessary to produce the best fit without changing the proportions.
- bigmessage -- The bigmessage statement displays a message alert.
- 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).
- bookmarkshareddatabase -- The bookmarkshareddatabase statement saves the local location of the current shared database.
- bringforward -- The bringforward statement brings the selected form objects one layer towards the front.
- bringpanoramaforward -- The bringpanoramaforward statement brings Panorama forward, making it the active Application.
- bringtofront -- The bringtofront statement brings the selected form objects to the front.
- buildfavoritesmenu -- The buildfavoritesmenu statement builds the Favorite Databases menu.
- buildwizardmenus -- The buildwizardmenus statement scans the wizard folder to build the Wizard menu and submenus.
- calcenclosingrectangle -- The calcenclosingrectangle statement will calculate the rectangle surrounding all of the specified objects.
- call -- The call statement allows a procedure to call a separate procedure within the current database as a subroutine.
- callwithin -- The callwithin statement allows a procedure to call a mini-procedure within a separate procedure within the current database as a subroutine.
- cancelok -- The cancelok statement displays a modal alert window with a message and two buttons: Cancel and Ok.
- cardvalidate -- The cardvalidate statement verifies that a number is a valid credit card number.
- case -- The case statement allows multiple decisions to be chained together (also see the elseif statement).
- catch -- The catch statement works with try and endcatch to trap errors in a sequence of statements.
- cell -- The cell statement enters a value into the currently active field (i.e. cell).
- cgitest -- The cgitest statement tests a CGI procedure.
- change -- The change statement replaces text with new text in the current field (selected records only).
- changedictionaryname -- The changedictionaryname statement changes the name (key) of an item in a dictionary (see Data Dictionaries).
- changeobject -- The changeobject statement modifies the properties of one object in a form.
- changeobjects -- The changeobjects statement modifies the properties of one or more objects in a form.
- changetimer -- The changetimer statement modifies a repeating task that will be performed periodically when Panorama is not otherwise busy.
- changeword -- The changeword statement replaces one word with another in the current field (selected records only).
- changewordexact -- The changewordexact statement replaces one word with another in the current field (selected records only).
- channelactivemodule -- The channelactivemodule statement returns the currently active module for a channel, if any.
- channelcall -- The channelcall statement calls a procedure in the active channel module.
- channelcatalog -- The channelcatalog statement creates a list of all channel databases (including the path for each database).
- channelgetdictionary -- The channelgetdictionary statement returns the current settings for a specified channel.
- channelinformation -- The channelinformation statement returns information about a specified channel.
- channelload -- The channelload statement loads a channel module.
- channelmodules -- The channelmodules statement returns a list of available modules for a specified channel type.
- channelopen -- The channelopen statement opens a channel module for editing.
- channelpath -- The channelpath statement returns the path of a specified channel module.
- channelprocedures -- The channelprocedures statement returns a list of procedures available in a specified channel.
- channelsetdictionary -- The channelsetdictionary statement saves new settings for a specified channel.
- channelswitch -- The channelswitch statement switches the active channel module.
- channeltypes -- The channeltypes statement returns a list of available channel types.
- characterfilter -- The characterfilter statement scans and filters text on a character by character basis.
- checkdesignlock -- The checkdesignlock statement checks if field structure can be changed, if not, returns an error.
- checkemptyselection -- The checkemptyselection statement notifies the user if a selection failed, and reverts to the previous selection.
- checkforupdates -- The checkforupdates statement performs the same action as the Check for Updates menu item.
- checkserverconnection -- The checkserverconnection statement checks to see if the specified server is connected.
- checkserversynchronization -- The checkserversynchronization statement checks the synchronization of the current database.
- checkstructurelock -- The checkstructurelock statement Check if database structure is locked, if it is, notify user and stop program.
- choosefiledialog -- The choosefiledialog statement displays a modal dialog allowing selection of files or folders.
- choosefolderdialog -- The choosefolderdialog statement pauses and displays the standard “choose folder” dialog.
- clear -- The clear statement deletes the contents of the current cell without touching the clipboard.
- clearcell -- The clearcell statement deletes the contents of the current field.
- clearglobaldictionaryvalues -- The clearglobaldictionaryvalues statement clears (removes) all the keys and values from the specified global dictionary.
- clearrecord -- The clearrecord statement deletes the currently selected record.
- cleartypeahead -- The cleartypeahead statement clears any typed ahead characters that have been pressed while a procedure is running.
- clearundo -- The clearundo statement clears out the undo stack, eliminating the ability to undo any previous action.
- 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.).
- cloneform -- The cloneform statement copies all of the objects in a form (optionally, with modifications) into the active form.
- cloneobjects -- The cloneobjects statement duplicates objects in a form (with modifications).
- closeactiveobject -- The closeactiveobject statement closes any object whose text is currently being edited.
- closeallasyncprogresswindows -- The closeallasyncprogresswindows statement closes any asynchronous progress windows.
- closeclonewindow -- The closeclonewindow statement is an alternative method to close the current window, works even if the window has no close box.
- closedatabase -- The closedatabase statement closes a specified database.
- closedatabaseactiveobjects -- The closedatabaseactiveobjects statement stops all text editing associated with the current database.
- closedialog -- The closedialog statement closes a form window that was previously opened with the opendialog statement.
- closedialogwindow -- The closedialogwindow statement is used internally by the rundialog statement.
- closefile -- The closefile statement closes the current database.
- closeserverfile -- The closeserverfile statement closes the current database (used on the server).
- closewindow -- The closewindow statement closes the current window.
- collapse -- The collapse statement hides the detail records associated with the currently active summary record.
- collapsetosummary -- The collapsetosummary statement collapses to the next higher summary level.
- colorwheel -- The colorwheel statement allows the user to pick a color using the operating systems standard color picker dialog
- columnstatsdialog -- The columnstatsdialog statement opens the standard Column Stats dialog.
- Comments -- A comment is a note inside a program.
- commonfieldspopup -- The commonfieldspopup statement pops up a list of common fields, and changes the current field specifications when a field is chosen from this menu.
- comparedictprocedures -- The comparedictprocedures statement compares all the procedures from a dictionary with the procedures in a specified database.
- compress -- The compress statement compresses a file or an entire folder.
- connecttoserver -- The connecttoserver statement reconnects the current database to the server (after the dropserver statement has been used).
- console -- The console statement sends a message to the console log.
- constructcalendar -- The constructcalendar statement creates the form elements for a monthly calendar.
- constructfields -- The constructfields statement creates one or more new fields based on a template.
- constructfieldssheet -- The constructfieldssheet statement opens a sheet to add/insert multiple new fields into the database.
- constructformdataeditors -- The constructformdataeditors statement creates a column of form elements for editing data fields (or variables).
- constructlineitems -- The constructlineitems statement creates a grid of line items.
- constructlistmatrix -- The constructlistmatrix statement creates a text list or matrix in the current form.
- constructmailinglabel -- The constructmailinglabel statement creates the form elements for printing mailing labels.
- constructreport -- The constructreport statement creates a report in the current form.
- constructtabpanel -- The constructtabpanel statement creates a tab panel in the current form.
- controlsound -- The controlsound statement controls playback of a sound file.
- convertvariablestoconstants -- The convertvariablestoconstants statement converts all of the variables in a formula into constant values.
- copy -- The copy statement copies the contents of the current field onto the clipboard.
- copycell -- The copycell statement copies the contents of the current field onto the clipboard, replacing anything previously on the clipboard.
- copyfile -- The copyfile statement copies a file (or folder).
- copyfolder -- The copyfolder statement copies an entire folder full of files (and subfolders, if any).
- copynewerfile -- The copynewerfile statement copies a file to another name or location. However, the file is only copied if it is newer than the old file, otherwise the destination is not touched.
- copynewerfolder -- The copynewerfolder statement copies an entire folder full of files, but only copies newer files.
- copypartialdictionary -- The copypartialdictionary statement builds a new dictionary and initializes it with values from an existing dictionary (see Data Dictionaries).
- copyrecord -- The copyrecord statement copies the contents of the current record onto the clipboard.
- count -- The count statement counts all non-empty data cells for the current field.
- countsummaries -- The countsummaries statement counts summary records.
- createpassword -- The createpassword statement creates a random password using characters or numbers (or a mixture) set to the chosen length.
- 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.
- customdialog -- The customdialog statement customizes the appearance of the gettext and getscrap dialogs.
- cut -- The cut statement deletes the contents of the current field, copying it onto the clipboard.
- cutcell -- The cutcell statement delete the contents of the current cell and places the deleted data on the clipboard.
- cutline -- The cutline statement copies the current record to the clipboard and deletes it.
- cutrecord -- The cutrecord statement copies the current record to the clipboard and deletes it.
- 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.
- debug -- The debug statement stops the current program, allowing you to examine variables or single step.
- defaultcase -- The defaultcase statement works together with the case statement to specify statements that will be executed if none of the case statements are true.
- define -- The define statement performs an assignment, much like an equals sign or the assign statement. However, the define statement only performs the assignment if the variable is currently undefined. If the variable already has a value, the define statement leaves it alone. The define statement is especially useful for initializing permanent variables.
- definehotkeys -- The definehotkeys statement defines one or more Hotkeys.
- defineservervariable -- The defineservervariable statement defines the value of a permanent variable on the server. If the variable already exists, it is not touched.
- degree -- The degree statement tells Panorama that all angles input to and calculated in trigonometric functions are in degrees rather than radians.
- delay -- The delay statement loops for a specified period of time.
- deleteabove -- The deleteabove statement copies the current record to the clipboard and deletes it, then moves to the record above.
- deleteall -- The deleteall statement removes all records, leaving a single blank record.
- deletechildren -- The deletechildren statement deletes all the records in another database that have a value in the key field that is equal to the key value.
- deletedictionaryvalue -- The deletedictionaryvalue statement deletes a key/value pair from a dictionary (see Data Dictionaries).
- deletefield -- The deletefield statement deletes the current field from the database.
- deleteglobaldictionaryvalues -- The deleteglobaldictionaryvalues statement deletes one or more global dictionary values.
- deletehotkeys -- The deletehotkeys statement deletes the hotkeys in a specific scope.
- deleteobject -- The deleteobject statement deletes the specified object from the current form.
- deleterecchildrenwarn -- The deleterecchildrenwarn statement warns you before deleting the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- deleterecord -- The deleterecord statement deletes the currently selected record.
- deleterecordandchildren -- The deleterecordandchildren statement This deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- deleteselectedobjects -- The deleteselectedobjects statement deletes selected objects from a form.
- deletewebtemplate -- The deletewebtemplate statement deletes the web template (a dictionary) associated with a form (if any).
- dialdigits -- The dialdigits statement dials one or more digits.
- dialphone -- The dialphone statement dials one or more digits, adjusting for area codes, country codes, etc..
- dictionarydifference -- The dictionarydifference statement builds an array that lists keys of dictionary values that are different between two dictionaries (see Data Dictionaries).
- dictionaryvalueexists -- The dictionaryvalueexists statement returns true or false depending on whether or not a key/value pair exists in a dictionary (see Data Dictionaries).
- disableabort -- The disableabort statement prevents loops from being stopped early by pressing SHIFT-COMMAND-ESCAPE or by exceeding the maximum allowed loop time.
- disablefieldediting -- The disablefieldediting statement disables editing for a specified list of database fields (all others are enabled).
- disconnectedserver -- The disconnectedserver statement takes the current database offline without contacting the server.
- displaydata -- The displaydata statement will display data in a large dialog with a scroll bar.
- displayhtml -- The displayhtml statement will display a dialog containing HTML. You can control the size of the dialog, as well as several appearance options.
- downloaddatabasefromserver -- The downloaddatabasefromserver statement downloads a database file from a Panorama server.
- downloaddatafromserver -- The downloaddatafromserver statement asynchronously downloads pre-calculated binary data from a Panorama server.
- downloadpartialdatabase -- The downloadpartialdatabase statement downloads specified components of the current database from the server. The current database must be shared.
- downloadrecord -- The downloadrecord statement downloads the current record from the connected server.
- downloadrecordwithwarning -- The downloadrecordwithwarning statement downloads the current record from the connected server, with a warning if the record is currently locked.
- downrecord -- The downrecord statement moves the cursor down one visible record.
- dragarrayorder -- The dragarrayorder statement tracks dragging of a cell within a Matrix or Text List object, then reorders the array associated with that object accordingly.
- draggraybox -- The draggraybox statement facilitates dragging something around in a form window.
- dragtext -- The dragtext statement starts drag-and-drop of text.
- dragwithinmatrix -- The dragwithinmatrix statement tracks dragging of a cell within a Matrix or Text List object.
- dropallshareddatabases -- The dropallshareddatabases statement drops the connection to all shared databases. Panorama uses this when the client is about to quit, could also be used if you know you are about to go offline.
- dropfromfinder -- The dropfromfinder statement processes any files or folders that have been dropped on a form from the finder.
- dropimagesfromfinder -- The dropimagesfromfinder statement processes images that have been dropped on a form from the Finder. The images may be added to new records in the database or put in the current record.
- dropserver -- The dropserver statement disconnects the current database from the server.
- dumpdictionary -- The dumpdictionary statement returns a carriage return separated array of dictionary keys and values (see Data Dictionaries).
- dumpdictionaryquoted -- The dumpdictionaryquoted statement returns a carriage return separated array of dictionary keys and values (see Data Dictionaries).
- duplicatefield -- The duplicatefield statement duplicates the current field.
- duplicaterecord -- The duplicaterecord statement duplicates the current record.
- editcell -- The editcell statement opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellstop -- The editcellstop statement opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellwith -- The editcellwith statement opens the edit window for the currently active field (or cell), using the supplied alternate text.
- editfavoritesdialog -- The editfavoritesdialog statement handles the Favorites button in a dialog.
- editfield -- The editfield statement begins editing of the specified field.
- editfieldname -- The editfieldname statement opens the data sheet window's field properties inspector and selects the field name.
- else -- The else statement works together with the if statement to specify statements that will be executed for both the true and false cases.
- elseif -- The elseif statement allows multiple if decisions to be chained together.
- emptyfield -- The emptyfield statement tells Panorama to move to the next available (empty) field in a series of line item fields.
- emptyfill -- The emptyfill statement fills every empty visible cell in the active field with the specified value.
- enableabort -- The enableabort statement allows the SHIFT-COMMAND-ESCAPE key sequence to stop an endless loop.
- endcase -- The endcase statement marks the end of statements controlled by a previoius case statement.
- endcatch -- The endcatch statement works with try and catch to trap errors in a sequence of statements.
- endif -- The endif statement marks the end of statements controlled by a previoius if statement.
- endloop -- The endloop statement is used at the end of a loop.
- endnoshow -- The endnoshow statement resumes the output of text and graphics after it has been disabled with the noshow statement.
- endshowlater -- The endshowlater statement resumes the immediate display of text and graphics after it has been deferred with the showlater statement.
- enterprisecall -- The enterprisecall statement calls a procedure in a server database, opening and closing the database if necessary.
- excludefromrecentmenu -- The excludefromrecentmenu statement excludes the next opened database from the Recent menu.
- execute -- The execute statement allows a procedure to call a sequence of statements within the current procedure as a "mini-subroutine".
- executeapplescript -- The executeapplescript statement compiles and runs an AppleScript.
- executeapplescriptformula -- The executeapplescriptformula statement executes an AppleScript, with embedded Panorama formulas.
- executeasap -- The executeasap statement executes the specified code at the first possible opportunity, non-atomically.
- executecatcherrors -- The executecatcherrors statement is the same as the execute statement, except for the fact that if an error occurs while running, it can be trapped by an if error statement immediately following the executecatcherrors statement.
- executelocal -- The executelocal statement is the same as the execute statement, but it shares local variables with the procedure that called it.
- executeperlscript -- The executeperlscript statement executes Perl code.
- executesudounix -- The executesudounix statement executes a UNIX shell command using sudo (root) privileges.
- executeunix -- The executeunix statement executes a UNIX shell command.
- expand -- The expand statement reveals the next level of collapsed detail records associated with the currently active summary record.
- expandall -- The expandall statement reveals all collapsed detail records associated with the currently active summary record.
- export -- The export statement exports the selected rows in the current database into a text file.
- exportallprocedures -- The exportallprocedures statement saves all the procedures in an editable text format.
- exportjson -- The exportjson statement exports the current database in JSON format.
- expressionstacksize -- The expressionstacksize statement does nothing.
- extendedexpressionstack -- The extendedexpressionstack statement does nothing.
- extensiontype -- The extensiontype statement returns the type code of the specified file (if any).
- farcall -- The farcall statement allows a procedure to call a separate procedure within a different database as a subroutine.
- farcallwithin -- The farcallwithin statement allows a procedure to call a mini-procedure within a separate procedure in a different database as a subroutine.
- favoritedatabasedialog -- The favoritedatabasedialog statement opens the standard Favorite Databases dialog.
- favoritesbutton -- The favoritesbutton statement handles the Favorites button in a dialog.
- field -- The field statement tells Panorama to move to the specified field for the current record.
- 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.
- fieldname -- The fieldname statement changes the name of the current field.
- fieldstotextvariables -- The fieldstotextvariables statement copies database fields into variables.
- fieldtype -- The fieldtype statement changes the data type of the current field.
- fieldtypes -- The fieldtypes statement returns a carriage return delimited array with list of fields and field data types.
- fileappend -- The fileappend statement appends new data to an existing disk file.
- filecatalog -- The filecatalog statement creates a list of files in a folder, including any subfolders of that folder
- fileerase -- The fileerase statement erases a disk file or a folder, removing it from the hard disk.
- fileglobal -- The fileglobal statement creates one or more fileglobal variables.
- filemenubar -- The filemenubar statement creates a custom menu bar or context menu for the current database (see Custom Menus).
- filerename -- The filerename statement renames and/or moves a file or folder.
- filesave -- The filesave statement saves data directly into a disk file.
- fill -- The fill statement fills every visible cell in the active field with the specified value.
- fillall -- The fillall statement modifies the operation of the following fill statement so that all records are modified, not just visible records.
- find -- The find statement locates the first visible record in the active database for which the specified condition is true.
- findabove -- The findabove statement locates the next previous record (above the current record) in the active database for which the specified condition is true.
- findbackwards -- The findbackwards statement locates the last visible record in the active database for which the specified condition is true.
- findbelow -- The findbelow statement locates the next visible record (below the current record) in the active database for which the specified condition is true.
- findid -- The findid statement locates a record in the active database by its ID number (see info("serverrecordid").
- findnth -- The findnth statement finds the nth (2nd, 3rd, 4th, etc.) record that matches a true-false test.
- findopendialog -- The findopendialog statement opens the standard Find & Open dialog.
- findrelated -- The findrelated statement finds information that matches the current record in a related database.
- findreplacedialog -- The findreplacedialog statement opens the Find & Replace dialog.
- findselect -- The findselect statement opens the standard Find/Select dialog.
- findselectdialog -- The findselectdialog statement opens the standard Find/Select dialog.
- finishtimecheck -- The finishtimecheck statement finishes a performance monitoring session.
- firstcolumn -- The firstcolumn statement moves to the first column in the data sheet (leftmost column).
- firstrecord -- The firstrecord statement makes the first visible (selected) record in the database the active record.
- fixsuperdates -- The fixsuperdates statement fixes Panorama 6 SuperDates in current field.
- folderinfo -- The folderinfo statement calculates the total size of a folder, and the number of files in the folder.
- fontinformation -- The fontinformation statement accesses information about a font (see also the fontinfo( function).
- for -- The for statement is used at the beginning of a loop that loops a fixed number of times.
- forcelockrecord -- The forcelockrecord statement immediately locks the current record.
- forcesynchronize -- The forcesynchronize statement force synchronizes the local database with Panorama Server (downloads all records, not just recently modified ones).
- forcesynchronizeall -- The forcesynchronizeall statement force synchronizes all open databases.
- forceunlockallrecords -- The forceunlockallrecords statement immediately unlocks all records in the current database.
- forceunlockdatabaserecord -- The forceunlockdatabaserecord statement immediately unlocks an arbitrary record in the specified server database.
- forceunlockrecord -- The forceunlockrecord statement immediately unlocks the current record.
- formblueprint -- The formblueprint statement creates blueprint code for the specified form.
- formblueprintsheet -- The formblueprintsheet statement opens a sheet to edit the blueprint of the current form.
- formcleanview -- The formcleanview statement cleans up extraneous NSView objects in the current form.
- formcolor -- The formcolor statement changes the background color of the current form.
- formconstructordialog -- The formconstructordialog statement opens a generic form constructor dialog.
- formobjectblueprint -- The formobjectblueprint statement creates blueprint code for specified form object.
- formoptionsblueprintsheet -- The formoptionsblueprintsheet statement opens a dialog sheet to edit the blueprint of the current form options.
- formtodatamode -- The formtodatamode statement switches the current form window to data mode.
- formtographicsmode -- The formtographicsmode statement switches the current form window to graphics mode.
- formulabuffer -- The formulabuffer statement does nothing.
- formulacalc -- The formulacalc statement allows you to evaluate a formula that you were not able to code into the procedure when it was being written.
- formulafill -- The formulafill statement fills every visible cell in the active field with the result of the specified formula.
- formulafillallfields -- The formulafillallfields statement fills every visible cell in all fields with the result of the specified formula.
- formulamerge -- The formulamerge statement merges data into a template.
- formulasum -- The formulasum statement calculates a total by scanning a database, returning the accumulated sum of evaluating a formula over and over again for each scanned record.
- formulavalue -- The formulavalue statement calculates the result of a formula. Usually this is done with an assignment statement (for example `x=2 * y` ), but the formulavalue statement gives you more flexibility. You can specify what database is to be used for the calculation (an assignment statement always uses the current database) and you can specify the formula using a variable, making it easy to change on the fly. This statement also gives you more control over how errors are handled.
- formxy -- The formxy statement programmatically scrolls a form to a new position.
- getaddress -- The getaddress statement divides the last line of an address into separate components.
- getautonumber -- The getautonumber statement returns the automatically generated number for the next record that will be added to the database.
- getbutton -- The getbutton statement retrieves the coordinates of the last button that was pressed (in global screen co-ordinates).
- getcitystatezip -- The getcitystatezip statement divides the last line of an address into separate components.
- getclick -- The getclick statement returns the location of the mouse in global coordinates (coordinates from the top left corner of the screen).
- getdictionarykey -- The getdictionarykey statement returns the key of an item in the dictionary, given its value. This is essentially the opposite of the getdictionaryvalue( function (see Data Dictionaries).
- getdictionaryvalue -- The getdictionaryvalue statement returns the value of an item in the dictionary, given its key (see Data Dictionaries).
- getfieldproperties -- The getfieldproperties statement returns a dictionary that contains all of the properties of the specified field.
- getformulatext -- The getformulatext statement converts a formula into text without special quote characters.
- getinternalbutton -- The getinternalbutton statement retrieves the coordinates of the last button that was pressed (in form relative coordinates).
- getlocalbutton -- The getlocalbutton statement retrieves the coordinates of the last button that was pressed (in window relative coordinates).
- getlocalclick -- The getlocalclick statement returns the location of the most recent mouse click in local coordinates (coordinates from the top left corner of the current form).
- getmaxwindow -- The getmaxwindow statement retrieves the position and size of the largest possible window on the main screen.
- getname -- The getname statement divides a person's full name into separate components.
- getproceduretext -- The getproceduretext statement gets the contents (source) of a procedure and places it in a variable.
- getscrap -- The getscrap statement will display a dialog with a text entry area. The entered text is placed in the clipboard.
- getscrapok -- The getscrapok statement will display a dialog with a text entry area. The entered text is placed in the clipboard.
- getserverlog -- The getserverlog statement retrieves information from one or more server logs.
- gettaglocation -- The gettaglocation statement locates the first matching tag within some text.
- gettaglocations -- The gettaglocations statement locates all matching tags within some text.
- gettext -- The gettext statement will display a dialog with a text entry area.
- gettextdialog -- The gettextdialog statement displays a configurable modal dialog that asks the user to enter an item of text.
- gettextokcancel -- The gettextokcancel statement displays a modal dialog that asks the user to enter an item of text.
- getwebcolor -- The getwebcolor statement will calculate an RGB color from a Netscape style web color.
- getwebtabletemplate -- The getwebtabletemplate statement converts a web table template (created by the Text Export Wizard) into the format compatible with the HTMLDataTable statement.
- getwebtemplate -- The getwebtemplate statement retrieves the web template (a dictionary) associated with a form (if any).
- getwebtemplatetext -- The getwebtemplatetext statement retrieves the text of the web template (a dictionary) associated with a form (if any).
- getwindow -- The getwindow statement retrieves the position and size of the current window.
- giantmessage -- The giantmessage statement displays a message alert.
- global -- The global statement creates one or more global variables.
- globaldictionarybuild -- The globaldictionarybuild statement builds a global dictionary by scanning a database.
- globalmenubar -- The globalmenubar statement creates a custom menu bar or context menu for all windows (intended only for internal use by ProVUE Development).
- goform -- The goform statement switches the current window to a different form.
- goto -- The goto statement allows a procedure to arbitrarily jump from one spot to another within the procedure.
- gotofielddialog -- The gotofielddialog statement opens the standard dialog for jumping to a specific field (in the Fields menu).
- grabformula -- The grabformula statement evaluates a formula using data from another database.
- grabwebformitems -- The grabwebformitems statement grabs multiple web form items and stuffs the values into fields and/or variables.
- graphicsmode -- The graphicsmode statement switches a form into graphics mode.
- groupdown -- The groupdown statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in descending order (high to low).
- groupup -- The groupup statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in ascending order (low to high).
- growl -- The growl statement displays a notification.
- growlmessage -- The growlmessage statement displays a notification.
- hide -- The hide statement temporarily disables the output of text and graphics.
- hideaccessorypanel -- The hideaccessorypanel statement closes the current window's accessory panel.
- hidecurrentfield -- The hidecurrentfield statement hides the current field in the data sheet.
- hidefieldsbetween -- The hidefieldsbetween statement shows all fields except those in between specified numbers.
- hidelineitemfields -- The hidelineitemfields statement hides all line item fields.
- hideotherapplications -- The hideotherapplications statement hides all other applications, leaving only Panorama visible.
- hidepanorama -- The hidepanorama statement hides Panorama X, making all windows disappear.
- hidethesefields -- The hidethesefields statement hides specific fields in the data sheet, making all others visible.
- 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.
- htmlarraytable -- The htmlarraytable statement generates an HTML table from an arrray.
- htmldatamerge -- The htmldatamerge statement uses a template to generate HTML you want from a database.
- htmldatatable -- The htmldatatable statement generates an HTML table from selected data in the current database.
- htmlextractimages -- The htmlextractimages statement extracts the image URLs from an HTML page.
- htmlextractlinks -- The htmlextractlinks statement extracts the links from an HTML page.
- htmlformitemnames -- The htmlformitemnames statement returns a list of form input elements (INPUT tags, etc.) within an HTML page.
- htmltabletoarray -- The htmltabletoarray statement converts an HTML table into a text array.
- if -- The if statement decides what code to execute next.
- ifselect -- The ifselect statement combines the select and if info("empty") operations into a single statement.
- importdatabase -- The importdatabase statement imports data from another database into the current database.
- importdatabasedialog -- The importdatabasedialog statement opens the standard Import Database dialog.
- importdictprocedures -- The importdictprocedures statement converts source code exported by the ExportAllProcedures statement into a dictionary.
- importform -- The importform statement imports a form into a database.
- importjson -- The importjson statement imports a JSON array into the current database.
- importjsonline -- The importjsonline statement imports a JSON record into the current record.
- importline -- The importline statement imports a line of text into the current record.
- importprocedure -- The importprocedure statement imports a procedure into a database.
- importrawdata -- The importrawdata statement imports raw binary data into an existing database.
- importtext -- The importtext statement imports text into an existing database.
- increment -- The increment statement increments a field or variable.
- insertbelow -- The insertbelow statement inserts a new record below the current record.
- insertbelowcarriagereturn -- The insertbelowcarriagereturn statement inserts a new record below the current record and moves to the first column.
- insertfield -- The insertfield statement inserts a new field into the database in front of the current field.
- insertnewproceduremark -- The insertnewproceduremark statement inserts a new mark into the current procedure.
- insertrecord -- The insertrecord statement inserts a new record above the current record.
- installpanoramacgi -- The installpanoramacgi statement installs Panoramax.cgi for use with external web server.
- ipaddress -- The ipaddress statement returns the current IP address of the computer, or "" if not connected.
- 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.
- lastcolumn -- The lastcolumn statement move to the last column in the data sheet (rightmost column).
- lastrecord -- The lastrecord statement makes the last visible (selected) record in the database the active record.
- launch -- The launch statement launches an application.
- left -- The left statement makes the previous field active in the active window.
- 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.
- listdictionarynames -- The listdictionarynames statement returns a list of the names (keys) in a dictionary (see Data Dictionaries).
- listwebtables -- The listwebtables statement generates a list of web tables (generated by the Text Export wizard) in the specified database.
- listwebtemplates -- The listwebtemplates statement retrieves a list of web templates in the specified database, if any.
- loadallprocedures -- The loadallprocedures statement loads all the procedures from a dictionary into the current database. If a procedure doesn't exist it will be created.
- loadcustomfunctions -- The loadcustomfunctions statement reloads all ProVUE defined custom functions.
- loadlibrary -- The loadlibrary statement loads a library database into memory.
- loadurl -- The loadurl statement loads a resource from the internet.
- local -- The local statement creates one or more local variables.
- localparameters -- The localparameters statement creates one or more local variables and assigns parameter values to them.
- lockedrecordlist -- The lockedrecordlist statement returns a list of records locked in the current database.
- lockorstop -- The lockorstop statement attempts to lock the current record. If the record is currently locked by another user, the procedure stops with an error
- lockrecord -- The lockrecord statement attempts to lock the current record, and waits if it is currently locked by another user.
- loop -- The loop statement is used at the beginning of a loop.
- looparray -- The looparray statement is used at the beginning of a loop that loops over the elements of an array.
- loopdataarray -- The loopdataarray statement is used at the beginning of a loop that loops over the elements of a data array.
- loopindex -- The loopindex statement allows a procedure to determine how many times a loop has been repeated.
- loopwhile -- The loopwhile statement is used at the beginning of a loop.
- macoscomputername -- The macoscomputername statement returns the name of this computer.
- mactoutf8 -- The mactoutf8 statement translates text from Panorama format to UTF8 (Unicode).
- magicformwindow -- The magicformwindow statement designates an open window as the temporary active window for the purposes of info( functions and graphic statements.
- magicwindow -- The magicwindow statement designates an open window as the temporary active window for the purposes of info( functions and graphic statements.
- magnification -- The magnification statement changes the magnification of a form.
- makeabsolutepath -- The makeabsolutepath statement converts a relative path (relative to the current database) to an absolute path.
- makefileglobals -- The makefileglobals statement creates one or more fileglobal variables, and assigns a value to each new variable.
- makefilesecret -- The makefilesecret statement closes all of the windows associated with a file, but keeps the file open in memory.
- makefolder -- The makefolder statement creates a new folder, and if necessary, also creates any enclosing folders needed to create the specified new folder.
- makeformwebtemplate -- The makeformwebtemplate statement converts a Panorama form into the equivalent HTML/CSS.
- makeglobals -- The makeglobals statement creates one or more global variables, and assigns a value to each new variable.
- makelocals -- The makelocals statement creates one or more local variables, and assigns a value to each new variable.
- makemergeformula -- The makemergeformula statement makes a formula from a template.
- makenewform -- The makenewform statement creates a new form in the current database.
- makenewprocedure -- The makenewprocedure statement creates a new procedure in the current database.
- makenumberedarray -- The makenumberedarray statement generates a numeric sequenced text array.
- makepackage -- The makepackage statement creates a new package, and if necessary, also creates any enclosing folders needed to create the specified new package.
- makesecret -- The makesecret statement makes the current database disappear, while leaving it open in memory.
- matrixbutton -- The matrixbutton statement helps implement buttons in a matrix object.
- matrixbuttonhelper -- The matrixbuttonhelper statement helps implement buttons in a matrix object.
- matrixclick -- The matrixclick statement will run the code belonging to an object that was clicked within a matrix frame.
- matrixclickedobjectid -- The matrixclickedobjectid statement helps implement buttons in a matrix object.
- matrixredrawclickedcell -- The matrixredrawclickedcell statement redraws the matrix cell that was just clicked.
- maximum -- The maximum statement calculates the maximum and sub-maximums for the current field.
- mergedictionaries -- The mergedictionaries statement merges the contents of two or more dictionaries (see Data Dictionaries).
- mergefieldsdialog -- The mergefieldsdialog statement opens the standard Merge Fields dialog.
- message -- The message statement displays a modal alert window with a message.
- minimum -- The minimum statement calculates the minimum and sub-minimums for the current field.
- modifyfileattributes -- The modifyfileattributes statement modifies one or more attributes of a file (or folder).
- 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.
- moveobjects -- The moveobjects statement will move an object or group of objects up, down, left or right on the form.
- moverecorddown -- The moverecorddown statement moves the current record down one line.
- moverecordup -- The moverecordup statement moves the current record up one line.
- newdatabase -- The newdatabase statement creates a new database.
- newdatabaseusingblueprint -- The newdatabaseusingblueprint statement creates a new database from a blueprint.
- newdatabasewithfields -- The newdatabasewithfields statement creates a new database with one or more fields.
- newdatabasewithjson -- The newdatabasewithjson statement creates a new database using a JSON file.
- newdatabasewithtemplate -- The newdatabasewithtemplate statement creates a new database with a template.
- newdatabasewithtextfieldnames -- The newdatabasewithtextfieldnames statement creates a new database from a text file. The text file must contain the field names in the first line.
- newdatabasewithtextfile -- The newdatabasewithtextfile statement creates a new database from a plain text file. The fields will be named A, B, C, etc.
- newformobject -- The newformobject statement creates a new graphic object in a form.
- newformusingblueprint -- The newformusingblueprint statement creates a new form from a blueprint.
- newsearchgadget -- The newsearchgadget statement creates a search gadget in the current form.
- nextmatch -- The nextmatch statement locates the next visible record in the active database for which the condition specified in the most recent Find statement is true.
- nextvalue -- The nextvalue statement advances a variable or field to the next value in a list.
- noimplicitassignment -- The noimplicitassignment statement does nothing, and is only retained for compatibility with earlier versions.
- nop -- The nop statement does nothing (*n*o *op*eration).
- normalexpressionstack -- The normalexpressionstack statement does nothing.
- noshow -- The noshow statement temporarily disables the output of text and graphics.
- noundo -- The noundo statement does nothing (it used to disable undo).
- nowatchcursor -- The nowatchcursor statement does nothing, and is only retained for compatibility with earlier versions.
- noyes -- The noyes statement displays a modal alert window with a message and two buttons: No and Yes.
- nslog -- The nslog statement sends a message to the console log.
- nsnotify -- The nsnotify statement delivers a notification.
- object -- The object statement selects an object (based on the object name).
- objectaction -- The objectaction statement allows a procedure to communicate with an object on the current form.
- objectid -- The objectid statement selects one graphic object in the current form based on an ID number.
- objectnumber -- The objectnumber statement identifies one graphic object from a set of selected graphic objects in the current form.
- okcancel -- The okcancel statement displays a modal alert window with a message and two buttons: Ok and Cancel.
- onerror -- The onerror statement can be used to catch all errors that are not trapped by if error or try statements.
- onfailedresume -- The onfailedresume statement is used to setup a semi-graceful recovery if a resume statement fails because there was no pause statement.
- openanything -- The openanything statement opens a document or application.
- openasyncprogresswindow -- The openasyncprogresswindow statement opens a floating progress window for asynchronous operations (urltask(, timers).
- openclonewindow -- The openclonewindow statement opens a clone of the current window.
- opendatabase -- The opendatabase statement opens a database file.
- opendialog -- The opendialog statement opens a form from the current database as a modal dialog box.
- opendialogsheet -- The opendialogsheet statement opens a form from the current database as a sheet dialog (attached to the current window).
- openfarform -- The openfarform statement opens a form in another database.
- openfile -- The openfile statement opens a database file. It can also import data from a text file, another database, or a variable into the current database.
- openfiledialog -- The openfiledialog statement pauses and displays the standard “open file” dialog.
- openform -- The openform statement opens a form in the current database in a new window.
- openlivecoursecalendar -- The openlivecoursecalendar statement Opens the Live Course Calendar window.
- openmapwindow -- The openmapwindow statement opens a window displaying a map of a location.
- openplain -- The openplain statement opens a database without opening any pre-saved windows, just the data sheet.
- openpreferenceswindow -- The openpreferenceswindow statement opens the Panorama Preferences window.
- openprocedure -- The openprocedure statement opens a procedure in the current database in a new window.
- opensavedwindows -- The opensavedwindows statement opens windows that were open the last time file was saved.
- opensecret -- The opensecret statement opens a database invisibly, without opening its windows.
- openserverfile -- The openserverfile statement opens a database (used on the server).
- opensheet -- The opensheet statement opens the data sheet window for the current database in a new window.
- opensoftwareupdatewindow -- The opensoftwareupdatewindow statement opens the Panorama Software Update window.
- opentextfile -- The opentextfile statement imports data from a text file or a variable into the current database.
- openurl -- The openurl statement opens a URL (usually a web page or to create an e-mail message).
- openurlinbackground -- The openurlinbackground statement opens a URL (usually a web page or to create an e-mail message) without bringing forward the app that handles the URL (in other words, Panorama remains the frontmost application).
- openviewdialog -- The openviewdialog statement opens the standard Open View dialog (in the View Menu).
- openviewsearch -- The openviewsearch statement opens a View Search window.
- openwebmap -- The openwebmap statement opens a web browser window displaying a map of a location.
- openwith -- The openwith statement opens a document with a specific application.
- openwithterminal -- The openwithterminal statement opens an application in a new Terminal.app window (useful for debugging).
- openwizard -- The openwizard statement opens a wizard, just as it would be opened by selecting that wizard from the menubar.
- originalwindow -- The originalwindow statement goes back to the window remembered by the RememberWindow statement.
- outlinelevel -- The outlinelevel statement expands or collapses the entire database to show a specific level of data or summary level.
- pagesetup -- The pagesetup statement displays the page setup dialog.
- panoramaappvisibility -- The panoramaappvisibility statement allows the Panorama X dock and menu bar to be hidden.
- panoramastartupdatabases -- The panoramastartupdatabases statement opens any databases specified for startup.
- partialdatabaseupdate -- The partialdatabaseupdate statement updates one or more components of an existing database.
- paste -- The paste statement pastes the contents of the clipboard into the current field.
- pastecell -- The pastecell statement pastes the contents of the clipboard into the current cell.
- pasteline -- The pasteline statement inserts a new record containing the contents of the clipboard.
- pasterecord -- The pasterecord statement inserts a new record containing the contents of the clipboard.
- pause -- The pause statement temporarily pauses a procedure.
- pausespeaking -- The pausespeaking statement pauses any talking that is currently happening.
- perl -- The perl statement executes a Perl script (program).
- permanent -- The permanent statement creates one or more permanent variables.
- php -- The php statement executes a PHP script (program).
- playsound -- The playsound statement starts playing a sound file.
- pleaseselectall -- The pleaseselectall statement makes sure that all records are selected.
- popup -- The popup statement makes a pop-up menu appear anywhere on the screen.
- popupatmouse -- The popupatmouse statement displays a pop-up menu at the current mouse location.
- popupbelowbutton -- The popupbelowbutton statement displays a pop-up menu in response to clicking on a button.
- popupbutton -- The popupbutton statement displays a pop-up menu in response to clicking on a button.
- popupbynumber -- The popupbynumber statement makes a pop-up menu appear anywhere on the screen.
- popupclick -- The popupclick statement displays a pop-up menu at the current mouse location.
- popupdoublefieldchoices -- The popupdoublefieldchoices statement displays a pop-up menu listing values in a specified field, with submenus containing values from a second field.
- popupfieldchoices -- The popupfieldchoices statement displays a pop-up menu listing values in a specified field.
- popupsharingmenu -- The popupsharingmenu statement pops up a menu for the toolbar sharing icon.
- posixtask -- The posixtask statement executes a POSIX shell script in the background using NSTask.
- post -- The post statement assigns a value to a field in another database.
- postadjust -- The postadjust statement adjusts the value of a numeric field in another database, by adding (or subtracting) a number.
- posttorelated -- The posttorelated statement posts data in the current record to the corresponding record in a related database.
- posturl -- The posturl statement loads a resource from the internet, with form data.
- previousmatch -- The previousmatch statement locates the previous (closer to the top) visible record in the active database for which the condition specified in the most recent Find statement is true.
- print -- The print statement prints the database.
- printonemultiple -- The printonemultiple statement prints a form over and over again without advancing from record to record. Instead of advancing from record to record, a variable is incremented each time the form is printed. This statement is designed for printing calendars or thumbnails.
- printonerecord -- The printonerecord statement prints the the currently active record.
- printpdf -- The printpdf statement prints the current database to a PDF file.
- printpreview -- The printpreview statement previews what printing the current window will look like.
- printpreviewonerecord -- The printpreviewonerecord statement previews what printing the current record will look like.
- printtopdf -- The printtopdf statement prints the current database to a PDF file.
- printusingform -- The printusingform statement allows the current database to be printed using a different form than the one currently being displayed.
- 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.
- progressalert -- The progressalert statement displays a progress alert if an operation is going to take a long time.
- progressbar -- The progressbar statement updates a progress bar on the current form.
- propagate -- The propagate statement fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell above it.
- propagateup -- The propagateup statement fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell below it.
- provueserverisup -- The provueserverisup statement checks whether provue.com is online and operating.
- python -- The python statement executes a Python script (program).
- quit -- The quit statement quits Panorama.
- radian -- The radian statement tells Panorama that all angles in trigonometric functions should be calculated using radians rather than degrees.
- 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.
- refreshcrosstabdatabase -- The refreshcrosstabdatabase statement refreshes a crosstab database.
- refreshsummarydatabase -- The refreshsummarydatabase statement refreshes a summary database.
- registercustomfunction -- The registercustomfunction statement defines a new custom function.
- rememberwindow -- The rememberwindow statement remembers the currently active window, so that you can get back to it later.
- removeallsummaries -- The removeallsummaries statement removes all summary records.
- removedetail -- The removedetail statement removes data records from the current database, leaving only summary records. It can also delete low level summary records, leaving only higher levels.
- removepreferencevalues -- The removepreferencevalues statement deletes one or more preference values.
- removeremotehost -- The removeremotehost statement makes a remote host unavailable to this computer.
- removeselected -- The removeselected statement deletes all selected records from the database.
- removesummaries -- The removesummaries statement removes summary records from the current database.
- removeunselected -- The removeunselected statement deletes all unselected records from the database.
- renderwebform -- The renderwebform statement renders a Panorama web form into HTML, merging data into the template as necessary.
- renderwebtable -- The renderwebtable statement renders a web table using records selected with WebSelect in the current database.
- reorderfieldsdialog -- The reorderfieldsdialog statement opens the Reorder Fields dialog.
- repeatloopif -- The repeatloopif statement decides whether to continue with a loop or to start over again from the top.
- resetallrecordidts -- The resetallrecordidts statement resets the internal record id and time stamps for every record in the current database.
- resume -- The resume statement resumes a procedure that has been temporarily halted with the pause statement.
- resumeaftertask -- The resumeaftertask statement resumes after a waitfortask statement.
- resumespeaking -- The resumespeaking statement resumes speaking after a pause.
- resynchronize -- The resynchronize statement synchronizes the local database with Panorama Server. This is the same as choosing Synchronize from the File menu.
- retrywebform -- The retrywebform statement retries a web form that has missing or invalid data.
- return -- The return statement ends a subroutine.
- returnerror -- The returnerror statement passes an error back to the current subroutines calling procedure.
- revealinfinder -- The revealinfinder statement reveals a file or folder in the Finder.
- revealmultipleinfinder -- The revealmultipleinfinder statement reveals one or more files or folders in the Finder.
- reverseorder -- The reverseorder statement reverses the order of the records in the database.
- revert -- The revert statement reloads the last saved version of the database from the disk.
- right -- The right statement moves the cursor to the next field in the active window.
- ruby -- The ruby statement executes a Ruby script (program).
- rudemessage -- The rudemessage statement displays a message alert.
- runcustommenu -- The runcustommenu statement runs the *.CustomMenu* procedure.
- rundialog -- The rundialog statement uses a form as a template to display a modal dialog window. The statement supervises the operation of the dialog until it is closed.
- rundialogmenus -- The rundialogmenus statement enables custom menus in a modal dialog.
- runfieldcalculations -- The runfieldcalculations statement performs any automatic calculations associated with the current field.
- runfieldcode -- The runfieldcode statement runs the automatic code associated with the specified field.
- runfieldsideeffects -- The runfieldsideeffects statement performs any side effects associated with the current field (calculations, procedures, etc.).
- runmodifyfill -- The runmodifyfill statement runs the .ModifyFill procedure (if it exists).
- runningdifference -- The runningdifference statement calculates the running difference for the current field.
- runningtotal -- The runningtotal statement calculates the running total for the current field.
- safefileerase -- The safefileerase statement deletes a file if it exists, but no error if it doesn't exist.
- safeselect -- The safeselect statement makes visible only those records for the active database for which the specified condition is true. If no records match, the previous selection is retained.
- safeselectwithin -- The safeselectwithin statement makes visible only those previously selected records in the active database for which the specified condition is true. If no records match, the previous selection is retained.
- save -- The save statement saves the database to disk.
- saveacopyas -- The saveacopyas statement saves a copy of the currently active file under a new name. The original database remains open in memory under its original name.
- saveallprocedures -- The saveallprocedures statement saves all the procedures in the specified database into a dictionary.
- saveandclose -- The saveandclose statement saves and closes a database file.
- saveas -- The saveas statement saves a copy of the currently active file under a new name. The original file remains unchanged.
- saveblueprint -- The saveblueprint statement save a blueprint of a database's structure.
- savedialog -- The savedialog statement displays a modal dialog that allows a user to specify the name and location of a new file.
- savefiledialog -- The savefiledialog statement pauses a procedure and displays the standard “save file” dialog.
- savelocalvariables -- The savelocalvariables statement saves local variables as a procedure.
- saveoneprocedure -- The saveoneprocedure statement saves a specific procedure in the specified database into a dictionary.
- saveopenprocedures -- The saveopenprocedures statement saves all the open procedures in the specified database into a dictionary.
- savepartialdatabase -- The savepartialdatabase statement saves specified components of the current database, leaving other components out.
- savewebtemplate -- The savewebtemplate statement saves a web template (a dictionary) associated with a form.
- scaleselectedobjects -- The scaleselectedobjects statement scale the selected objects by a specified factor.
- scanlibraries -- The scanlibraries statement scans all libraries and registers all of the custom statements in them.
- scanlibrary -- The scanlibrary statement scans a library and registers all of the custom statements in it.
- scrapcalc -- The scrapcalc statement calculates a formula and stores the result in the clipboard. (Note: The same effect can be achieved by putting the word clipboard on the left side of an assignment.)
- scriptbglog -- The scriptbglog statement specifies a path/file for output from STDOUT from embedded programs run in the background (Perl, Ruby, Python, PHP).
- scripttimeout -- The scripttimeout statement sets the maximum runtime allowed for an embedded program (AppleScript, ShellScript, Perl, Ruby or Python).
- select -- The select statement makes visible only those records for the active database for which the specified condition is true.
- selectadditional -- The selectadditional statement adds unselected records to a previously selected group if they match the true-false test.
- selectall -- The selectall statement makes every record in the database visible.
- selectallobjects -- The selectallobjects statement selects all the graphic objects in the current form.
- selectduplicates -- The selectduplicates statement selects records containing duplicate information in the database.
- selectduplicatesdialog -- The selectduplicatesdialog statement opens the standard Select Duplicates dialog.
- selectduplicatesnowarning -- The selectduplicatesnowarning statement selects records containing duplicate information in the database.
- selectedformobjectsblueprintsheet -- The selectedformobjectsblueprintsheet statement opens a sheet to edit the blueprint of the currently selected objects.
- selectnoobjects -- The selectnoobjects statement unselects all the graphic objects in the current form.
- selectobjects -- The selectobjects statement uses a formula to select one or more objects in the current form.
- selectrecordsrelatedto -- The selectrecordsrelatedto statement selects records in the current database that are related to any record in another database.
- selectrelated -- The selectrelated statement selects information that matches the current record in a related database.
- selectreverse -- The selectreverse statement makes every visible record invisible, and every invisible record visible.
- selectwithin -- The selectwithin statement uses a Boolean formula to exclude records from a previously selected group.
- selectzipdistancetool -- The selectzipdistancetool statement selects records near the current record, based on zip codes.
- sendaction -- The sendaction statement sends an action message to the Cocoa responder chain.
- sendarrayemail -- The sendarrayemail statement sends a single e-mail to multiple recipients.
- sendbackward -- The sendbackward statement sends the selected form objects one layer towards the back.
- sendbulkemail -- The sendbulkemail statement sends a single e-mail to multiple recipients.
- sendemail -- The sendemail statement sends an e-mail. It gives access to the maximum number of options available.
- sendoneemail -- The sendoneemail statement sends a single e-mail to a single recipient.
- sendtoback -- The sendtoback statement sends the selected form objects to the back.
- sequence -- The sequence statement fills every visible cell in the current field with a numeric sequence.
- serverdatabaseconsoledump -- The serverdatabaseconsoledump statement dumps the raw contents of the specified database on the server to the console in comma delimited format.
- serverformulafill -- The serverformulafill statement fills a specified subset of records in a shared database.
- serverjournalcode -- The serverjournalcode statement writes code to journal file.
- serverjournalcurrentrecord -- The serverjournalcurrentrecord statement writes the current record to journal file.
- serverlog -- The serverlog statement adds a line to one or more server logs.
- serverupdate -- The serverupdate statement temporarily disables record locking and server updates when using a shared database.
- set -- The set statement performs an assignment, much like an equals sign or the assign statement. However, the destination of the assignment can be calculated on the fly.
- setactivedatabase -- The setactivedatabase statement makes a database active (without changing the configuration of the windows).
- setappleeventvalue -- The setappleeventvalue statement may be used in a procedure that responds to an AppleEvent (this includes AppleScript programs), the statement specifies the value to be returned by the event.
- setautonumber -- The setautonumber statement changes the automatically generated number for the next record that will be added to database. This allows you to generate numbers out of sequence, or to start the sequence at a specific value.
- setbannericon -- The setbannericon statement sets the icon on the right side of the toolbar banner.
- setbannermessage -- The setbannermessage statement sets the text in the toolbar banner to an arbitrary message.
- setbannerprogressbar -- The setbannerprogressbar statement displays progress in the toolbar banner.
- setcookie -- The setcookie statement set the value of a cookie to send back to the client..
- setdatabaseoptions -- The setdatabaseoptions statement modifies one or more properties of a database.
- setdialogtrigger -- The setdialogtrigger statement changes the value returned by the info("dialogtrigger") function.
- setdictionaryvalue -- The setdictionaryvalue statement changes a value in a dictionary (see Data Dictionaries).
- seterror -- The seterror statement changes the error message returned by info("error").
- setfield -- The setfield statement performs an assignment, much like an equals sign or the assign statement. However, the destination field of the assignment can be calculated on the fly.
- setfieldnames -- The setfieldnames statement changes the names of all database fields at once.
- setfieldproperties -- The setfieldproperties statement modifies one or more properties (name, data type, formula, etc.) of the current field.
- setfileglobal -- The setfileglobal statement sets the value of a fileglobal variable (optionally in another database).
- setfilevariable -- The setfilevariable statement sets the value of a fileglobal variable in another database.
- setformcustompreference -- The setformcustompreference statement sets the value of a form custom preference.
- setformoptions -- The setformoptions statement modifies one or more properties of a form (name, viewing mode, etc.).
- setglobal -- The setglobal statement sets a value into a global variable. The name of the global variable is calculated on the fly.
- setglobaldictionaryvalues -- The setglobaldictionaryvalues statement sets one or more key/value pairs in a global dictionary.
- sethiddenwebformitem -- The sethiddenwebformitem statement adds a hidden field to a form on a web page.
- setlocal -- The setlocal statement sets a value into a local variable. The name of the local variable is calculated on the fly.
- setlocalsfromdictionary -- The setlocalsfromdictionary statement converts a dictionary into a collection of local variables. The names and values of the local variables will be derived from the dictionary contents.
- setparameter -- The setparameter statement is used to transfer data from a subroutine back to the main procedure that called it.
- setpermanentvariable -- The setpermanentvariable statement sets the value of a permanent variable in another database. The database must be open. An empty value will choose the currently active database.
- setpreferencevalues -- The setpreferencevalues statement creates and/or modifies a preference value.
- setprocedureoptions -- The setprocedureoptions statement modifies one or more properties of a procedure (source code, Action menu options, etc.).
- setproceduretext -- The setproceduretext statement changes the text of the currently open procedure.
- setrectedges -- The setrectedges statement changes the edges of the specified rectangle.
- setreportcolumns -- The setreportcolumns statement allows a procedure to control the number of columns of a report, and the direction (across or down).
- settagdata -- The settagdata statement changes the contents of a tag.
- settagparameter -- The settagparameter statement sets the value of a tag parameter in a list of tag parameters.
- settimechecklongtime -- The settimechecklongtime statement sets the threshold for a slow task during a performance monitoring session.
- settrigger -- The settrigger statement changes the value returned by the info("trigger") function.
- setwaitinglocal -- The setwaitinglocal statement assigns a value to a local variable in the parent procedure of an asynchronous task, allowing the asynchronouse code to pass a value back to the code that spawned it.
- setwindow -- The setwindow statement specifies the dimensions (size and location) of the next window that is opened (with openform, opensheet, openprocedure etc.).
- setwindowglobal -- The setwindowglobal statement sets the value of a windowglobal variable (optionally in another window).
- setwindowoptions -- The setwindowoptions statement changes the attributes of the current window (tool bar, scroll bars, etc.).
- setwindowrectangle -- The setwindowrectangle statement specifies the dimensions of the next window that is opened by a procedure.
- setxtagvalue -- The setxtagvalue statement changes the contents of a tag.
- setzlog -- The setzlog statement turns instrumentation coverage on or off for a specific procedure (or all procedures within a database).
- shellscript -- The shellscript statement executes a UNIX shell script.
- shellscriptwithterminal -- The shellscriptwithterminal statement runs a shell script in a new Terminal.app window (useful for debugging).
- shortcall -- The shortcall statement allows a procedure to call a sequence of statements within the current procedure as a "mini-subroutine".
- show -- The show statement resumes the output of text and graphics after it has been disabled and then forces Panorama to redisplay all windows in the current database.
- showaccessorypanel -- The showaccessorypanel statement opens the current window's accessory panel.
- showallfields -- The showallfields statement makes every field in the data sheet visible.
- showcolumns -- The showcolumns statement forces Panorama to display specified fields.
- showfields -- The showfields statement forces Panorama to display specified fields.
- showfieldsbetween -- The showfieldsbetween statement hides all fields except those in between specified numbers.
- showhidefieldsdialog -- The showhidefieldsdialog statement opens the standard Show/Hide Fields dialog (in the Fields menu).
- showlater -- The showlater statement defers the display of text and graphics until the procedure is finished.
- showline -- The showline statement forces Panorama to redisplay the current record in all windows in the current database.
- showother -- The showother statement forces Panorama to update some data on the screen.
- showpage -- The showpage statement forces Panorama to redisplay all windows in the current database.
- showrecordcounter -- The showrecordcounter statement forces Panorama to redisplay the record counter in all windows in the current database.
- showrectangle -- The showrectangle statement refreshes all or part of the current form window.
- showthesefields -- The showthesefields statement makes specific fields in the data sheet visible, hiding all others.
- showvariables -- The showvariables statement forces Panorama to update the display of one or more variables on every form in the active database.
- showwindowvariables -- The showwindowvariables statement forces Panorama to update the display of one or more variables in the currently active form.
- size -- The size statement changes the data sheet text size.
- slidedata -- The slidedata statement slides the columns at and to the right of the current column.
- sortdialog -- The sortdialog statement opens the standard Sort dialog.
- sortdown -- The sortdown statement sorts the database by the current field. The database is sorted in descending order (high to low).
- sortdownwithin -- The sortdownwithin statement sorts the database by the current field, leaving any previous sorts intact. The database is sorted in descending order (high to low).
- sortup -- The sortup statement sorts the database by the current field. The database is sorted in ascending order (low to high).
- sortupwithin -- The sortupwithin statement sorts the database by the current field, leaving any previous sorts intact. The database is sorted in ascending order (low to high).
- speak -- The speak statement speaks a word or phrase.
- speakaddress -- The speakaddress statement buffers up a street address to be spoken later by the speaknow statement.
- speakcharacters -- The speakcharacters statement buffers up one or more characters to be spoken later by the speaknow statement.
- speakcharactersslowly -- The speakcharactersslowly statement buffers up one or more characters to be spoken later by the speaknow statement. Instead of speaking words, each individual character is spoken separately and slowly.
- speakdate -- The speakdate statement buffers up a date to be spoken later by the speaknow statement.
- speakdigitpairs -- The speakdigitpairs statement buffers up one or more digit pairs to be spoken later by the speaknow statement.
- speakdigits -- The speakdigits statement buffers up one or more digits to be spoken later by the speaknow statement.
- speakdollars -- The speakdollars statement buffers up a dollar amount to be spoken later by the speaknow statement.
- speakdollarsandcents -- The speakdollarsandcents statement buffers up a dollar and cents amount to be spoken later by the speaknow statement.
- speakletters -- The speakletters statement buffers up one or more characters to be spoken later by the speaknow statement. Letters will be spoken individually, as upper or lower case. Numbers will be spoken as individual digits.
- speaknow -- The speaknow statement speaks any buffered speech.
- speakphonenumber -- The speakphonenumber statement buffers up a phone number to be spoken later by the speaknow statement.
- speakscript -- The speakscript statement speaks a speech synthesis script created in the Database Options dialog.
- speakstate -- The speakstate statement buffers up a US State to be spoken later by the speaknow statement.
- speakthisrecord -- The speakthisrecord statement speaks the current record in the database (using the default speech script).
- speakwords -- The speakwords statement buffers up one or more words to be spoken later by the speaknow statement.
- speechrate -- The speechrate statement changes the speech rate (words per minute).
- speechscripts -- The speechscripts statement returns a lists of speech scripts in a database.
- speechvoice -- The speechvoice statement changes the default speech voice.
- speechvolume -- The speechvolume statement changes the default speech volume.
- speedcopy -- The speedcopy statement copies multiple adjacent fields from a record in one database to a record in another.
- splitfielddialog -- The splitfielddialog statement opens the standard Split Field dialog.
- splitlines -- The splitlines statement takes a chunk of text and splits it into two or more smaller chunks.
- splitmenutrigger -- The splitmenutrigger statement splits info("trigger") into separate menu name and menu item variables.
- startbonjour -- The startbonjour statement starts monitoring the local network for available hosts.
- startdatabasechange -- The startdatabasechange statement adds undo support to a procedure.
- startfilesystemmonitor -- The startfilesystemmonitor statement sets up and starts a repeating task that will be performed whenever a file and/or folder is modified.
- startgraphicschange -- The startgraphicschange statement adds undo support to a procedure.
- startnewdatabasegeneration -- The startnewdatabasegeneration statement starts a new generation of the current database to the server (must be a shared database).
- startstoprecorder -- The startstoprecorder statement starts or stops recording into the current procedure.
- starttimecheck -- The starttimecheck statement starts a performance monitoring session.
- starttimer -- The starttimer statement sets up and starts a repeating task that will be performed periodically when Panorama is not otherwise busy.
- startupdatecheck -- The startupdatecheck statement starts background check for available Panorama update.
- stashwebformitems -- The stashwebformitems statement takes the variables created with the GrabWebFormItems statement and assigns them to fields in the current record.
- statusmessage -- The statusmessage statement displays a message in the status bar at the bottom of the procedure window.
- stdout -- The stdout statement sends one or more characters to standard output.
- stop -- The stop statement stops all running procedures immediately.
- stopalert -- The stopalert statement displays a modal alert window with a warning icon, a message and one or more buttons.
- stopbonjour -- The stopbonjour statement cancels monitoring of the local network for available hosts.
- stopfilesystemmonitor -- The stopfilesystemmonitor statement stops a repeating task that has been set up to be performed whenever a file and/or folder is modified.
- stoploopif -- The stoploopif statement decides whether to continue with a loop or to exit the loop immediately.
- stopposixtask -- The stopposixtask statement stops a POSIX shell script that is running in the background.
- stopspeaking -- The stopspeaking statement stops any talking that is currently happening.
- stoptimer -- The stoptimer statement stops and deletes a timer that was set up with the StartTimer statement.
- stringreverse -- The stringreverse statement reverses the characters in a string of text. The original text is replaced in situ.
- summarydatabaseselectoriginal -- The summarydatabaseselectoriginal statement selects original data corresponding to a cell in an exported summary table database.
- summarylevel -- The summarylevel statement changes the summary level of the current line.
- summaryselectoriginalformula -- The summaryselectoriginalformula statement returns the formula that will select the original data associated with a summary table row.
- summarytablepopup -- The summarytablepopup statement handles a click on a summary table text list.
- superalert -- The superalert statement will display a custom alert.
- superarraybuild -- The superarraybuild statement scans a database to create a text array. This statement is is similar to arraybuild, but with a number of additional options (see Text Arrays).
- superchoicedialog -- The superchoicedialog statement will display a dialog with a list of choices that can be selected. You can control the size of the alert, as well as several appearance options. If the alert has more than one button, info("dialogtrigger") will contain the name of the button that was pressed.
- supergetpassword -- The supergetpassword statement will display a dialog with a text entry area for a password.
- supergettext -- The supergettext statement will display a dialog with a text entry area.
- synchronize -- The synchronize statement synchronizes the local database with Panorama Server. This is the same as choosing Synchronize from the File menu.
- synchronizeall -- The synchronizeall statement synchronizes all open databases.
- tallmessage -- The tallmessage statement displays a message alert.
- textlisttableoptions -- The textlisttableoptions statement sets up text list table options
- throwerror -- The throwerror statement causes an immediate error.
- 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.
- toggleaccessorypanel -- The toggleaccessorypanel statement opens and closes the current window's accessory panel.
- topdatawindow -- The topdatawindow statement brings the topmost data window in the specified database to the front.
- total -- The total statement calculates totals and subtotals for the current field.
- try -- The try statement works with catch and endcatch to trap errors in a sequence of statements.
- tweakobject -- The tweakobject statement tweaks the dimensions of an object (or multiple objects).
- uncompress -- The uncompress statement uncompresses a `.zip`, `.tar.gz` or `.tar.bz2` file into a file or an entire folder.
- undefine -- The undefine statement destroys one or more variables.
- undefinefileglobal -- The undefinefileglobal statement destroys one or more fileglobal variables.
- undefineglobal -- The undefineglobal statement destroys one or more global variables.
- undefineservervariable -- The undefineservervariable statement destroys a server variable.
- undefinewindowglobal -- The undefinewindowglobal statement destroys one or more windowglobal variables.
- unlockrecord -- The unlockrecord statement unlocks the currently active record.
- unpermanent -- The unpermanent statement converts one or more permanent variables into regular fileglobal variables. The variables will no longer be saved as part of the database.
- unpropagate -- The unpropagate statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.
- unpropagateup -- The unpropagateup statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the last (bottom) value.
- until -- The until statement is used at the end of a loop, and can control how many times the loop is executed.
- updateballoonlocations -- The updateballoonlocations statement does nothing.
- 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).
- uprecord -- The uprecord statement moves the cursor up one visible record.
- urltaskcancel -- The urltaskcancel statement aborts a download initiated with the urltask( function.
- urltaskstatus -- The urltaskstatus statement enables connection error checking in urltask( completion code.
- usebashprofile -- The usebashprofile statement grabs the search path from the `.Bash_profile` file in the user's home folder, so that these paths will be used by scripting languages (Ruby, Python, etc.).
- usecallerslocalvariables -- The usecallerslocalvariables statement temporarily swaps out a subroutine's current local variables with the local variables of the procedure that called this subroutine. The statement can be used only in a subroutine, not in a calling procedure.
- usefunctioncallerslocalvariables -- The usefunctioncallerslocalvariables statement temporarily swaps out a procedures current local variables with the local variables of the procedure that called this the call(, callwithin( or execute( function.
- usemylocalvariables -- The usemylocalvariables statement reverses the action of the UseCallersLocalVariables statement, switching back to the current procedure's normal local variables.
- utf8tomac -- The utf8tomac statement translates text from UTF8 (Unicode) to Panorama format.
- 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.
- webdatabaseadminpage -- The webdatabaseadminpage statement generates a web admin HTML page for the current database.
- webdatabasetoform -- The webdatabasetoform statement fills in an HTML form with database field values.
- webfontsubstitutes -- The webfontsubstitutes statement generates an array of standard font substitutions for web browsers.
- webformitem -- The webformitem statement sets a field or variable with the value of a POST web form item (used when processing a web query with Panorama Server).
- webformitembang -- The webformitembang statement sets the text generated by the webformitembang( function.
- webformitemcheck -- The webformitemcheck statement uses a formula to check the validity of a web form item.
- webformitemnames -- The webformitemnames statement returns a list of POST parameters passed from a form to the web server as a carriage return separated list.
- webformmerge -- The webformmerge statement fills in an HTML form with database values (fields and variables).
- webformrecordid -- The webformrecordid statement adds a RECORD_ID hidden field to the HTML of a web form.
- webformselection -- The webformselection statement selects data based on input from a web form. The web form must have fields that match the database fields.
- webformtodatabase -- The webformtodatabase statement updates the current database with information from the web form that was just submitted.
- webmerge -- The webmerge statement merges an external HTML template file with fields and variables from the current record.
- webselect -- The webselect statement selects data on web server using a formula.
- webserverinfo -- The webserverinfo statement retrieves additional information about the web server and the current browser request.
- webshare -- The webshare statement perform record locking operations from a web publishing procedure.
- webthisrecordkey -- The webthisrecordkey statement makes a key for use with the WebURLSelect statement to specify the current record.
- weburlfind -- The weburlfind statement finds a record based on keys in a URL.
- weburlselect -- The weburlselect statement selects one or more records based on keys in a URL.
- while -- The while statement is used at the end of a loop, and can control how many times the loop is executed.
- window -- The window statement brings a Panorama window to the front. It can also open a "secret" invisible window.
- windowbox -- The windowbox statement specifies the dimensions (size and location) of the next window that is opened (with openform, opensheet, openprocedure etc.).
- windowcornerinitialize -- The windowcornerinitialize statement shifts a window to an edge or corner of the main screen.
- windowglobal -- The windowglobal statement creates one or more windowglobal variables.
- windowmenubar -- The windowmenubar statement creates a custom menu bar or context menu for the current window (see Custom Menus).
- windowname -- The windowname statement changes the name of the current window.
- windowtoback -- The windowtoback statement sends a Panorama window to the back, behind all other windows (including non-Panorama windows).
- windowtocorner -- The windowtocorner statement shifts a window to an edge or corner of the main screen.
- writedialogcode -- The writedialogcode statement scans the current form, and writes the procedure needed to handle this form as a dialog.
- writepreference -- The writepreference statement modifies a preference value.
- xcallbackurl -- The xcallbackurl statement performs an action in another application using the x-callback-url mechanism.
- yesno -- The yesno statement displays a modal alert window with a message and two buttons: Yes and No.
- zipcompress -- The zipcompress statement compresses a file or an entire folder into a zip file (using ditto shell tool).
- zipinfo -- The zipinfo statement queries the web to obtain information about a zip code.
- zipinfoplus -- The zipinfoplus statement queries the web to obtain information about a zip code.
- 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).
- zoomalign -- The zoomalign statement moves the current window to one of 9 positions on the computer's primary screen: top left, top center, top right, etc.
- zoomwindow -- The zoomwindow statement moves (*"zooms"*) the current window to a new position and size.
- zoomwindowrectangle -- The zoomwindowrectangle statement modifies the size, location, and options of the current window.