Chapter 8
|
Logical functions 137
IsValid
Format
IsValid(field)
Parameter
field - any field name
Data type returned
number
Description
Returns False (0) when:
•A record contains an invalid value because of a data type mismatch (text in a date
field, for example)
• FileMaker Pro cannot locate (temporarily or permanently) the related table in which
the referenced field is defined
• A field has been deleted from a related table, and therefore the references to that
field in the parent table are invalid
Otherwise it returns 1 (the data is valid).
Examples
IsValid(Datefield) returns 0 if there is non-date data in Datefield, for example if text
was imported into it.
IsValid(Amount) returns 0 if there is only text in the number field Amount.
IsValid(table::field) returns 0 if the related table was renamed and the
relationship isn’t updated with the new filename.
IsValidExpression
Format
IsValidExpression(expression)
Parameter
expression - any calculation expression
Data type returned
number
Commentaires sur ces manuels