Filemaker TH325Z/A Ficha Técnica descarregar pdf (Página 137)

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

1 2 ... 132 133 134 135 136 137 138 139 140 141 142 ... 237 238

Sem comentários

Filemaker TH325Z/A Ficha Técnica Página 137