Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 8

  

|

  Logical functions     127

 test for a condition to evaluate it as true or false. This is known as a 

 value. If the condition is true, FileMaker Pro returns a 

; if the condition is false, 

FileMaker Pro returns a 

. You can use the keywords True and False with logical 

functions and operators when a Boolean value is needed. Keyword True returns 

 and 

keyword False returns 

.

Logical functions can also evaluate parameters such as text or arithmetic operations that 
do not make a true or false statement, or in the case of the GetField function, return the 

contents of another 

Click a function name for details.

One of several possible results based on a series of tests.

One result value, according to the integer value of a specified test.

Evaluates the specified 

 as a calculation.

An error code, if any, from the specified expression.

 if the specified data has a value of 0 or is empty, otherwise returns 

.

The contents of the referenced field.

The requested layout object attributes from the calculation's active window.

The contents of the referenced field from the requested record number.

One of two possible results depending on the value of the specified test.

True(1) if the specified field is empty, if the related field, related table, 
relationship, or file is missing, or if some other error occurs; otherwise 
returns False(0).

 when a record contains an invalid value because of a data type mismatch 

(text in a date field, for example).

True(1) if the syntax of the specified expression is correct.

Sets variable to the result of value for the duration of the specified 
expression.

The value specified in the sourceField parameter using the 

in the 

The value specified in the sourceField parameter using the relationships 

in the relationships graph.