SQLErrorInfo Class (Typed) | ![]() |
Namespace: XSharp.VO.SDK
The SQLErrorInfo type exposes the following members.
Name | Description | |
---|---|---|
![]() | SQLErrorInfo |
Construct a SQLErrorInfo object.
|
Name | Description | |
---|---|---|
![]() | Arg | A string representing the argument supplied to an operator or function when an argument error occurs. (Inherited from Error.) |
![]() | ArgNum | A numeric value representing the number of the argument supplied to an operator or function when an argument error occurs. (Inherited from Error.) |
![]() | Args | An array of the arguments supplied to an operator or function when an argument error occurs. (Inherited from Error.) |
![]() | ArgType | A numeric value representing the data type of the argument that raised the error. (Inherited from Error.) |
![]() | ArgTypeReq | A numeric value representing the expected type of the argument that raised the error. (Inherited from Error.) |
![]() | ArgTypeReqType | The system type representing the expected type of the argument that raised the error. (Inherited from Error.) |
![]() | ArgTypeType | The system type representing the data type of the argument that raised the error. (Inherited from Error.) |
![]() | CallFuncSym | A symbol representing the calling function of the function in which the error occurred. (Inherited from Error.) |
![]() | CanDefault | A logical value indicating whether the subsystem can perform default error recovery for the error condition. (Inherited from Error.) |
![]() | CanRetry | A logical value indicating whether the subsystem can retry the operation that caused the error condition. (Inherited from Error.) |
![]() | CanSubstitute | A logical value indicating whether a new result can be substituted for the operation that produced the error condition. (Inherited from Error.) |
![]() | Cargo | A value of any data type unused by the Error system. It is provided as a user-definable slot, allowing arbitrary information to be attached to an Error object and retrieved later (Inherited from Error.) |
![]() | Description | A string that describes the error condition. (Inherited from Error.) |
![]() | ErrorFlag |
A logical value representing whether a SQL error has just occurred.
|
![]() | ErrorList | |
![]() | ErrorMessage |
A string that contains the SQL error message.
|
![]() | ErrorMessageLen |
A numeric value that represents the SQL error message length.
|
![]() | FileHandle | A numeric value representing the file handle supplied to a function when an file error occurs. (Inherited from Error.) |
![]() | FileName | A string representing the name used to open the file associated with the error condition. (Inherited from Error.) |
![]() | FuncPtr | A pointer to the function in which the error occurred. (Inherited from Error.) |
![]() | FuncSym | A string representing the name of the function or method in which the error occurred. (Inherited from Error.) |
![]() | Gencode | An integer numeric value representing a Visual Objects generic error code. (Inherited from Error.) |
![]() | GenCodeText | An string containing the description of the Gencode. (Inherited from Error.) |
![]() | MaxSize | A numeric value representing a boundary condition for an operation (such as string overflow or array bound error). (Inherited from Error.) |
![]() | MethodSelf | An object representing the SELF of the method in which the error occurred. (Inherited from Error.) |
![]() | NativeError |
A numeric value that represents the native SQL error.
|
![]() | Operation | A string that describes the operation being attempted when the error occurred. (Inherited from Error.) |
![]() | OSCode | A value of 0 indicates that the error condition was not caused by an error from the operating system. (Inherited from Error.) |
![]() | OSCodeText | Descripion of the OSCode (Inherited from Error.) |
![]() | ReturnCode |
A numeric value that represents the SQL return code value (for example, SQL_ERROR, SQL_SUCCESS_WITH_INFO, etc.).
|
![]() | Severity | A constant indicating the severity of the error condition. (Inherited from Error.) |
![]() | SQLState |
A string that contains the SQL error state (for example, S1000, which is a general error).
|
![]() | Stack | Call stack from the moment where the error object was created (Inherited from Error.) |
![]() | StackTrace | (Inherited from Error.) |
![]() | SubCode | An integer numeric value representing a subsystem-specific error code. (Inherited from Error.) |
![]() | SubCodeText | An string containing the description of the SubCode. (Inherited from Error.) |
![]() | SubstituteType | A numeric value representing the type of the new result that the error handler substitutes for the operation that produced the error condition. (Inherited from Error.) |
![]() | SubSystem | A string representing the name of the subsystem generating the error. (Inherited from Error.) |
![]() | Tries | An integer numeric value representing the number of times the failed operation has been attempted. (Inherited from Error.) |
Name | Description | |
---|---|---|
![]() | SetStackTrace | (Inherited from Error.) |
![]() | ShowErrorMsg |
Display an SQL error message.
|
![]() | Throw | Throw the error. (Inherited from Error.) |
![]() | ToString | Creates and returns a string representation of the current exception. (Inherited from Error.) |
Name | Description | |
---|---|---|
![]() | GetInnerException | (Defined by Error.) |
1LOCAL oSQLErrorInfo AS OBJECT 2LOCAL oConnection AS OBJECT 3LOCAL oSelect AS OBJECT 4// Create the object for SQLConnection 5oConnection := SQLConnection{"sample", "dba",; 6"sql"} 7// Create the object for SQLSelect 8oSelect := SQLSelect{"SELECT * FROM lab", 9oConnection} 10// Test for invalid argument 11IF SQLGetStmtOption(oSelect:StatementHandle,; 1230000, NULL_PTR) # SQLSuccess 13// Now, create SQLErrorInfo object to pick up 14// last error. The first two parameters are 15// optional, followed by the environment handle, 16// the connection handle, followed by the 17// statement handle from SQLSelect. 18oSQLErrorInfo := SQLErrorInfo{ , , ; 19oConnection:EnvHandle,; 20oConnection:ConnHandle,; 21oSelect:StatementHandle} 22ENDIF 23?oSQLErrorInfo:ErrorFlag 24?oSQLErrorInfo:ErrorMessage 25?oSQLErrorInfo:NativeError 26?oSQLErrorInfo:SQLState