Functions Reference

Chapter 7
|
Get functions 83
Data type returned
number
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
• For ODBC imports and Execute SQL script steps, 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.
• For working with ODBC data sources in the relationships graph, returns the readable
error string that is generated by the ODBC driver.
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.
• See FileMaker Pro Help for information about running scripts in client/server and
peer-to-peer environments.