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 contained an escape clause not supported by this database driver