Script Steps Reference

62 FileMaker Script Steps Reference
Description
Deletes all the records in the current found set. First, find the records you want to delete (using
the Perform Find script step on page 71), and then use Delete All Records to delete them.
Important You cannot undo a Delete All Records script step.
Example
Perform Find [Restore]
Omit
Delete All Records
Perform Script ["Data Entry"]
Open Record/Request
Format
Open Record/Request
Options
None.
Web compatibility
This script step is web-compatible.
Description
Makes an existing record or find request available for editing. When performed on a record, the
Open Record/Request script step verifies that the user has sufficient access privileges to edit
the record. If the user has the proper privilege set, FileMaker Pro attempts to prevent others
from simultaneously editing or deleting the record. Once locked, the record is considered
“opened” and may be edited.
If an error occurs (for example, if the current user has insufficient access privileges, the record
is currently locked by another user, or the record is open in another window), FileMaker Pro
generates an error message, which may be captured using the Set Error Capture script step
on page 27 and the Get(LastError) function. (Opening a find request will not return an error,
because requests can’t be locked by other users.)
Important Because any attempt to modify a field or a record will also attempt to open the record
for editing, in most cases you will not need to use the Open Record/Request script step to open
a record explicitly. But when using the or the Go to Record/Request/Page script step on page
30 to enter a field or record, use the Open Record/Request script step first to obtain a write lock.
Example
Perform Find [Restore]
Go to Record/Request/Page [Last]
If [IsEmpty(script examples::Field1)]
Open Record/Request
End If