SQLExecute (core level only)
SQLExecute executes a prepared statement by using the current values of the parameter-marker variables if any parameter markers exist in the statement.
The following table describes the SQLSTATE and error values
for SQLExecute.
| SQLSTATE | Error value | Error message |
|---|---|---|
| 01000 | -11001 | General warning |
| 01004 | -11003 | Data truncated |
| 01006 | -11004 | Privilege not revoked |
| 01S03 | -11008 | No rows updated or deleted |
| 01S04 | -11009 | More than one row updated or deleted |
| 07001 | -11012 | Wrong number of parameters |
| 07S01 | -11014 | Invalid use of default parameter. |
| 08S01 | -11020 | Communication-link failure |
| 22003 | -11025 | Numeric value out of range |
| 22005 | -11026 | Error in assignment |
| 22008 | -11027 | Datetime field overflow |
| 22012 | -11028 | Division by zero |
| 23000 | -11030 | Integrity constraint violation |
| 24000 | -11031 | Invalid cursor state |
| 40001 | -11037 | Serialization failure |
| 42000 | -11038 | Syntax error or access violation |
| S1000 | -11060 | General error |
| S1001 | -11061 | Memory-allocation failure |
| S1008 | -11065 | Operation canceled |
| S1010 | -11067 | Function-sequence error |
| S1090 | -11071 | Invalid string or buffer length |
| S1109 | -11089 | Invalid cursor position |
| S1C00 | -11092 | Driver not capable |
| S1T00 | -11094 | Time-out expired |
| S1C00 | -11300 | SQL_DEFAULT_PARAM not supported |
| 08S01 | -11301 | A protocol error has been detected. Current connection is closed. |
| S1000 | -11320 | Syntax error |
| S1000 | -11323 | The statement contained an escape clause not supported by this database driver |
SQLExecute can return any SQLSTATE that SQLPrepare can return based on when the data source evaluates the SQL statement associated with the hstmt.