Most of the following information was compiled using FoxPro for Windows Developer's Guide by Jeb Long, Sams Publishing, and FoxPro Commands & Functions Including Examples, Fox Software by Fox Holdings, Inc. as a reference. The examples of each function were created by Applied Systems, Inc. for use with TAM Reports.
This section introduces commonly used Expression Builder functions for modifying output in TAM Reports. Functions in Expression Builder are accessed through Extra Criteria, Filter Result, or Edit Report Format.
The following table contains definitions of common codes used in Expression Builder.
ExpC |
Character expression |
ExpN |
Numeric expression |
ExpD |
Date expression |
ExpT |
Date Time expression |
ExpL |
Logic expression |
( ) |
Follow the function name and indicates the proper use of the function. If commas or spaces are necessary they are included in the function. |
[ ] |
If brackets are inside parentheses, the area inside is optional. |
.T. |
Logical True |
.F. |
Logical False |
For specific definitions and examples of string, logical, math and date functions, click the links below.
Note: The TAM Functions document discusses the use of functions that were not created by FoxPro but were specifically installed for TAM.