QUE CORPORATION - Using Filemaker pro X

Get(LastODBCError)

Category: Get

Syntax: Get ( LastODBCError )

Parameters: none

Description: Returns a string that shows the ODBC error state (SQLSTATE), as published by ODBC standards, based on ISO/IEF standards.

The ODBC error state is cleared before the next ODBC- related script step is performed. Anytime before that happens, you can check to see whether an ODBC error was generated.

Examples:

When attempting to execute a SQL statement with an invalid field name , Get (LastODBCError) returns S0022 .

If no error is encountered , Get (LastODBCError) returns 00000 .

Comments:

By setting Error Capture to On, you can suppress the error messages that a user sees during execution of a script that uses ODBC functions.