info("files")
info("files")

The info(“files”) function returns a list of all open database files.

Description

This function builds a carriage return separated text array containing a list of all the currently open database files.

See Also

- dbinfo( -- gets information about a database: what forms it contains, what fields, what flash art pictures, etc.
- fileglobalvalue( -- accesses a fileglobal or permanent variable from other databases.
- getfieldproperties( -- returns a dictionary containing all of the properties of the specified field. (See the setfieldproperties statement if you want to change one or more field properties.)
- getformoption( -- returns information about a form.
- getprocedureoption( -- returns information about a procedure.
- getproceduretext( -- gets the contents (source code) of a procedure.
- globalvalue( -- returns the value of a global variable.
- info( -- returns miscellaneous bits of information about the system, the current database, the current window, etc.
- info("accessorypanelwidth") -- returns the current width of the current window's accessory panel, if any.
- info("activeobjectid") -- returns the object ID of the currently active text editor or text list object, if any.
- info("activesuperobject") -- returns the name of the currently active text editor or word processor object, if any.
- info("angleunits") -- returns the current angular measurement units.
- info("applicationsfolder") -- returns the path to the current user's Applications folder.
- info("applicationsupportfolder") -- returns the path to the current user's Application Support folder (inside the Library folder).
- info("arraybuildstatus") -- returns the status of the most recently executed superarraybuild statement.
- info("availablescreenrectangle") -- returns a rectangle defining the edges of the main screen, after deducting for the space of the menu bar and dock (if visible).
- info("bof") -- returns true if the active record is currently on the first visible (selected) record.
- info("buttonrectangle") -- returns a rectangle defining the edges of the most recently clicked button.
- info("cachefolder") -- returns the path to the current user's Cache folder (in the Library folder).
- info("canmodifydatabasedesign") -- returns true if the user has permission to modify the database design.
- info("canusestandardui") -- returns true if the user has permission to use standard Panorama UI when using this database.
- info("click") -- returns the location of the last mouse click in screen relative coordinates.
- info("clickedobjectid") -- returns the object ID of the clicked object.
- info("clickedobjectname") -- returns the name of the button that was just clicked.
- info("clickedwindownumber") -- returns the window number of that was just clicked.
- info("clonewindow") -- returns true if the current window was opened as a "clone" window.
- info("collapsible") -- checks to see if the current record is collapsible.
- info("countrycode") -- returns the country code for the current location.
- info("csvseparator") -- returns the current CSV field separator character (comma or semicolon).
- info("currencycode") -- returns the currency code for the current location.
- info("currencysymbol") -- returns the currency symbol for the current location.
- info("customfunctions") -- returns a list of all available custom functions.
- info("customstatements") -- returns a list of all available custom statements.
- info("databasefilename") -- returns the name of the current database.
- info("databasename") -- returns the name of the current database excluding any filename extension (if any).
- info("datasheetwindownumbers") -- returns the unique ID numbers of all open data sheet windows.
- info("datatype") -- returns the data type of the current field.
- info("decimalseparator") -- returns the current decimal separator character (period or comma).
- info("defaultdatepattern") -- returns the default date pattern used for displaying dates.
- info("defaultmaxdatasheetcolumns") -- default maximum number of allowed data sheet columns.
- info("defaultvoice") -- returns the current default system voice.
- info("desktopfolder") -- returns the path to the user's desktop folder.
- info("dialogsheet") -- returns true if the currently active window is a dialog sheet.
- info("dialogtrigger") -- returns the name of the last button pressed in a standard alert or dialog.
- info("disablebackgroundsearch") -- returns true if all background searches have been disabled.
- info("disabledfields") -- returns a list of disabled fields in the current database (fields that cannot be edited).
- info("documentsfolder") -- returns the path to the current user's Documents folder.
- info("downloadsfolder") -- returns the path to the current user's Downloads folder.
- info("dropdatabase") -- returns the name of the database that contains the form data was dropped on.
- info("dropfiles") -- returns a list of files dragged onto a *Drag Receiver* form object (see Drag and Drop).
- info("dropform") -- returns the name of the form data was dropped on.
- info("dropobject") -- returns the name of the object that data was dropped on.
- info("droptext") -- returns text dragged onto a *Drag Receiver* form object (see Drag and Drop).
- info("droptypes") -- returns a list of all the data types dragged onto a *Drag Receiver* form object (see Drag and Drop).
- info("dropvcard") -- returns the text of any VCards dragged onto a *Drag Receiver* form object (see Drag and Drop).
- info("dropwindow") -- returns the name of the window that contains the form data was dropped on.
- info("dropwindownumber") -- returns the number of the window that contains the form data was dropped on.
- info("empty") -- returns true or false depending on the result of the last select operation. If no records were selected the function will return true, otherwise it will return false.
- info("enabledfields") -- returns a list of enabled fields in the current database (fields that can be edited).
- info("eof") -- returns true if the active record is currently the last visible (selected) record.
- info("error") -- returns the most recent error message.
- info("errorparameter") -- returns the parameter that caused a runtime error.
- info("errorstack") -- returns the contents of the procedure stack after an error.
- info("errorstatement") -- returns the name of the statement that Panorama was trying to run at the time an error occurred.
- info("eventtype") -- returns the type of the last event (mouse click, keyboard press, etc.).
- info("executeerrorsource") -- can be used in Error Handling code when an error occurs in code running via the execute statement or its siblings.
- info("expandable") -- checks to see if the current record is expandable.
- info("expressionstacksize") -- returns the fake size of expression stack.
- info("fieldcount") -- returns the number of fields in the current database.
- info("fieldname") -- returns the name of the current field.
- info("fieldnumber") -- returns the number of the current field (starting from 1).
- info("fields") -- returns a carriage return delimited list of fields in the current database.
- info("filesystemmonitors") -- lists the active file system monitors.
- info("filevariables") -- builds a carriage return separated text array containing a list of the currently allocated fileglobal variables in the current database.
- info("focusobject") -- returns the name of the currently active text editor or word processor object, if any.
- info("focusobjectid") -- returns the object ID of the currently active text editor or text list object, if any.
- info("foldersepchar") -- returns the separator character used between folders.
- info("fonts") -- returns a list of all fonts installed on this computer.
- info("formevent") -- returns the last event that occurred to the current form.
- info("formname") -- returns the name of the current form.
- info("formwindownumbers") -- returns the unique ID numbers of all open form windows.
- info("found") -- returns true or false depending on whether the last *find* or *next* statement was successful.
- info("globalvariables") -- builds a carriage return separated text array containing a list of the currently allocated global variables.
- info("guid") -- returns a unique identifier string.
- info("hiddenfields") -- returns a carriage return delimited list of fields that are currently hidden in the current data sheet.
- info("horizontalscrollbar") -- returns true if the current window's horizontal scrollbar is enabled, false if it is disabled.
- info("javascriptvalue") -- returns the value passed from JavaScript code in a web browser object.
- info("keyboard") -- returns the last key that was pressed.
- info("keycode") -- returns a special numeric code that represents the last key that was pressed.
- info("labels") -- lists the labels in the current procedure.
- info("languagecode") -- returns the language code for the current location.
- info("libraryfolder") -- returns the path to the current user's Library folder.
- info("localvariables") -- builds a carriage return separated text array containing a list of the currently allocated local variables.
- info("loggedinaccountemail") -- returns the currently logged in account ID (email address).
- info("loggedinaccountrole") -- returns the currently logged in account role.
- info("magnification") -- returns the current magnification of the current form.
- info("matrixcell") -- returns the current cell number within a matrix object.
- info("matrixcelldata") -- returns the data associated with the current matrix object cell.
- info("matrixcellrecordid") -- returns the record id of the cell in a matrix that was clicked on.
- info("matrixcellselected") -- returns the selection status of the current matrix object cell.
- info("matrixclickedframeform") -- returns the form that contains the matrix frame, or `""` if the current form contains the frame.
- info("matrixclickedobjectid") -- returns the object id of the object in a matrix that was clicked on (or zero if none).
- info("matrixcolumn") -- returns the current column number within a matrix object.
- info("matrixdata") -- returns the data associated with the current matrix object.
- info("matrixname") -- returns the name of the matrix object being drawn, if any.
- info("matrixrow") -- returns the current row number within a matrix object.
- info("matrixseparator") -- function returns the separator associated with the current matrix.
- info("measurementsystem") -- returns the measurement system for the current location.
- info("menuidentifier") -- returns the identifier of the most recently chosen menu item (if any).
- info("milliseconds") -- returns the number of milliseconds (1/1000th second) since the system started up.
- info("modaldialogopen") -- returns true if a modal dialog window is currently open.
- info("modifiedfield") -- returns the name of the field that was just modified.
- info("mousedown") -- returns true or false depending on whether the mouse is currently down.
- info("moviesfolder") -- returns the path to the current user's Movies folder.
- info("musicfolder") -- returns the path to the current user's Music folder.
- info("noshow") -- returns true if noshow is currently turned on, false if it is not.
- info("notification") -- returns information about the just clicked notification.
- info("osversion") -- returns the operating system version and build number.
- info("pagecount") -- calculates the total number of pages that will be printed.
- info("pagenumber") -- returns the current report page number.
- info("pagesetuporientation") -- returns the printing page orientation for the current database.
- info("pagesetuppaperheight") -- returns the printing paper height for the current database.
- info("pagesetuppaperwidth") -- returns the printing paper width for the current database.
- info("pagesetupscale") -- returns the printing scale factor for the current database.
- info("panoramafolder") -- returns the location of the folder containing the currently running copy of Panorama.
- info("panoramaname") -- returns the name of the currently running copy of Panorama.
- info("panoramauptime") -- returns the number of seconds since Panorama launched.
- info("parameters") -- returns the number of parameters passed to a subroutine.
- info("picturesfolder") -- returns the path to the current user's Pictures folder.
- info("posixtasks") -- list of POSIX shell tasks running in the background.
- info("preferences") -- returns a list of all currently active preference settings.
- info("printsequence") -- returns the record sequence number of the record being printed.
- info("proceduredatabase") -- returns the name of the database that contains the currently running procedure.
- info("procedurename") -- returns the name of the currently running procedure.
- info("procedurestack") -- returns the contents of Panorama's procedure call stack.
- info("procedurewindownumbers") -- returns the unique ID numbers of all open procedure windows.
- info("publicfolder") -- returns the path to the current user's Public folder.
- info("quitinprogress") -- returns true if Panorama is in the process of quitting.
- info("ram") -- returns the amount of physical RAM in this computer.
- info("rawdatabasedata") -- returns the binary data of the current database.
- info("records") -- returns the total number of records in the current database.
- info("runningatomic") -- returns true if the current procedure is running as an "atomic" procedure.
- info("runninghandler") -- returns true if the current procedure is running as a "handler" procedure.
- info("screenrectangle") -- returns a rectangle defining the edges of the main screen.
- info("searchformula") -- returns the most recent search formula used in a *find* statement, if any.
- info("selected") -- returns the number of selected records in the current database.
- info("serverconnection") -- returns true if the currently active database successfully connected to the server when it opened.
- info("serverconnectionstatus") -- returns the status of the connection between this database and the server.
- info("serverrecordid") -- returns the unique ID number for the current record.
- info("serverrecordts") -- returns the internal time stamp associated with the current record.
- info("serverupdate") -- returns true if the server update option is currently turned on (this is the default).
- info("showlater") -- determines whether or not Panorama is currently deferring display.
- info("speaking") -- returns true if talking is occuring right now.
- info("speechrate") -- returns the current Panorama speech rate (words per minute).
- info("speechvoice") -- returns the current default system voice.
- info("speechvolume") -- returns the current Panorama speech volume.
- info("stopped") -- returns true or false depending on the whether the last uprecord, downrecord, left or right statement succeeded or failed.
- info("summary") -- returns the summary level of the current record, from 0 (data record) to 7.
- info("taperecorder") -- returns information about the current procedure recording (if any).
- info("tempfolder") -- returns the path to the current user's temporary folder (for files you plan to use only for a short time).
- info("texteditortrigger") -- returns the reason why a Text Editor object triggered a procedure.
- info("thousandsseparator") -- returns the current thousands separator character (period or comma).
- info("tickcount") -- returns the number of ticks (1/60th second) since the system started up.
- info("timelimitremaining") -- returns the amount of time available (in seconds) before a loop will time out.
- info("toolbar") -- returns true if the current window's toolbar is visible, false if it is hidden.
- info("toolbarvisible") -- returns true if the current window has a visible tool bar.
- info("trigger") -- returns information about how the current procedure was triggered.
- info("typeofwindow") -- determines what type of view the current window contains.
- info("unixusername") -- returns the short user name of the logged in user.
- info("unsharedrecordid") -- returns the minimum ID for unshared records.
- info("uptime") -- returns the number of seconds since the computer was last booted.
- info("user") -- returns the name of the user of this computer.
- info("userfolder") -- returns the path to the current user's home folder.
- info("verticalscrollbar") -- returns true if the current window's vertical scrollbar is enabled, false if it is disabled.
- info("visible") -- returns true if the current record is visible and false if it is invisible.
- info("visiblefields") -- returns a carriage return delimited list of fields that are currently visible in the current data sheet.
- info("voices") -- returns a list of available speech synthesis voices on this system.
- info("volumes") -- returns a list of all of the currently mounted volumes (disks) on the computer.
- info("webbrowserlinklabel") -- returns the url of the link right clicked in a Web Browser object.
- info("webbrowserlinkurl") -- returns the url of the link right clicked in a Web Browser object.
- info("windowdepth") -- returns the color depth of the current window.
- info("windowname") -- returns the name of the current window.
- info("windownumber") -- returns the unique ID number of the current window.
- info("windownumbers") -- returns the unique ID numbers of all open windows.
- info("windowoptions") -- returns the names of any currently enabled window options,
- info("windowrectangle") -- returns a rectangle defining the edges of the current window. The rectangle is in screen relative coordinates.
- info("windows") -- builds a carriage return separated text array containing a list of all the currently open windows.
- info("windowtype") -- returns a numeric value based on what type of view the current window contains.
- info("windowvariables") -- returns a carriage return separated text array listing the windowglobal variables defined for the current window.
- info("windowview") -- determines what type of view the current window contains.
- localvalue( -- returns the value of a local variable.
- parameter( -- is used to transfer data between a main procedure and a subroutine.
- scopes( -- returns the current scope of a variable, as well as any hidden scopes.
- scopevalue( -- returns the value of a variable in the specified scope.
- setdatabaseoptions -- modifies one or more properties of a database.
- setformoptions -- modifies one or more properties of a form (name, viewing mode, etc.).
- setprocedureoptions -- modifies one or more properties of a procedure (source code, Action menu options, etc.).
- windowglobalvalue( -- accesses a windowglobal variable from other windows.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0