FileMaker returns Error Codes when they occur.

When developing and running scripts, these error codes give us feed back as to what happened so scripting can solve it’s own problems.  Frequently, error code evaluations are decision or trigger points in scripts for adjusting to circumstances.

To use FileMaker Error codes in your scripts, we first need to set “Error Capture” to “On”… so earlier than the decision point, we need to have the script command;

Set Error Capture [on]

After we have an executed the script step that would product an error, such as “Perform Find”, we need to test for an error with the Get(LastError) command.

For Example, lets say that you want to have a script find for something and tell the user that none exist if that is the case.
Script Steps:
• Set Error Capture[On]
• Enter Find Mode
• Set Field[TABLE_1__::find_field; $DesiredFindResult]
• Perform Find
• If[get(lasterror)>0]
• Set Field[TABLE_1::z_tempErrorReturn_g ; get(lasterror) ] (or do something else like show all records)
• Show Custom Dialogue [ No Records Were Found that matched your requests]
• Halt Script
• End If

FileMaker Pro 9 Error Codes

Error Number Description