Get(LastODBCError)
Purpose 
Returns a string that shows the error state published by ODBC standards, based on ISO/IEF standards.
Format 
Get(LastODBCError)
Parameters 
None
Data type returned 
text
Description 
  •
For ODBC imports and Execute SQL script steps, returns a detailed, textual ODBC error message.
  •
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 error codes.
  •
For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at www.filemaker.com/kb.
Examples 
For ODBC imports and Execute SQL script steps, 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.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Editing ODBC data sources
Was this topic helpful? Send feedback.