Commands

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.

6.0

ARCHIVE

Copies a lookup record with all system maintained fields unchanged..

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()

Gets the "nonce" last used with ENCRYPT().

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.