filePro Plus

filePro Plus™ 4.5 New Commands, Functions, and Environment Variables Summary

New Commands:

ADDMONTH Adds a specified number of months to a date.
BASE Converts between different bases.
CEIL Performs the ceiling function, which given any number returns the next greater integer.
COMPARE Compares two values, with case sensitivity.
DATE FUNCTIONS Various Date Functions [see separate table]
DOEDIT Performs an edit on a value, and returns the result.
ERRNAME Returns the name of the specified system error.
FIELDEDIT Returns the name of the edit of the specified field.
FIELDLEN Returns the length of the specified field.
FIELDNAME Returns the name of the specified field.
FLOOR Performs the floor function, which given any number returns the next lesser integer.
GETCWD Returns the current directory name.
ISLEAP Determines if a given year is a leap year.
MDAY Returns the number of days in a given month.
NUMFIELD Returns the number of fields in a file.
NUMRECS Returns the number of records in a file.
REPEAT Repeats a string of characters.
SIGN Performs the signum function, returning the sign of the input.
XLATE Translates characters.

New Date Functions:

BOM Determines beginning of the month for a specified date expression.
EOM Determines end of the month for a specified date expression.
DOM Determines day of the month for a specified date expression.
WOM Determines week of the month for a specified date expression.
BOQ Determines beginning of the quarter for a specified date expression.
EOQ Determines end of the quarter for a specified date expression.
DOQ Determines day of the quarter for a specified date expression.
WOQ Determines week of the quarter for a specified date expression.
BOY Determines beginning of the year for a specified date expression.
EOY Determines end of the year for a specified date expression.
DOY Determines day of the year for a specified date expression.
WOY Determines week of the year for a specified date expression.

New File I/O Commands:

CREATE Creates a new file, and opens it.
CLOSE Closes an open file.
FILESIZE Returns the number of bytes in a file
OPEN Opens a file.
REMOVE Removes a file from the disk.
SEEK Set the current location within an opened file.
TELL Gets the current location in the file.
READ Reads from a file.
READLINE Reads a line of text from a file.
WRITE Writes to a file.
WRITELINE Writes a line of text to a file.

New Processing Commands:

CHDIR Changes the current directory.
CLEARS Clears a SHOW POPUP window.
DROP ALL Allows all remaining records in a file to be quickly dropped from a browse window.
GOSUB/GOTO OF Gosub/goto one of a list of labels.
LOGTEXT Writes an expression to the file specified by the environment variable PFLOGFILE.
PUTENV Stores a value in the environment of programs called through the SYSTEM command.
SET Fills an array with a specified value.
SHOW POPUP Displays a message in a pop up window.
SHOWCTR Displays a message on the screen, centering it on the specified row.
SHOWTOCOL Displays a message on the screen, specifying the ending column.
SLEEP Stops processing for a specified amount of time.
SWITCHTO Switches to a different screen, without returning to the original screen upon ending processing.
SYNC Flushes any disk writes pending on a file.
VIDEO Turns video updates on and off.

Enhanced Commands:

EXIT Exits filePro, and sets the exit value.
SCREEN Allows a cursor position to be specified.

New Color Settings:

DIALOGINVERSE Sets the foreground and background inverse colors for filePro dialogs.
DIAGOLNORMAL Sets the foreground and background colors for filePro dialogs.
MENUBORDER Sets the foreground and background colors of the menu border.
PFSHADOWCOLOR Sets the foreground and background colors of drop shadows.

New Environment Variables:

LOGFILE Sets filename to the new LOGTEXT processing command.
PF64K Turns off the warning in cabe that a compiled table is larger than 64K and won't work on DOS (32-bit systems only)
PFADDWP Turns off filePro's adding ".wp" extension to exports without an extension.
PFBLDFREE Turns on message before rebuilding freechain, to tell you why it's being rebuilt.
PFBRWM Tells filePro to strip trailing blanks from a browse lookup with must match flag set.
PFCHECKLOCK Turns on filePro's check and warning if you attempt to modify a lookup file w/o "-p" flag.
PFCMARK Causes all 2 digit years before specified year to be interpreted as year 20nn.
PFDLGENTER Controls the behavior of the ENTER key in the dialogs. If set to OFF then the ENTER key moves the input focus to the next field. If set to ON then the ENTER key acts like the SAVE key.
PFERRKEY Sets the key needed to return from 'filePro/System" error screen rather than ENTER.
PFHCFF Adds a formfeed to screen hardcopy in dclerk.
PFKEYTAB Changes the keys used by filePro for different functions. It is table driven and we supply two tables: FILEPRO.KEY and DOS.KEY.
PFLABEL Allows invalid characters in processing labels.
PFLBSIZE Sets filePro label table size.
PFLKNL Changes the behavior of lookup "-nl" to find the last matching record rather than the first.
PFLOCKBOX Tells filePro to flash "record is being updated" message rather than display the message in a messagebox.
PFLOGAPPEND Causes LOGFILE to be opened for appending. Default behavior is to overwrite it.
PFMAXALLOC Sets the maximum number of allocations made for sort buffers (default is 16).
PFMAXSIZE Sets the size of each sort buffer (default is 32K).
PFMAXTEMP Sets the maximum virtual memory size for sorting, as a multiple of physical memory (default is 1000)
PFMAXTFIL Sets maximum number of virtual memory files used for sorting (default is 4)
PFMENBRK Restores the old behavior of pressing BREAK in a menu within processing terminates processing.
PFMU Turns off the "protect lookup" prompt in cabe's lookup editor. (Single user DOS only)
PFNODF Disables ddefine and dexpand free disk space check.
PFOLDIX Builds old style 4.1 index when a single key is specified.
PFONEHEAD Tells report to print header lines only once.
PFPRINTERx Sets the characteristics of the specified printer
PFRETRY Sets the number of times filePro will retry a locked read (default is 10) (DOS Network only)
PFSP Overrides the site password stored in the fppath file.
PFSYNC Controls when syncing is done. ON after expanding file or ALL after all writes.
PFTIMEOUT Long form of PFPTO

New Box Functions -Define Screens and Output:

Center Horizontal / Vertical Centers Box as specified.

New Index Feature:

You can now build indexes on non-contiguous fields.

Additional Define Processing Enhancements:

Processing Table Editing New ability to find a specific label without finding references to it by preceding the search string with a tilde "~" character.
Browse Lookups Control of "must match length" in browse lookups.
Fuzzy Searches Drop now works on fuzzy searches.
Date Edits The "/" is now automatically supplied by date edits if the user does not enter them.
Listboxes CLEF key will now position to the last item in the current screenful, like HOME positions to the first.
@Wxx Processing INSL and DEL now execute @WLF processing. @WLF*, @WEF*, @WUF*, @WHLP*, @WBL* will all now execute for any field which does not have its own specific when label. INSL (F3), DELL (F4), and GRAPF (F9) now execute @WUK processing.

This document is subject to protection under United States Copyright law and is provided subject to the terms of the filePro® License Agreement.

filePro and filePro Plus are registered trademarks of FP Technologies, Inc.

9225 Promontory Road, Indianapolis, IN 46236

© 1999 FP Technologies, Inc

Like More Information? Contact Us:

STN, Inc
2127 Espey Court, Suite 100
Crofton, MD 21114
Voice: (800) 321-1969 or (410) 721-4004
Voice - DC Metro Area: (301) 858-0110
Fax: (410) 721-9011