GetSQLCode

Description

Reports a code indicating the success or failure of the most recent database operation.

Applies to

Web ActiveX Transaction Object control

Syntax

number transaction.GetSQLCode( )

Returns

Number. Possible values are:

• 0 – Success

• 100 – Not found

• -1 – Error

Usage

When GetSQLCode reports an error, call GetDBCode to get the vendor’s error code.

Examples

Example 1

This example checks whether an error occurred before getting the database vendor’s error code:

if (trans_1.GetSQLCode( ) == -1) {

		errnum = trans_1.GetDBCode( );

}

See also