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