SqlStateCode Class

Provides the possible values of the SQLState property of a SQLException raised by Blackfish SQL.

Pascal

SqlStateCode = class;

C++

class SqlStateCode;

File

SqlStateCode.cs

Description

Provides the possible values of the SQLState property of a SQLException raised by Blackfish SQL.

Each value is a 5 character error code defined in the SQL92 standard. The first 2 characters are an error class value, and the latter 3 characters are a subclass error value.

This table lists the possible error class values (the first two characters in the error code):

Error Class	Description
02	No data.
08	Connection error.
0A	Feature not supported.
21	Cardinality violation.
22	Data exception.
24	Invalid cursor state.
42	Syntax or access violation.
44	Check option violation.
HZ	Remote database access error.
IM	Non standard error class.

This table lists the 5–character SQL error codes:

Constant	Description
Sql02000	Query has no result set.
Sql08001	SQL connection could not be made.
Sql08003	SQL connection was never made or was previously closed.
Sql08004	SQL connection rejected by server.
Sql08006	General connection error.
Sql0A000	Feature not supported.
Sql21000	Cardinality error.
Sql22000	General data exception.
Sql22001	String data with too many chars/bytes.
Sql22003	Numeric value out of range.
Sql22005	Value could not be casted to target type.
Sql22007	Malformed date/time value.
Sql22011	SUBSTRING error.
Sql22012	Divide by zero error.
Sql22019	Invalid escape character in LIKE operator.
Sql22023	Invalid parameter.
Sql22025	Invalid LIKE pattern.
Sql22027	TRIM error.
Sql23000	Integrity constraint violation.
Sql24000	Invalid cursor state.
Sql42000	Syntax or access violation.
Sql44000	With check option violation.
SqlHz309	Unknown protocol request encountered.
SqlHz316	Network protocol error.
SqlHz320	Network protocol version mismatch.
SqlIm000	General error category.

What do you think about this topic? Send feedback!