4D v14.3
SQL GET LAST ERROR
- 4D Language Reference
-
- SQL
-
- Overview of SQL Commands
- On SQL Authentication Database Method
- Begin SQL
- End SQL
- Get current data source
- GET DATA SOURCE LIST
- Is field value Null
- QUERY BY SQL
- SET FIELD VALUE NULL
- SQL CANCEL LOAD
- SQL End selection
- SQL EXECUTE
- SQL EXECUTE SCRIPT
- SQL EXPORT DATABASE
- SQL EXPORT SELECTION
- SQL GET LAST ERROR
- SQL GET OPTION
- SQL LOAD RECORD
- SQL LOGIN
- SQL LOGOUT
- SQL SET OPTION
- SQL SET PARAMETER
- START SQL SERVER
- STOP SQL SERVER
- USE EXTERNAL DATABASE
- USE INTERNAL DATABASE
SQL GET LAST ERROR
| SQL GET LAST ERROR ( errCode ; errText ; errODBC ; errSQLServer ) | ||||||||
| Parameter | Type | Description | ||||||
| errCode | Longint |
|
Error code | |||||
| errText | Text |
|
Error text | |||||
| errODBC | Text |
|
ODBC error code | |||||
| errSQLServer | Longint |
|
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 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.
Product: 4D
Theme: SQL
Number:
825
Created: 4D 2004
GET LAST ERROR STACK
ON ERR CALL
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)
