Functions Reference

Table Of Contents

FILEMAKER FUNCTIONS REFERENCE 103

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.

• 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

www.filemaker.com/kb.

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.