4D v14.3

SQL GET LAST ERROR

Home

 
4D v14.3
SQL
SQL GET LAST ERROR

SQL GET LAST ERROR 


 

SQL GET LAST ERROR ( errCode ; errText ; errODBC ; errSQLServer ) 
Parameter Type   Description
errCode  Longint in Error code
errText  Text in Error text
errODBC  Text in ODBC error code
errSQLServer  Longint in SQL server native error code

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.

 
PROPERTIES 

Product: 4D
Theme: SQL
Number: 825

 
HISTORY 

Created: 4D 2004

 
SEE ALSO 

GET LAST ERROR STACK
ON ERR CALL

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)