Script Steps Reference

Records script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 117
Open Record/Request
Purpose
Makes an existing record or find request available for editing if the current user has record-editing
privileges.
Format
Open Record/Request
Options
None.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
This script step makes an existing record available (in Browse mode) or an existing find request
available (in Find mode) for editing if the current user has record-editing privileges. 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.
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server scheduled script Yes
FileMaker Go Yes
Custom Web Publishing Yes
FileMaker WebDirect Yes
Runtime solution Yes