Logical functions
Logical functions test for a condition to evaluate it as true or false. This is known as a Boolean value. If the condition is true, FileMaker Pro returns a 1; if the condition is false, FileMaker Pro returns a 0. You can use the keywords True and False with logical functions and operators when a Boolean value is needed. Keyword True returns 1 and keyword False returns 0.
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 field.
|
Function |
Purpose |
|
Returns one of several possible results based on a series of tests. |
|
|
Returns one result value, according to the integer value of a test. |
|
|
Evaluates an expression as a calculation. |
|
|
Returns an error code, if any, from an expression. |
|
|
Executes an SQL query statement for the specified table occurrence in a FileMaker Pro file. |
|
|
Executes an SQL query statement for the specified table occurrence in a FileMaker Pro file and, if an error occurs, returns ? followed by an error message. |
|
|
Returns 1 (true) if data converts to a non-zero numeric value or a container field holds data; otherwise, returns 0 (false). |
|
|
Evaluates fieldName and returns the contents of the specified field. |
|
|
Returns the contents of a field from the specified record number. |
|
|
Returns the value of summaryField for the current range of records when the file is sorted by breakField. |
|
|
Returns result1 if the test is true; returns result2 if the test is false. |
|
|
Returns 1 (true) if a field is empty or if other errors occur; otherwise, returns 0 (false). |
|
|
Returns 0 (false) if the data is invalid; otherwise, returns 1 (true). |
|
|
Returns 1 (true) if an expression syntax is correct; otherwise, returns 0 (false). |
|
|
Sets a variable or variables to the result of the specified expression(s) for the duration of the calculation, or until the script exits or the file is closed. |
|
|
Returns the value specified in sourceField, using the relationships in the relationships graph. |
|
|
Returns the next lower or higher value in sourceField when there isn't a matching related value. |
|
|
Returns the content of the object in which the calculation is defined. |
|
|
Sets the maximum number of iterations for recursion and loops within an expression. |
|
|
Repeats logic while the condition is true, then returns the result. |