Introduction
Welcome
Acknowledgements
BUG Reporting
Using Help
filePro Plus Capacities
Disclaimer
Disclaimer - Encryption
System Requirements
fPSQL
fPSQL
How Do I
Get Started
Things you should know.
The filePro Plus Main Menu
Index Selection
Defining Browse Formats
Scanning For Records
IUA Hints
Begin Designing
Creating A File
Defining a User Edit
Defining a Screen
Defining an Index
Setting the File Name
Defining an Output Format
Defining A Processing Table
Using IUA To Test File Design
Requesting an Output Format
Defining a User Menu
Running a User Menu
Continue Designing
Obtaining a Unique Number
Tracking Receipts By Customer Account#
Calculating Sales Tax and Totals
Simple Browse Lookup
The @key Trigger
Finish Design
Add New Customers While In The Receipts File
Posting
Adding A Catalog File
The Sort/Select Processing Table (-v processing)
A Virtual Work File - A Place To Stand
New Features In An Old Application
Advanced Concepts
Arrays
AutoIndexSelection
Clone Files
Debugger
DROP ALL
HELP Screens
Integrating Concepts
LISTBOX Command
Logtext
Lookup Dash
MENU Command
Negative number in "Number of Forms" field
O/S FILE I/O FUNCTIONS()
PDF printing
SORT/SELECT Processing
Lockfiles
Processing Tables
Alternate Automatic Processing
Another Trigger - @key
Automatic Processing - Compiling
Browse Lookup Example
COMMAND GROUPS
Dummy Fields in Processing
How A Processing Table Works
Keyboard Input
The LOOKUP Command
MSGBOX/ERRORBOX
Output Processing
Processing Table Backups
Processing Table Ingredients
Screen Messages With SHOW
Simple Operations on Processing Tables
Steps to Define a Key-field Lookup
Triggers
Types of Processing
FilePro Menu Items
Creation Operations
Define Files
Define Screens
Define Output
Define Edits
Define Processing
Defining User Menus
Printer Maintenance
Runtime Operations
FilePro Directory
Expand Files
Inquire, Update & Add
Index Maintenance
Request Output
Set/Change File Name
Running User Menus
fileProGI/GIserver
GIserver
fileProGI - Installation
fileProGI - Starting
fileProODBC
Introduction To fileProODBC
System Requirements - fileProODBC
Foreword
Disclaimer
Installation
What Method Should I Use?
Using Define Files for ODBC (High Level method)
filePro's ODBC objects (Low Level method)
ODBC High Level Demo
ODBC Low Level Application Demo
Restrictions
SQL Data Type & filePro Edits
Technical Notes
Environmental Variables
Appendix A - SQL Statements
fileProXLSX
XLSX Markup Language
XL_OPEN()
XL_SAVE()
XL_ADDSHEET()
XL_ADDCELL()
XL_ADDCELL2()
XL_FORMAT()
XL_COLWIDTH()
XL_FONT()
XL_BORDER()
XL_FILL()
XL_ADD_DT()
XL_ADD_DT2()
XL_CHART()
XL_CHART2()
XL_CHARTSHEET()
XL_SERIES()
XL_SERIES2()
XL_PROTECTSHEET()
XL_PROTECTCHARTSHEET()
XL_ERROR()
XL_SETPOS()
XL_SETPOS2()
XL_NEXTROW()
XL_NEXTCOL()
XL_STYLE()
XL_IMAGE()
XL_IMAGE2()
XL_LASTCMD()
XL_MARGINS()
XL_LANDSCAPE()
XL_PORTRAIT()
XL_GRIDLINES()
XL_FITPAGES()
XL_PAPERTYPE()
XL_CENTERH()
XL_CENTERV()
XL_PRINTACROSS()
XL_SETHEADER()
XL_SETFOOTER()
XL_SETBACKGROUND()
XL_HIDEZEROS()
XL_SHOWROWCOL()
Glossary
Standard Computer Terms
filePro Terms
References
Commands
A_AVG()
A_MAX()
A_MIN()
A_TOT()
ABS()
ACCESS()
ACOS()
ACOSH
ADDMONTH()
ARCHIVE
ASC()
ASIN()
ASINH()
ATAN()
ATANH()
AVG()
BACKGROUND
BASE()
BEEP
BLOB
BOM()
BOQ()
BOY()
BREAK
BUSYBOX
CALL
CEIL()
CHAIN
CHDIR
CHR()
CLEAR
CLEARB
CLEARP
CLOSE
CLOSE()
CLOSEDIR()
CLS
COMPARE()
COPY/COPYIN
COS()
COSH()
CREATE()
CRYPTERROR()
CURSOR
CURSOR PATH
DACOS()
DASIN()
DATAN()
DCOS()
DEBUG
DECLARE
DECRYPT()
DECODE
DELETE
DIM
DISPLAY
DLEN()
DOEDIT()
DOKEY
DOM()
DOQ()
DOW()
DOY()
DROP
DSIN()
DTAN()
DTOR()
EDIT()
ENCRYPT()
ENCODE
END
EOM()
EOQ()
EOY()
ERRNAME()
ERRORBOX
ESCAPE
EXISTS()
EXIT
EXP()
EXP10()
EXPORT
FIELDEDIT()
FIELDLEN()
FIELDNAME()
FIELDVAL()
FILENAME()
FILESIZE()
FLOOR()
FLUSHKEY
FORM
FORMERROR()
FORMM
FRAC()
FREESPACE()
FTP_OPEN()
GET16() GET32() PUT16() PUT32()
GETCWD()
GETENV()
GETNEXT
GETNONCE
GETPID()
GETPREV
GOSUB
GOSUB OF / GOTO OF
GOTO
GROUP()
GUI
HARDCOPY
HASH
HELP
HTML
HTMLERRNO()
IMPORT
INDEXOF()
INKEY
INPUT
INPUT POPUP
INPUTPW
INPUTPW POPUP
INSTR()
INT()
ISLEAP()
IXCOMMENT()
IXSORT()
JSFILE
IXSEL()
LEN()
LISTBOX()
Lite/filePro Lite
LOCKED()
LOG()
LOG10()
LOGTEXT
LOOKUP
MAX()
MDAY()
MEMO
MENU
MERGEVAL()
MESSAGE
MID()
MIN()
MOD()
MODE()
MOUSE PATH
MSGBOX
NEXTDIR()
NOT HTML
NUMFIELD()
NUMRECS()
OPEN()
OPENDIR()
OUTS
PAGE
PDF_CLOSE()
PDF_FIELDTYPE()
PDF_FIELDTYPE2()
PDF_GETFIELDNAME()
PDF_GETNUMFIELDS()
PDF_GETVALUE()
PDF_GETVALUE2()
PDF_OPEN()
PI()
POPFIELD
POPUP
POPUP UPDATE
PRINT
PRINTER Commands
PUSHKEY
PUTENV
QRCODE()
RAND()
READ()
READLINE()
READOUTPUT()
READSCREEN()
REPLACE()
RECLEN()
REMOVE()
REPEAT()
RESET
RESTART
RETURN
RTOD()
SAVE
SCREEN
SEEK()
SELECT
SELECTBOX()
SET
SHOW
SHOW POPUP
SHOW RAW
SHOWCTR
SHOWTOCOL
SIGN()
SIN()
SINH()
SKIP
SLEEP
SORT
SORTARRAY()
SORTINFO()
SOUNDEX()
SPELLCHECK
SPLIT
SQRT()
STACKTRACE()
STATUS()
STRING_FUNCTIONS
STRTOK()
SWITCHTO
SYNC
SYSTEM
TAN()
TANH()
TELL()
TOHTML()
TOT()
TVM_xx
UPDATE
USER
User Defined Functions
VIDEO
WAITKEY
WOM()
WOQ()
WOY()
WORDWRAP
WRITE
WRITE()
WRITELINE()
XLATE()
Advanced Options for Define files
Ddefine Options
Edits
Edits
Edits Syntax
System and Global Edits List
Encryption
ENCRYPT / DECRYPT
Encryption Methods
Encryption Mode
Encrypt / Decrypt Example
Encrypting Fields - Caution
Credits Encryption
Environment Variables
Color-Values
Configuration Editor
Environment Variables
Environment Variables - Debugging
Environment Variables - Index (building, lookups, Browse)
Environment Variables - Miscellaneous
Environment Variables - Operating System Specific
Environment Variables - Other
Environment Variables - Output
Environment Variables - Path
Environment Variables - Screen Display
Setting Environment Variables
Error Messages
Background Processing Problems
Error Initializing a Port
Unlocking Files
filePro Error Messages
Other System Errors
System Errors
Windows Error Messages
Flags
Flags - Define Processing (rcabe, dcabe)
Flags - Directory (ddir & dprodir)
Flags - Expand Files (dexpand)
Flags - Index Maintenance (dxmaint)
Flags - IUA (rclerk, dclerk)
Flags - Request Output (rreport, dreport)
HTML
HTML Functions
HTML(Address)
HTML(Anchor)
HTML(Area)
HTML(BASE)
HTML(Blockquote)
HTML(Body)
HTML (Caption, Frameset)
HTML(Center)
HTML (Comments)
HTML (Create)
HTML(Definition Term, Definition Data)
HTML(Divisions)
HTML(Font)
HTML (Form)
HTML (Frame)
HTML (Header)
HTML (Heading Text)
HTML (Horizontal Rule)
HTML(Image)
HTML (Input)
HTML(ISINDEX)
HTML(Link)
HTML(Map)
HTML(Meta)
HTML (Option)
HTML(Ordered List, Unordered List, Definition List)
HTML(PRE)
HTML(Script)
HTML (Selection)
HTML(Span)
HTML (Table, Data)
HTML (Table, Table Row)
HTML (Text)
HTML (Text area)
HTML (:ZZ)
JSON
JSON Functions
Math
Simple Math
Exponents
Math,Financial
Log Functions
Trig Functions
Hyperbolic
Objects
Objects
PDF Objects
Operating Systems
Differences between DOS and Unix
DOS and Network Versions
Environment
LINUX
Microsoft Windows XP and higher
PATH
UNIX
UNIXWARE
XENIX
Operators
Alias Field Assignment
Alias Filename Assignment
Assignment
Bitwise Operators
Expressions
Logic Operators
Math Operators
Punctuation and Operators
String/Expression Manipulation Operators
References Other
Print Precedence Directives
Special Key Labels
SHOWCODES
Sockets
TCP/IP Functions
SOCKETS Sample Applications
Licensing
SpellCheck
Spell Check - Memo Fields
Spell Check - Using Processing
System Maintained Fields
System Maintained Fields
@AF
@B4
@BD
@BK
@BR
@BT
@C4
@CB
@CD
@CO
@CP
@CT
@DT
@FD
@FI
@FN
@ID
@LC
@LI
@OS
@PC
@PD
@PM
@PN
@PR
@PT
@PW
@PX
@PY
@PZ
@QU
@RN
@RP
@RS
@SF
@SH
@SK
@RO
@SN
@T4
@TD
@TM
@TN
@TS
@U4
@UB
@UD
@UT
@VR
@GUI
@VF
@WORDWRAP
@SYSINFO
System Arrays
Triggers
Trigger Processing
Triggers Used Only On INPUT Processing Table
Triggers Used Only On Output Processing Tables
@DONE
@ONCE
@entsel
@key
@menu
@update
@wbl
@wbrk
@wef
@wgt
@whp
@wlf
@wuk
@exit
Version Reference
Commands
Environment Variables
System Maintained Fields
System Arrays
Trigger Fields
Revision History
6.1.XX New Items
6.1.XX Release Notes
6.0.XX Release Notes
5.8.XX Release Notes
5.7.XX Release Notes
5.6.11 Release Notes
5.6.10 Release Notes
5.6.09 Release Notes
5.6.08 Release Notes
5.6.07 Release Notes
5.6.06 Release Notes
5.6.05 Release Notes
5.6.04 Release Notes
5.6.03 Release Notes
5.6.02 Release Notes
5.6.01 Release Notes
5.6.00 Release Notes
5.0.15 Release Notes
5.0.14 Release Notes
5.0.13 Release Notes
5.0.12 Release Notes
5.0.11Release Notes
5.0.10 Release Notes
5.0.09 Release Notes
5.0.08 Release Notes
5.0.07 Release Notes
5.0.06 Release Notes
5.0.05 Release Notes
5.0.04 Release Notes
5.0.03 Release Notes
5.0.02 Release Notes
5.0.01 Release Notes
5.0.00K5 Release Notes
5.0.00K4 Release Notes
5.0.00K3 Never Released
5.0.00K2 Release Notes
5.0.00K1 Release Notes
5.0.00 Release Notes
4.8.12 Release Notes
4.8.11 Release Notes
4.8.10 Release Notes
4.8.09K Release Notes
4.8.09 Release Notes
4.8.07 Release Notes
4.8.06 Release Notes
4.8.05K Release Notes
4.8.05 Release Notes
4.8.04 Release Notes
4.8.03 Release Notes
4.8.02 Release Notes
4.8.00 Release Notes
4.5.08K6 Release Notes
4.5.08 Release Notes
4.5.07 Release Notes
4.5.06 Release Notes
4.5.05 Release Notes
4.5.03 Release Notes
4.5.02 Release Notes
Technical Notes
Automatic Processing Tables
Blinking Text
Browse and Creation Password
Button Problem
DOS4GW
Emulation Problems on LINUX
fppath
Hide Indexes
Index Speed
pfdsk
License Manager
License Problems
Connecting Workstations
Syntax
hplaser
FilePro and Laserjet Printing
Terminal Guide
Introduction
Terminal Features
Adding New Terminal Types
Termcap Function Codes
Termcap Graphic Codes
filePro Plus Codes
Key Label Codes
ALTOS 3/5 Key Usage
ANSI Console Key Usage
AT&T 4410/5410 Key Usage
DEC VT 100 Key Usage
IBM-3151 Key Usage
IBM-3164 Key Usage
TANDY DT-1OO Key Usage
TANDY DT-11O Key Usage
UNISYS UVT-1220 Key Usage
WYSE 50 Key Usage
WYSE 60 Key Usage
WYSE 75 Key Usage
WYSE 85 Key Usage
YOUR TERMINAL Key Usage
Utilities
Addqual
Autoshuf
Blobfix
Configuration Editor
dbCopy
dosetforms
doresync
Dual Write Mirror
Form Filtering
fPcopy
fPPack
fPtransfer
Freechain
Licinfo
Menu Password Maintenance
Set filePro's Colors Utility
Site Password
SpellEditor
Swapcpu
UID Map
UNPAD