Returns a value corresponding to the type of error as defined by the X/Open and SQL Access Group SQL.
Syntax
object.SQLState
The object placeholder represents an object expression that evaluates to an object in the Applies To list.
Return Values
The SQLState return value is a five-character string expression, as described in Remarks.
Remarks
When an RDO operation returns an error, or completes an operation, the SQLState property of the rdoError object is set. If the error is not caused by ODBC or if no SQLState is available, the SQLState property returns an empty string.
The character string value returned by the SQLState property consists of a two-character class value followed by a three-character subclass value. A class value of "01" indicates a warning and is accompanied by a return code of rdSQLSuccessWithInfo.
Class values other than "01", except for the class "IM", indicate an error and are accompanied by a return code of rdSQLError. The class "IM" is specific to warnings and errors that derive from the implementation of ODBC itself. The subclass "000" in any class is for implementation-defined conditions within the given class. The assignment of class and subclass values is defined by ANSI SQL-92.