Functions
Functions are shortcuts for creating expressions that return a value. The returned value can be used in reports, queries, default values, and system rules.
An expression is a sequence of characters that is evaluated to return a value. An expression is constructed with text characters, although it can return a value of any type.
Example: 1 + 1
is a simple expression
that would return a numeric value of 2
.
Note: No quotes are used.
Enclose the expression in quotes, "1 + 1"
, and the expression
returns the following string of characters: 1 + 1
. The quotes indicate
that the value is literal.
When you use a function, you specify what the function evaluates through an expression. The function documentation indicates the type of data the function is expecting:.
Data type | Function expects |
---|---|
Character
|
Specify an expression that returns a character value or type a literal value. |
Date
|
Specify an expression that returns a date value or type a date. |
Logical
|
Specify an expression that returns a true or false value. |
Numeric
|
Specify an expression that returns a numeric value. |
Functions are custom expressions that are used to customize or filter data used in queries and report forms.
Caution: Function information is advanced and should be used carefully. Prior experience with FoxPro or similar database management software is assumed.
You can look up information about the functions in FH.
A | B | C | D | E |
F | G | H | I | J |
K | L | M | N | O |
P | Q | R | S | T |
U | V | W | X | Y |
Z |