Script Steps Reference

Records script steps
F
ILEMAKER PRO SCRIPT STEPS REFERENCE 117
Delete All Records
Purpose
Deletes all the records in the current found set.
Format
Delete All Records [With dialog: On/Off]
Options
With dialog specifies whether to display a dialog box when the script step is performed, asking
users to confirm deletion of all records.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
Important You cannot undo deleting records.
Delete All Records attempts to lock a group of records in the found set before deleting them. If it can
lock all records in the group, this script step deletes the group of records, attempts to lock the next
group of records, and so on. The first time it can’t lock all records in a group (for example, if a record
is being edited by another user), Delete All Records stops and returns an error code (which can be
captured with the Get(LastError) function).
Notes
• To delete all records in the current table, use the Show All Records script step, then use
Delete All Records.
Example 1
Asks if the user wants to delete all records in the current table.
Show All Records
Delete All Records [With dialog: On]
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server Partial
FileMaker Go Yes
Custom Web Publishing Partial
FileMaker WebDirect Yes
Runtime solution Yes