Functions Reference

Notes
• Mac OS: In FileMaker Pro, if an error occurs while performing an AppleScript from
ScriptMaker™, the AppleScript error code will be returned.
• In FileMaker Pro, if an error occurs while performing a SQL query, a SQLSTATE error
will be returned by ODBC.
• See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.
Tip To create a script that responds to errors without displaying alerts, use this function
with the Set Error Capture script step with the On option.
Examples
Returns 0 when the most recent script step executed successfully.
Returns 401 when no records are found after the Perform Find script step has been
executed.
Runtime errors
Error
Number
Description
-1 Unknown error
0 No error
1 User canceled action
2 Memory error
3 Command is unavailable (for example, wrong operating system, wrong mode, etc.)
4 Command is unknown
5 Command is invalid (for example, a Set Field script step does not have a calculation
specified)
6 File is read-only
7 Running out of memory
8 Empty result
9 Insufficient privileges
10 Requested data is missing
11 Name is not valid
12 Name already exists
13 File or object is in use
14 Out of range
15 Can't divide by zero
16 Operation failed, request retry (for example, a user query)
17 Attempt to convert foreign character set to UTF-16 failed
18 Client must provide account information to proceed
19 String contains characters other than A-Z, a-z, 0-9 (ASCII)