Filemaker Pro 9 (109)

Question 1

This set entered on 7-29-14
7.27.14.1

1. EXPRESSIONS is a fancy name for:

Answer 1

a SUBSECTION of a CALCULATION–one or more fields, functions, or constants, each connected with operators.

Question 2

2. When you multiply a field named Quantity by a field named Price, that is a calculation. What is an EXPRESSION?

Answer 2

That CALCULATION is ALSO an EXPRESSION.

Question 3

3. An EXPRESSION always:

Answer 3

REDUCES to a SINGLE VALUE when you combine its individual values according to the OPERATORS.

Question 4

4. When is it NOT an EXPRESSION?

Answer 4

If you CANNOT BOIL IT DOWN TO A VALUE, IT IS NOT AN EXPRESSION. This is an important point because it means that YOU CAN USE EXPRESSIONS AS FUNCTION PARAMETERS just like individual values–fields and constants.

Question 5

5. Give some examples of EXPRESSIONS.

Answer 5

3 + 3. It reduces to the value 6. Last Name & “, “ & First Name & “ “ & Middle Initial & “ . “ This might reduce to Juanita J. Johnson.

Question 6

6. Give an example of a CALCULATION that’s also an EXPRESSION:

Answer 6

Average (L1 * W1 * H1 ; L2 * W2 * H2 ; L3 * W3 * H3). This is also an EXPRESSION BECAUSE IT REDUCES TO A SINGLE VALUE.

Question 7

7. What is this? L1 * W1 * H1 ; L2 * W2 * H2 ; L3 * W3 * H3

Answer 7

It is NOT an EXPRESSION BECAUSE IT DOES NOT REDUCE TO A SINGLE VALUE. It has three expressions in all, each separated by a double colon.

Question 8

8. What is NESTING EXPRESSIONS?

Answer 8

It means you can put ANY VALID EXPRESSION in place of a parameter IN A FUNCTION.

Question 9

9. What is a simple example of NESTING AN EXPRESSION?

Answer 9

(1+1+1) + 3. This is the same as 3+3. In this case, the SUB EXPRESSION (1+1+1) has replaced the original value 3.

Question 10

10. The idea of NESTING EXPRESSIONS is very handy when:

Answer 10

you work with FUNCTIONS. Instead of using individual fields or constants in a function, you can pass along whole expressions. You can even nest functions within other functions