SQL GET LAST ERROR

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 2004


SQL GET LAST ERROR (errCode; errText; errODBC; errSQLServer)

ParameterTypeDescription
errCodeLongintError code
errTextTextError text
errODBCTextODBC error code
errSQLServerLongintSQL server native error code

Description

The SQL GET LAST ERROR command returns information related to the last error encountered during the execution of an ODBC command. The error may come from the 4D application, the network, the ODBC source, etc.

This command must generally be called in the context of an error-handling method installed using the ON ERR CALL command.

The errCode parameter returns the error code.

The errText parameter returns the error text.

The last two parameters are only filled when the error comes from the ODBC source; otherwise, they are returned empty.

The errODBC parameter returns the ODBC error code (SQL state).

The errSQLServer parameter returns the SQL server native error code.

See Also

GET LAST ERROR STACK, ON ERR CALL.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next