Functions Reference

Description
Returns a number corresponding to the button clicked in an alert message that is
displayed by the Show Custom Dialog script step.
Returns:
• 1 for the first button (by default, labeled OK)
• 2 for the second button (by default, labeled Cancel)
• 3 for the third button
Note See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.
Get(LastODBCError)
Format
Get(LastODBCError)
Parameter
None
Data type returned
text
Description
Returns a string that shows the ODBC error state (SQLSTATE), as published by ODBC
standards, based on ISO/IEF standards.
You can obtain the error state after an ODBC-related script step has been executed to
check for known errors and determine if you want to continue with the script
. The ODBC
error state is cleared before the next ODBC-related script is executed. An error message,
based on the error state returned by the ODBC driver, is displayed.
Notes
• You can set the Set Error Capture state to “on” to suppress the error messages. You
can also use Get(LastError) to get generic errors.
• See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.
Example
Returns [DataDirect][Macintosh ODBC Driver Manager] Data source name not found
and no default driver specified (-1) when a data source name wasn’t found and the
driver wasn’t specified.