SQLPrepare prepares an SQL string for execution.
The following table describes the SQLSTATE and error values for SQLPrepare.
| SQLSTATE | Error Value | Error Message |
|---|---|---|
| 01000 | -11001 | General warning |
| 08S01 | -11020 | Communication-link failure |
| 21S01 | -11021 | Insert value list does not match column list |
| 21S02 | -11022 | Degree of derived table does not match column list |
| 22005 | -11026 | Error in assignment |
| 24000 | -11031 | Invalid cursor state |
| 34000 | -11034 | Invalid cursor name |
| 37000 | -11035 | Syntax error or access violation |
| 42000 | -11038 | Syntax error or access violation |
| S0001 | -11053 | Base table or view already exists |
| S0002 | -11054 | Base table not found |
| S0011 | -11055 | Index already exists |
| S0012 | -11056 | Index not found |
| S0021 | -11057 | Column already exists |
| S0022 | -11058 | Column not found |
| S1000 | -11060 | General error |
| S1001 | -11061 | Memory-allocation failure |
| S1008 | -11065 | Operation canceled |
| S1009 | -11066 | Invalid argument value |
| S1010 | -11067 | Function-sequence error |
| S1090 | -11071 | Invalid string or buffer length |
| S1C00 | -11092 | Driver not capable |
| S1T00 | -11094 | Time-out expired |
| 08S01 | -11301 | A protocol error has been detected. Current connection is closed. |
| S1000 | -11310 | Create and Drop must be executed within a ServerOnly Connection |
| S1000 | -11320 | Syntax error |
| S1000 | -11323 | The statement contains an escape clause not supported by this database driver |