<ADODB_Connection>.Errors().Description

<< Click to Display Table of Contents >>

Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Connection > ADODB_Connection Interfaces > <ADODB_Connection>.Errors >

<ADODB_Connection>.Errors().Description

 

Description

 
Returns the description of an error.

 

Syntax

 

s = <ADODB_Connection>.Errors(lIndex).Description

 

Returns

 

String.

 

Parameters

 

Name

Type

Optional

Meaning

lIndex

Numeric

No

Error index from 1 to <ADODB_Connection>.Errors.Count

 

Remarks

 

Both the provider and ADODB can be the source of the error.

The provider should pass error information to ADODB. When an error occurs, ADODB should create an Error object, which contains error information.

ADODB should also add the Error object to the Errors Collection.

 

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

...