Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Get functions > Get(LastODBCError) function |
|
|
| Get(LastODBCError) function |
| 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 error codes. |
|
See Solving calculations on a host machine for information about running scripts in client/server and peer-to-peer environments. |
| Example |
| 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 |
|
|
| Contents > Functions reference (alphabetical list) > Get functions > Get(LastODBCError) function |
|
|
Next Page |
|