Filemaker Pro 8.5 DE CD Box 5pk TH328D/A Manual Do Utilizador
Códigos do produto
TH328D/A
Chapter 8
|
Logical functions 137
IsValid
Format
IsValid(field)
Parameter
field - any
Data type returned
number
Description
Returns False (0) when:
•
•
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
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
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
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
Data type returned
number