FORMULA LANGUAGE
Examples: @IsError
1. This example returns 1.
@IsError(1/0)
2. This example returns 0.
@IsError(1/2)
3. This formula checks to see if there is an @ERROR in the Price field, and returns "There is an error in the price field" if it encounters an error; otherwise it returns 0.
@If(@IsError(Price);
@Failure("There is an error in the price field"); @Success)
4. This agent tests the return value of an @DbLookup statement for an error. If the @DbLookup statement causes an error, the agent returns the text "Not available."
FIELD Phone := @DbLookup(""; "Snapper" : "names.nsf"; "People";
@Right(Name; " ") + " , " + @Left(Name; " "); "OfficePhoneNumber");
@If(@IsError(Phone);"Not available")
See Also
@IsError
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary