# Commands

This provides the filePro version number that added or modified the command. If you are using an older version than identified, the command will either not work or may work differently than advertised. Items with version number 3.x were included in version 3.1 or earlier. (* designates not included in filePro Lite)

Version No. | Command | Description
4.1 | ABS() | Returns the absolute value of a number.
5.6 | ACCEPT() | Accept a connection on a socket.
4.8 | ACCESS() | Returns file access information.
4.8 | ACOS() | Returns Arccosine of an angle in radians.
5.0 | ACOSH() | Hyperbolic cosine value.
4.8 | ADDMONTH() | Add a specified number of months to a date.
3.x | ASC() | Convert character to ASCII code.
4.8 | ASIN() | Returns Arcsine of an angle in radians.
5.0 | ASINH() | Hyperbolic Arcsine value.
4.8 | ATAN() | Returns Arctangent of an angle in radians.
5.0 | ATANH() | Hyperbolic Arctangent value.
3.x | AVG() | Find averages at subtotal/total levels.
5.0 | BACKGROUND | Turn ON or OFF the ability to enter background mode with "!G".
4.5 | BASE() | Converts between different bases.
3.x | BEEP | Sound the speaker.
5.6 | BIND() | Binds a name to a socket using IPv4
5.7 | BIND2() | Binds a name to a socket using IPv6
5.0 | BLOB | Binary Large Object functions.
4.5 | BOM() | Beginning of month.
4.5 | BOQ() | Beginning of quarter.
4.5 | BOY() | Beginning of year.
3.x | BREAK | Turns BREAK key on or off.
4.0 | CALL name | Calls a processing table as subroutine.
4.8 | CALL path\name | Calls a processing table in another file.
5.0 | CALL NOAUTO | Ignores dummy fields define in automatic processing.
4.5 | CEIL() | Performs the ceiling function.
3.x | CHAIN name | Chain to a processing table.
4.8 | CHAIN path\name | Chain to a processing table in another
4.5 | CHDIR | Change the current directory.
3.1 | CHR() | Convert ASCII code to character.
4.1 | CLEAR | Sets each element of "array" to blank.
4.1 | CLEARB | Removes a lookup window from screen.
4.1 | CLEARP | Removes a popup window from screen.
4.5 | CLEARS | Clear a SHOW POPUP window.
3.x | CLOSE | Close all files opened with lookups.
3.x | CLOSE file | Close indicated lookup file.
3.x | CLOSE export | Close indicated export.
3.x | CLOSE() | Close a file
4.8 | CLOSEDIR() | Close a OPENDIR() system directory for reading.
3.x | CLS | Clear entire screen.
4.5 | COMPARE() | Compares two values, with case sensitivity.
5.6 | CONNECT() | Initiate a connection on a socket using IPv4
5.7 | CONNECT2() | Initiate a connection on a socket using IPv6
3.x | COPY | Copy record to lookup file.
3.x | COPYIN | Copy record from lookup file.
4.8 | COPY TO | (enhanced) Copy record from one lookup file to another.
4.8 | COS() | Returns cosine for angle in radians.
5.0 | COSH() | Hyperbolic cosine.
4.5 | CREATE() | Create a new file, and open it.
5.8 | CRYPTERROR | gets error code for ENCRYPT()/DECRYPT() failure
5.0 | CURSOR | Forces cursor ON, OFF or to default behavior.
5.0.6 | CURSOR PATH | Allows turning off forced cursor path - fileProGI. Same as MOUSE PATH.
4.8 | DACOS() | Returns Arccosine of an angle in degrees.
4.8 | DASIN() | Returns Arcsine of an angle in degrees.
4.8 | DATAN() | Returns Arctangent of an angle in degrees.
4.8 | DCOS() | Returns cosine for angle in degrees.
3.x | DEBUG | Turn debugger on or off.
4.8 | DECLARE | Global and Local dummy variables long names.
5.7 | DECODE() | Converts text in a string that was ENCODEd
5.6 | DECRYPT() | Decrypt ciphered field data created by ENCRYPT().
3.x | DELETE | Delete record in current file.
3.x | DIM() | Define an array of "n" fields.
1.x | DISPLAY | Redisplay current screen (no update).
4.1 | DLEN() | Returns the display length of a string.
4.5 | DOEDIT() | Apply an edit to the contents of a field
5.6 | DOKEY | Execute a keystroke as if the user pressed it
4.5 | DOM() | Day of month.
4.5 | DOQ() | Day of quarter.
4.1 | DOW() | Returns day of week for a date expression.
4.5 | DOY() | Day of year.
4.1 | DROP | Drop records from browse lookup
4.5 | DROP ALL | Drop all remaining records in browse lookup.
4.8 | DSIN() | Returns sine for angle in degrees.
4.8 | DTAN() | Returns tangent for angle in degrees.
4.8 | DTOR() | Converts angle in degrees to radians.
3.x | EDIT() | Returns the edit-type of a field.
5.7 | ENCODE() | Converts the contents of a field
5.6 | ENCRYPT() | Encrypt field data.
5.7 | ENCRYPTED() | Returns true if a lookup file was ENCRYPTed
3.x | END | Stop processing.
4.5 | EOM() | End-of-month.
4.5 | EOQ() | End-of-quarter.
4.5 | EOY() | End-of-year.
4.1 | ERRORBOX | Error box position.
4.5 | ERRNAME() | Return the name of the specified system error.
3.x | ESCAPE | Save current screen; use with @wef/@wlf.
4.1 | EXISTS() | Returns error level for files.
4.5 | EXIT | Exit filePro, and set the exit value.
4.8 | EXP() | Anti-log (e^n)for natural log function.
4.8 | EXP10() | Anti-log (10^n) for common log function.
4.8 | EXPORT | (Enhanced) Create spin-off files for other programs.
4.5 | FIELDEDIT() | Return edit name of field.
4.5 | FIELDLEN() | Return the length of the specified field.
4.5 | FIELDNAME() | Return the name of the specified field.
5.6 | FIELDNUM() | Returns the field number of a FIELDNAME in a lookup
4.5 | FIELDVAL() | Returns the value of a specified field.
5.0 | FILENAME() | Return the filename of specified handle.
4.5 | FILESIZE() | Return the number of bytes in a file.
4.5 | FLOOR() | Performs the floor function.
4.8 | FLUSHKEY | Clears pending keystrokes.
3.x | FORM | Print a form. (auto & input proc only)
4.0 | FORMM | Print a form without closing spooler.
4.1 | FRAC() | Return the fractional portion of a number.
4.8 | FREESPACE() | Returns the amount of free disk space if less then 2GB
5.7 | FSTAT() | Fills @FSTAT[] system array with open file info
5.6 | GET16() / GET32() | Reads data from the buffer of a binary file
4.5 | GETCWD() | Return the current directory name.
4.1 | GETENV() | Return value of environmental variable.
3.x | GETNEXT | Used with LOOKUP for repetitive lookups.
5.6 | GETNONCE() |
5.6 | GETPEERNAME() | Returns the name of the connected peer (sockets).
5.6 | GETPID() | Returns the process ID of the current process.
5.6 | GETPPID() | Returns the parent process ID of the current process.
3.x | GETPREV | Used with LOOKUP for repetitive lookups.
5.6 | GETSOCKNAME() | Returns the name of the socket.
3.x | GOSUB | Branch to subroutine label; used with RETURN.
4.5 | GOSUB OF / GOTO OF | Gosub/goto one of a list of labels.
3.x | GOTO | Branch to element label.
5.0 | GUI | Test if you are running a fPclient session e.g. fileProGI.
3.x | HARDCOPY | Print the current screen.
5.7 | HASH() | Applies the HASH encryption to a field
3.x | HELP | Display help screen of section "name".
4.8 | HTML | Create HTML files using filePro HTML functions.
5.0 | HTML:xx | HTML functions added and enhanced.
4.8 | HTMLERRNO() | Return error code for the last HTML/JSFILE element.
3.x | IMPORT | Open a non-filePro file for data importing.
3.x | INKEY | Get next keystroke, if available.
3.x | INPUT | Prompt for user input.
4.0 | INPUTPW | Input password (puts '#' when typing).
4.1 / 5.0 | INPUT POPUP | Input using a popup window.
4.1 | INPUTPW POPUP | Input a password in popup window.
4.1 | INSTR() | In-string search.
4.1 | INT() | Return the integer portion of a number.
4.5 | ISLEAP() | Determine if a given year is a leap year.
4.8 | IXCOMMENT() | Return the comment for the index specified.
4.8 | IXSORT() | Return sort information for a specified index.
4.8 | JSFILE | Create sequential ASCII files.
3.x | LEN() | Find length of field or expression.
4.1 / 5.0 | LISTBOX() | Display a popup window containing a list.
5.6 | LISTEN() | Listen for connections on a socket.
4.8 | LOCKED() | Tests if the lookup failed dur to a locked record.
4.8 | LOG() | Natural or naperian log function.
4.8 | LOG10() | Common or base 10 log function.
4.5 | LOGTEXT | Writes text to a file specified by PFLOGFILE.
3.x | LOOKUP | Get data from another file.
4.0 |  | Qualifier Enhancement.
4.5 |  | -s switch. Do not display "No Records Exist ..." message
4.0 |  | BRW=lines,row,col size and location of window.
4.0 |  | SHOW=KEEP; Keep window after selecting record.
4.0 |  | SHOW=ONLY; only show the browse lookup.
4.1 |  | SHOW=PKEEP; keep window & highlight bar.
4.0 |  | POP=screen; Popup "screen" when user presses 'V'.
4.0 |  | XKEY=keys; keys which will take browse down.
4.1 |  | FILL=top/bot; Direction to fill browse window.
4.1 |  | PRC=label; prc label to goto at each record.
4.0 |  | number of records for fuzzy search.
4.8 |  | Selection Lookup enhanced to allow use of expressions including the new extended long name variables.
4.1 | MAX() | Enhanced to return max value from a list of values.
4.5 | MDAY() | Returns the number of days in a given month.
5.0 | MEMO | Memo & plain text BLOB functions.
3.x | MENU | Create menu in processing.
5.7 | MERGEVAL | result = MERGEVAL (importname, field number
4.1 | MESGBOX | Display a popup message box
5.0.6 | MESSAGE | Refer to fileProGI Developer Toolkit.
3.x / 5.0 | MID() | Find and copy the middle of a field.
4.1 | MIN() | Enhanced to find minimum value of field from a list of values.
4.1 | MOD() | Return the remainder of a expression.
5.0.9 | MOUSE PATH | Force screen cursor path ON or OFF when using a mouse with fileProGI client. Default is ON. Same as CURSOR PATH.
4.1 | MSGBOX | Display a popup message box.
4.8 | NEXTDIR() | Return system directory information.
4.8 | NOT HTML | Tests if last HTML/JSFILE element failed.
4.5 | NUMFIELD() | Return the number of fields in a file.
4.5 | NUMRECS() | Return the number of records in a file.
4.5 | OPEN() | Open a file.
4.8 | OPENDIR() | Return the number of files or list of files
4.0 | OUTS | Sends data to a serial port.
3.x | PAGE | Force end of page when printing reports.
4.8 | PI() | Returns the value of PI or 3.14159265
4.0 | POPUP | Displays screen of a lookup file.
4.0 | POPUP UPDATE | Allows update of a screen of a lookup file.
3.x | PRINT | Print current record.
3.x | PRINTER "command" | Send output to "command". (LINUX/UNIX)
3.x | PRINTER FILE | Send output to file "filename".
5.0 | PRINTER FLUSH | Flushes all printer buffers
3.x | PRINTER LOCAL | Send output to terminal printer.
4.0 | PRINTER NAME | Send output to printer "name".
3.x | PRINTER RESET | Reset the printer.
4.0 | PRINTER TYPE | Sets printer type.
4.0 | PUSHKEY | Places "keystrokes" into the keyboard queue.
5.6 | PUT16() / PUT32() | Writes binary data to a buffer
4.5 | PUTENV | Store a value in the environment.
4.1 / 5.0 | RAND() | Return a pseudo-random number.
4.5 | READ() | Read from a file.
4.8 | READBROWSE() | Returns browse format as a data string
4.5 | READLINE() | Read a line of text from a file.
4.8 / 5.0 | READOUTPUT() | Reads the text portion of a report.
4.8 / 5.0 | READSCREEN() | Reads text portion of a screen.
4.8 | RECLEN() | Record length of the specified file.
5.6 | RECV() | Receive a message from a connected socket.
5.6 | RECVLINE() | Receive a message from a connected socket.
4.5 | REMOVE() | Remove a file from the disk.
4.5 | REPEAT() | Repeat a string of characters.
3.x | RESET | Reset selected records @wgt.
5.0 | RESET @PN | Reset Page Number back to 1
3.x | RESTART | Restart processing from start of table.
3.x | RETURN | End subroutine; go to element after GOSUB.
4.8 | RTOD() | Converts angle in radians to degrees.
5.0 | SAVE | Set the save option ON or OFF.
4.5 | SCREEN | (enhanced) Allows a cursor position to be specified.
4.5 | SEEK() | Set the current location within an opened file.
3.x | SELECT | Select record.(sort/selection processing)
5.6 | SELECT() | Select a socket handle.
5.6 | SEND() | Send a message to a connected socket.
5.6 | SENDLINE() | Send a message to a connected socket.
4.5 | SET | Fills an array with a specified value
3.x | SHOW | Show a message.
4.5 | SHOW POPUP | Display a message in a popup window.
5.0.6 | SHOW RAW | Show a message without filePro interpretation.
4.5 | SHOWCTR() | Center a message on the screen.
4.5 | SHOWTOCOL() | Specify show ending column for display.
4.5 | SIGN() | Return the sign of a number.
4.8 | SIN() | Return sine for angle in radians.
5.0 | SINH() | Hyperbolic sine value.
3.x | SKIP | Skip to next field; used with @wef only.
4.5 | SLEEP | Stop processing for a specified amount of time.
5.6 | SOCKET() | Creates a socket of the specified type.
5.6 | SOCKETCLOSE() | Closes the socket.
5.6 | SOCKETTOSYS() | Returns the corresponding system handle number for an open socket.
5.6 | SOCKETERROR() | Returns the error code of the last socket-related error.
3.x | SORT | Control sorting level and method.
4.8 | SORTINFO() | Sort information for a specified output.
4.1 | SOUNDEX() | Return the soundex code for the string "exp".
5.6 | SPELLCHECK | Check spelling of memos and other fields.
4.1 | SQRT() | Returns the square root of "n".
5.0 | STATUS | Retrieves the status of a handle
4.8 | STRTOK() | First occurrence of any string.
4.5 | SWITCHTO | Switch to a different screen.
4.5 | SYNC | Flush any disk writes pending on a file.
3.x | SYSTEM | Execute a OS command from processing.
5.6 | SYSTEM() | Returns the exit value of command issued.
4.1 | SYSTEM NOREDRAW | No screen redraw while processing.
5.6 | SYSTOSOCKET() | Given an operating system handle that corresponds to a socket, this creates a filePro handle to it.
4.8 | TAN() | Returns tangent for angle in radians.
5.0 | TANH() | Hyperbolic tangent value.
4.5 | TELL() | Get the current location in the file.
4.8 | TOHTML() | Converts filePro HTML characters to HTML equivalents.
3.x | TOT() | Get a total or subtotal on field.
5.0 | TVM_I() | Time-Value-Money - Interest.
5.0 | TVM_N() | Time-Value-Money - Number of periods.
5.0 | TVM_PV() | Time-Value-Money - Present Value.
5.0 | TVM_PMT() | Time-Value-Money - Payment.
5.0 | TVM_FV() | Time-Value-Money - Future Value.
3.x | UPDATE | Put user in update mode.
3.x | USER | Send/receive data to/from user program.
4.5 | VIDEO | Turn video updates on and off.
3.x | WAITKEY | Wait for next keystroke.(See also INKEY)
4.5 | WOM() | Week of month.
4.5 | WOQ() | Week of quarter.
5.6 | WORDWRAP() | Gets wrap information for memo & non-memo fields,
4.5 | WOY() | Week of year.
4.5 | WRITE | Write data to a file.
4.5 | WRITE() | Write to a seek position in a file.
4.5 | WRITELINE() | Write a line of text to an external file.
4.5 | XLATE() | Translate characters.