Filemaker Upgrade FileMaker Pro 8.5 DE CD TH326D/A Manual De Usuario
Los códigos de productos
TH326D/A
136 FileMaker Functions Reference
Description
Returns one of two possible results depending on the value of test. If test is True (any
non-zero numeric result), FileMaker Pro returns result1. If test is False (0), result2
is returned. Test must be an expression that returns either a numeric or
(True,
False) result.
Notes
•
If you have more than two possible results, consider using the Case function.
•
By default, if test refers to a field that doesn’t yet contain a value, the If function
returns an empty result. To override this functionality, deselect the
Do not evaluate if
all referenced fields are empty
checkbox.
Examples
If(Country = “USA”;“US Tech Support”;“International Tech Support”)
returns
International Tech Support
, if the Country field contains France or Japan.
Returns
US Tech Support
if the Country field contains USA.
If(State =”CA”;Subtotal * CA Tax Rate;0) returns the tax if the purchaser is
a resident of California, otherwise returns
0
.
IsEmpty
Format
IsEmpty(field)
Parameter
field - any
, or numeric expression
Data type returned
number
Description
Returns True(1) if field is empty, if a
,
, or file is
missing, or if some other error occurs; otherwise returns False(0).
Examples
IsEmpty(OrderNum) returns
1
if the OrderNum field is empty.
If(IsEmpty(LastName);“Invalid record”;““) displays
Invalid Record
if the
LastName field is blank, but displays nothing if there is an entry in LastName.
IsEmpty(Payments::DatePaid) returns
1
if, for example, the Payments table has
been moved or renamed.
IsEmpty(“text”) returns
0
.