Filemaker Pro 9 (106) Flashcards
1
Q
This set entered on 7-26-14
7.26.14.7
- FUNCTIONS. What is a FUNCTION?
A
It is simply a PREDETERMINED FORMULA
2
Q
- What is a FUNCTION that would find an average in a given field?
A
Average ( Line Item::Quantity )
3
Q
- What are the names of the components of the Function:
Average ( Line Item::Quantity )
A
The word “Average” is the FUNCTION’S NAME. “Line Item::Quantity” is a reference to a RELATED field.
4
Q
- What is a PARAMETER?
A
They tell the FUNCTION how to perform its specific calculation. For example, in the function:
Average ( Line Item::Quantity )
the “Line Item::Quantity” is the PARAMETER. This Function has only ONE parameter, but many Functions have two or more.
5
Q
- How are PARAMETERS presented in a Function?
A
Parameters are ALWAYS enclosed in PARENTHESIS.
6
Q
- When there’s more than one Parameter, THEY’RE SEPARATED BY:
A
A SEMICOLON, as in this Function:
Date ( Month ; Day ; Year )