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

<ADODB_Connection>.Errors().NativeError

Previous pageReturn to chapter overviewNext page

 

Description

 
Returns a long value that is an error code returned to ADODB by the provider or the data source.

 

Syntax

 

n = <ADODB_Connection>.Errors(lIndex).NativeError

 

Returns

 

Number.

 

Parameters

 

Name

Type

Optional

Meaning

lIndex

Numeric

No

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

 

Remarks

 

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

...