# Environment Variables - Operating System Specific

AIX/UNIX/LINUX

PFQUIT=OFF

Disables the ability of UNIX users to press the CTRL \ to exit a program.

Version Ref: 4.8

PFROOTFIX=OFF

Some *NIX systems prevent a setuid program running with a real uid of root from executing child processes. The previous workaround (setting the real uid to "filepro" when running as root) causes some things (such as printer banner pages) to report "filepro" as the user. "PFROOTFIX=OFF" turns off the fix for systems that don't require it.

Version Ref: 5.0.12

PFSYSEUID=OFF

If OFF, then SYSTEM command will be executed without the filePro setuid. Some systems may not allow a program to reclaim a setuid after giving it up. On these systems, setting this variable will cause bad things to happen to filePro. SCO OSV5 does not have a problem with this. LINUX kernels prior to 1.1.37 have a problem. The default is ON

Version Ref: 4.8

PFTERM=terminal

Type of terminal being used. Must match termcap file (UNIX). Same as TERM except exclusive to filePro.

Version Ref: 4.0

PFUMASK=nnn

Controls the umask value when creating files using HTML:CR and JSFILE :CR

Note: Use a decimal value for nnn, hex value 0xNNN or Octal value 0nnn (version 5.0 or later).

Version Ref: 4.8.9

TERM=terminal

Type of terminal being used. Must match termcap file (UNIX). See PFTERM also.

Version Ref: 1.0

TERMCAP=filename

Filename overrides "/etc/termcap" file (UNIX).

Version Ref: 1.0

Windows/Network

PFCLOCK=ON | OFF

Enables or disables clock displayed in menus. Default is "OFF".

Caution: Setting PFCLOCK=ON will cause filePro to use excessive CPU time, while the clock is displayed at the menu, and may degrade performance of other programs.

Version Ref: 4.8

PFCURSOR=nnn

(Native windows version only) Allows you to set the height of the cursor within filePro. (Similar to obsolete CURSOR=LINE.) Enhanced to allow PFCURSOR=nnn, where "nnn" is a number from 1 to 100, which indicates the percentage of the height of the character cell that is filled by the cursor. PFCURSOR=LINE is equivalent to setting PFCURSOR=10. Default value is 99. Setting PFCURSOR=0 will cause filePro to use whatever is the current cursor height.

Version Ref: 4.8

PFFILES=nn

filePro uses more than 20 file handles.

Version Ref: 4.5

PFLICFILE

Override the default license path for fileProODBC.

Set PFLICFILE = %pfprog%\fp\license\licfp.dat

Default path is %pfprog%\fp\lib\licfp.dat

Version Ref: ODBC 1.0.01

PFKEYTAB=table

Changes filePro key table as specified.

Version Ref: 4.5 Default is filepro.key dos.key emulates Windows default keystrokes

Version Ref: 5.8 filepro-del.key file added to the lib folder to support using the DELETE key on Windows as the BREAK key. All other keystrokes remain the same as default filepro.

Set PFKEYTAB=filepro-del in the config file.

PFLABEL=OLD

Allow invalid characters in a prc tables.

Version Ref: 4.5

PFNET=ON

Use Network calls. (Windows only)

Version Ref: 3.0

PFNEWNTCONSOLE=ON

Forces startup code to create a new console for java RunMenu to execute. (Native95 only)

Version Ref: 4.8

PFSERVROOT=path

Sets the path to the implied "root" directory for HTML and JSFILE commands.

Version Ref: 4.8

PFSKHEX=ON (Native windows only)

Version Ref: 5.0

Some copies of 4.8 native windows were accidentally released with debugging code enabled, that caused @SK to contain the hex value of any keystroke that didn't have a "real" @SK value. Since this breaks the ability to test @SK="", it has been turned off. But, since several people have commented that they like the behavior, setting PFSKHEX=ON will re-enable it.

PFSHOWWINERROR=ON

Shows value of GetlastError() when a system error occurs.

Default is OFF

Version Ref: 5.0.6

FileProGI

PFNEWSK=ON

Allows new @sk values to be seen by processing. Specifically, the only value right now is "MOUS", which will be seen as "ENTR" if this variable is not set to "ON".

Default is OFF

Version Ref: 5.0.6

PFFORCECURSORPATH=OFF

Cursor path is enforced within the GUI environment. Cursor path will not be enforced if value is set to "OFF"

Default is ON

Version Ref: 5.0.6

FileProODBC

PFODBCCOMMITTYPE=n

Selects the open-commit-type to use for high-level ODBC data sources, where:

0 = "SELECT * FROM tablename" (default)

Very slow on some data sources with very large files, but uses nothing non-standard.

1 = "SELECT * FROM tablename WHERE id_field = nnn" (Where "id_field" is the name of the ID field, and "nnn" is a valid ID.)

Usually faster, but may be slower on some systems, as filePro must first determine a valid ID to use.

2 = "SELECT TOP 1 FROM tablename"

Fastest version, but "TOP 1" is non-standard and not supported everywhere. Will cause ODBC failure on those DSNs that don't support it.

Version Ref: 5.0.14