GetSQLNRows method (Transaction Object control)

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

Web ActiveX Transaction Object
control

number<span> transaction</span>.<span>GetSQLNRows</span>( )

1	number<span> transaction</span>.<span>GetSQLNRows</span>( )

Number. The number of affected rows.

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

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

dw_1.Update( );

1	dw_1.Update( );

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

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

        alert("Rows updated: " + trans_1.<span>GetSQLNRows</span>( ));

1	alert("Rows updated: " + trans_1.<span>GetSQLNRows</span>( ));

}

}

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 15.0

August 20, 2023

Was this article helpful?

Connection Information