CLASS:

 

 

 

 

 

 

 

 

 

DESCRIPTION:

 

 

 

Represents an errors collection object.

 

 

 

 

 

SYNTAX:

 

 

 

These objects are created automatically by the ADO components.

 

 

 

It captures any error syntax in SQL expressions, wrong parameters, properties etc..

 

 

 

 

 

PROPERTY:

DEFAULT:

DESCRIPTION:

 

 

baseClassName

ADOERRORARRAY

Identifies the object as an instance of the ADOErrorArray class 

 

 

className

ADOERRORARRAY

Identifies the object as an instance of a custom class. When no custom class exists, defaults to baseClassName

 

 

parent

null

Reference to the ADO object that contains this array.

 

 

size

0

The number of elements in the array

 

 

 

 

 

 

 

 

 

 

 

METHOD:

PARAMETERS:

DESCRIPTION:

 

 

find

<code expC>

method is currently unavailable

 

 

clear

 

 

 

 

refresh

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DESCRIPTION:

 

 

 

 

 

As each error occurs, one or more ADOError objects are placed in the ADOErrorArray collection of the ADODatabase object.

 

 

When another ADO operation generates an error, the ADOErrorArray is cleared, and the new set of ADOError objects is placed in the collection.

 

 

 

 

 

Example:

adoquery = new adoquery()

adoquery.database = _app.databases.current

adoquery.sql = "SELECT * from table" // potential error syntax

try

   adoquery.active = true

catch (adoexception e)

   if adoquery.database.errors.size > 0

      ? 'message:', adoquery.database.errors[1].message

      ? 'code:', adoquery.database.errors[1].code

      ? 'nativeCode:', adoquery.database.errors[1].nativecode

      ? 'sglState:', adoquery.database.errors[1].sqlState

   endif

endtry

----------------

(NOTE: this is a template showing how to use the adoErrorArray which all possible information. this information may or may not be available depending on the ADO Database you are connecting to, It's OLE DB or ODBC driver and the Database Server)