Get(LastError)
Purpose 
Returns a number representing the error, if any, in the execution of the most recently executed script step.
Format 
Get(LastError)
Parameters 
None
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Use this function to detect and control the outcome of errors. See FileMaker Pro error codes.
Notes
 •
Mac OS: In FileMaker Pro, if an error occurs while performing an AppleScript from the Manage Scripts feature, the AppleScript error code will be returned.
 •
For ODBC imports and Execute SQL script steps, if an error occurs while performing a SQL query, returns FileMaker error 1408. For detailed information about the error, use the Get(LastODBCError) function. If there is no information about the error, returns FileMaker error 1409.
 •
 •
Some script triggers allow for the activating command or event to be canceled if the script executed by the script trigger returns a False value. When a command or event is canceled this way, the error code is set to 20.
 •
When you perform a script that uses this function with control script steps, the control script steps do not clear the last error condition reported by FileMaker Pro.
 •
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.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas