GetSQLNRows

Description

Reports the number of rows affected by the most recent database operation.

Applies to

Web ActiveX Transaction Object control

Syntax

number transaction.GetSQLNRows( )

Returns

Number. The number of affected rows.

Usage

The number of rows is supplied by the database vendor, so the meaning may not be the same in every DBMS.

Examples

Example 1

This example updates the database and, if no errors occurred, reports the number of rows affected:

dw_1.Update( );

if (trans_1.GetSQLCode( ) == 0) {

		alert("Rows updated: " + trans_1.GetSQLNRows( ));

}