Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual
Product codes
TG761Z/A
138 FileMaker Functions Reference
Description
Returns
True (1)
if expression syntax is correct. Returns
False (0)
if expression has
a syntax error.
Examples
IsValidExpression(calculationField) returns
1
(true) when
calculationField contains
total + 1
.
IsValidExpression(calculationField) returns
0
(false) when
calculationField contains
abs(-1
with no closing parenthesis.
Let
Format
Let({[}var1=expression1{;var2=expression2...]};calculation)
Parameters
var
- any variable name, local variable name, or global variable name (see FileMaker Pro
help for guidelines on naming variables)
expression
- any calculation
,
, or
calculation
- any calculation expression, field, or constant
Parameters in curly braces { } are optional.
Data type returned
text, number, date, time, timestamp, container
Description
Sets varX to the result of expressionX for the duration of calculation, until the script
exits (local variables), or until the file is closed (global variables). Multiple variables are
allowed when using a list syntax that is enclosed in square brackets [ ] and is separated
by semicolons. For example:
exits (local variables), or until the file is closed (global variables). Multiple variables are
allowed when using a list syntax that is enclosed in square brackets [ ] and is separated
by semicolons. For example:
Let([variable=value;variable2=value2];calculation)
The $ symbol references a local variable and two $$ symbols reference a global variable.
An optional repetition number appears in square brackets [ ] immediately after the variable
name. For example:
An optional repetition number appears in square brackets [ ] immediately after the variable
name. For example:
Let([$variable[repetition]=value;$$variable2=value2]{;calculation
} )
} )