COMMANDS

LABELS

Enhanced COMMANDS

System Maintained Variables

New Command Line Flags

Environment Variables

New Platforms

Trig & Log Functions

In define processing, when you press the F10 Help key for that
forever growing list of commands, you can now use the F9 search
key to find your favorite command or phrase.

The search will produce a ListBox which is key sensitive.
You can also customize the end-user help files by editing the
key words area of your help files.

Type is any combination of R=Read W=Write and X=Execute access.

pw = access("/etc/passwd","rw")

Returns 0 if you have all the specified access permissions to the file. Otherwise, a negative value is returned. This value is the negative of the system error number.

The format of the function is:

N = OpenDir(format type, filename)

• N = opendir(); no format type and no filename
  Creates a list of all filePro files

• N = opendir("PRC_MASK")
  Creates a list of all prc files for the current file

• N = opendir("SCR_MASK", "fpcust")
  Creates a list of all screens for the fpcust file

• N = opendir("*.htm")
  Creates a list of all *.htm screens in the current files directory
  
  The listed wildcards are the DOS versions. They are
  different for Unix. (ie: "prc.*" vs. "*.prc") This
  is why you should use the predefined masks rather than
  hardcoding the wildcards.

The preset cross-platform terms that the function understands are

PRC_MASK
TOK_MASK
SCR_MASK
IDX_MASK
BRW_MASK
OUT_MASK
SEL_MASK

Subsequent NextDir() allows you to build a list of files found with sizes, dates etc.

The format of the function is:

XX=NextDir()

The format of the returned fixed length string is:

filename    extension     size      date    time    fullname

14            10         14          8       6       25

abcdefghijklmn abcdefghij 01234567891234 01-01-99 12:12a  -------

with a single space between each of the portions of the string.
The filenames, extensions, and fullname left justified.
The size right justified w/commas. The date and time right justified.

XX = READSCREEN( filename, screenname [ , section ] )

Where "filename" is the name of the filePro file, and "screenname" is the screen name.
The optional third parameter is the section of the screen to be read.
The currently supported sections are:
0: Graphics characters are returned as text equivalents. (ie: '|', '-', '+')
1: Graphics characters are returned as-is
2: Graphics characters are returned as spaces.
If not specified, the default section is zero.
If the screen cannot be read (ie: doesn't exist) then READSCREEN() returns a null value.

The format of this function is:

XX=RecLen( )
Returns the record length of the current file.

XX=RecLen(lookupname)
Returns the record length of the specified lookup.

XX = FreeSpace(drive)

XX = FreeSpace(); with no drive specified
Returns the available free space (in bytes) on the drive the main file's map is located on.
For UNIX versions it will use the partition the main map file's map is on

• XX = FreeSpace("C")
  Returns the amount of free space left on the C drive
  You can substitute the partition for the drive letter in UNIX versions.

xx=IXCOMMENT(filename,indexletter)

xx = IXCOMMENT("arcust","A")

Returns the comment from the specified index.
If the index doesn't exist, or has no comment, a null value is returned.

XX=IXSORT(filename,indexletter[,sortlevel])

xx = IXSORT("arcust","A")

The return value is in the format:

field,legth,ascend/decend,[sub-total])

If no sortlevel is specified, all sortlevels
are returned in the format for all possible choices
2 , 12,a,n:1 , 15,a,n: : :

XX=SORTINFO( )
Returns the sort information for the currently running output format.

XX=SORTINFO(filename,formatname[,sortlevel])

The return value is in the format for all possible choices:

field,legth,ascend/decend,[sub-total])

5 , 8,a,y:2 , 15,a,y

N=STRTOK(string,characters[,startpos])

l=strtok(aa," 1234567890,./[]{}()!@#$%^&*+=-_<>?",l+"1")

Note that this is different from the INSTR() function in that it will return the first occurrance of any of the specified characters, not a string of characters.

html :tr ; html :td ; html :tx "Address" ; html :td- ; html :tr-
and so on.....

Basically, it is the same as the previous HTML :CR and :TX command
except it doesn't put in the HTML or BODY tags in the document
when the created function is specified.

JSFILE [id] :CR filename
...

This was originally designed to create JavaScript files.
(Hence the command name.) The sequential ASCII file is a side benefit.

Up to 32 characters long.
Only applies to Define Processing.
Not supported on Screens or Output Formats.

DECLARE LOCAL - the variable is visible only to the current prc table.
DECLARE GLOBAL - makes the variable visible to other prc tables.
DECLARE EXTERN - refers to a variabled DECLAREd GLOBAL in another table.
DECLARE - same as DECLARE LOCAL.

Note that, if one table has DECLARE GLOBAL, and another table has the same name using DECLARE LOCAL, the other table uses its own copy of that name.

Note that the meaning of GLOBAL here is different than the meaning of the global ",g" flag when specifying the field type and length.

The DECLAREd variables can be used anywhere in processing that the classic 2-letter dummy fields could be used.

EXAMPLES:

DECLARE GLOBAL LastName(20,*,g), FirstName(20,*,g)

DECLARE LOCAL YTDSales(10,.2)

Trig functions

result = DTOR(angle) Converts degrees to radians.
result = RTOD(angle) Converts radians to degrees.

result = SIN/COS/TAN(angle)
angle = ASIN/ACOS/ATAN(n)
The usual. Angles given in radians.

result = SIN/COS/TAN(angle)
angle = ASIN/ACOS/ATAN(n)
The usual. Angles given in degrees.

result = ATAN(y,x)
result = DATAN(y,x)
Returns the arctangent of (y/x), in
radians (ATAN) or degrees (DATAN).

Note that there are two versions of ATAN/DATAN. With one parameter
or two. One parameter means the parameter is the tangent value to
return the arctangent for. Two parameters specifies the y/x slope
to return the arctangent for.

Log functions

result = LOG(n) Natural (base e) logarithm
result = LOG10(n) Base 10 logarithm
result = EXP(n) Exponent function (e^n)
result = EXP10(n) Base 10 exponent (10^n)

The output processing sub-routine labeled by the @DONE will be executed when the output processing is done even if no records are selected. Executes after @WGT label and after all output has been sent to the printer/spooler.

If the environment variable PFWGT0=ON, filePro will execute
the @WGT processing even of no records are selected.

Call "path/prcname"

Examples:

lookup dat = (FileName & "@" & QualFile) i=A k=(KeyWord) -nx

lookup zip = zipcodes i=A k=(State & ZipCode) -nx

lookup sys = (SysFile) r=(RecNum) -n

lookup foo = (FileName) i=A k=(LookupKey) -nx b=(BrowseHeader & BrowseFormat)

In the above examples:

FileName, QualFile, KeyWord, State, ZipCode, SysFile, RecNum,
LookupKey, BrowseHeader, & BrowseFormat
are GLOBAL define variables whose value may be set in processing.

If the file does not exist, filePro will create it.

New or Enhanced
System Maintained Variables

REPORT & CLERK

-rf @filename

RCABE

New or Enhanced
Environment Variables

PFCONFIG=<path>

Allows you to set an individual config location that over-rides the default fp\lib directory. Enter the full path of the config location to be used and you must include the 'config' filename. Allows you to set an individual config location that over-rides the default fp/lib/config file.

New
Operating System
Platforms

UNIXWARE 7

This powerful O/S from SCO has now been tested and approved. The standard UNIX version of filePro Plus loads and operates.

LINUX

This new and exciting O/S has now been tested and approved. Modified installation and supporting file structure to support.

Microsoft Windows 95/98/NT

New! This version uses the native 32-bit code of this popular O/S from Microsoft and does not require any DOS extenders such as DOS/4GW.