Delete All Records
 
Purpose 
Deletes all the records in the current found set.
See also 
Deleting records
Creating scripts to automate tasks
Format 
Delete All Records [No dialog]
Options 
Perform without dialog prevents a message box from displaying when the script step executes that asks the user to confirm the deletion of records.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Partial 
FileMaker Go 
Yes 
Custom Web Publishing 
Partial 
FileMaker WebDirect 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
To delete all records in the current table, use the Show All Records script step, then use Delete All Records.
Important  You cannot undo a Delete All Records script step.
Example 1 
Asks if the user wants to delete all records in the current table.
Show All Records
Delete All Records [ ]
Example 2 
Asks if the user wants to delete all records in the current found set.
Show Custom Dialog ["Do you want to delete all " & Get ( FoundCount ) & " records found?"]
If [Get ( LastMessageChoice ) = 1]
Delete All Records [No dialog]
End If
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.