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.