Get(LastError)
 
Purpose 
Returns a number for the error that occurred 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
 •
OS X: In FileMaker Pro, if an error occurs while performing an AppleScript via the Perform AppleScript (OS X) script step, 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.
 •
For working with ODBC data sources in the relationships graph, returns FileMaker error 1408.
 •
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.
 •
For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
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
Was this topic helpful? Send feedback.