Script Steps Reference

FILEMAKER SCRIPT STEPS REFERENCE 70
Important You cannot undo a Delete All Records script step.
Examples
Perform Find [Restore]
Omit
Delete All Records
Perform Script ["Data Entry"]
Related topics
Script steps reference (alphabetical list)
Contents
Open Record/Request
Purpose
Makes an existing record or find request available for editing.
Format
Open Record/Request
Options
None.
Compatibility
This script step is also supported in web publishing and in a FileMaker Server scheduled script.
Originated in
FileMaker Pro 6.0 or earlier
Description
When performed on a record, this 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 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
Go to Record/Request/Page script step to enter a field or
record, use the Open Record/Request script step first to obtain a write lock.