Exit Loop If

Purpose

Exits a loop if the specified calculation is True (not zero).

Format

Exit Loop If [<Boolean calculation>]

Options

Click Specify to define the Boolean calculation. In the Specify Calculation dialog box, type the calculation you want evaluated, or use the field list (on the left) and the functions list (on the right) with the mathematical and text operators to build the calculation.

Compatibility


Where the script step runs	Supported
FileMaker Pro	Yes
FileMaker Server scheduled script	Yes
FileMaker Go	Yes
Custom Web Publishing	Yes
Instant Web Publishing	Yes
Runtime solution	Yes

Originated in

FileMaker Pro 6.0 or earlier

Description

If the calculation is True (not zero), the script continues with the script step that follows the End Loop script step.

If the calculation if False (zero), the loop is not exited and the script continues with the script step that follows the Exit Loop If script step.

Examples

This example calculates a bonus for the top 10 sales agents based on their sales. The script finds all records and sorts by a field called "Sales" (descending) to arrange the agents by sales performance. The script starts at the first record and sets the loop counter variable to 1 (in this example the loop counter field use is a number field with global storage enabled -- this is the Count field in the example below). Then, the script calculates the bonus as one quarter of the agent's salary. The script then goes to the next record and exits the loop if the counter reaches 10. The loop counter increments by 1 and the loop repeats.

Show All Records
Sort Records[Restore; No dialog]
Set Field [Table1::Count; 1]
Loop
Set Field [Table1::Bonus; Table1::Salary * .25]
Go to Record/Request/Page[Next]
Exit Loop If [Table1::Count = 10]
Set Field [Table1::Count; Table1::Count + 1]
End Loop