|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Connection > ADODB_Connection Interfaces > <ADODB_Connection>.Errors > <ADODB_Connection>.Errors().Number |
Description
Returns a unique number that identifies the error.
Syntax
n = <ADODB_Connection>.Errors(lIndex).Number
Returns
Number.
Parameters
Name |
Type |
Optional |
Meaning |
lIndex |
Numeric |
No |
Error index from 1 to <ADODB_Connection>.Errors.Count |
Remarks
The Number property returns a long value that is a unique number that can take one of the ErrorValueEnum values.
The number describes the error generated by ADODB. If the error was generated by the provider, this property may be set to an unspecific error value.
Restrictions
See also
Examples
...
'---To check if there is an error, always use connection and Errors.Count method
'---In this example all errors are reported in one go using pConn.Errors.Msg
If pConn.Errors.Count Then
PrintL "--> Error happened:" In %CCOLOR_FLIGHTRED
printl pConn.Errors.Msg
pConn.Errors.Clear
End If
...
...
'---To check if there is an error, always use connection and Errors.Count method
'---In this example every single error is reported reading Error by Error information
If pConn.Errors.Count Then
PrintL "--> Error happened:" In %CCOLOR_FLIGHTRED
For nError = 1 to pConn.Errors.Count
PrintL "Error number..:", pConn.Errors(nError).Number
PrintL "Description...:", pConn.Errors(nError).Description
PrintL "Source........:", pConn.Errors(nError).Source
PrintL "SQLState......:", pConn.Errors(nError).SQLState
PrintL "NativeError...:", pConn.Errors(nError).NativeError
Next
'---Clear all errors so new errors will restart to fill Errors collection
pConn.Errors.Clear
End If
...