如果语句中有任何参数标记,则 SQLExecute 通过使用当前参数标记变量的值来执行准备
好的语句。
下表描述了 SQLExecute 的 SQLSTATE 和错误值。
SQLSTATE
错误值
错误消息
01000
-11001
General warning
01004
-11003
Data truncated
01006
-11004
Privilege not revoked
01S03
-11008
No rows updated or deleted
GBase 8s ODBC Driver 程序员指南
南大通用数据技术股份有限公司
- 222 -
SQLSTATE
错误值
错误消息
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 可以返回 SQLPrepare 基于数据源评估与 hstmt 关联的 SQL 语句时返回的
SQLSTATE。