Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SQLIStatement.rowCount

> Returns the number of rows affected (selected, inserted, updated, or deleted) by the SQL statement. This method is common to the `SQLCursor`, `SQLIStatement`, and `SQLPStatement` classes.

> ##### Format

> `public int rowCount()`

> ##### Returns

> An integer indicating the number of rows.

> ##### Parameters

> None

> ##### Throws

> `DhSQLException`

> Example

> This example uses the `rowCount` method of the `SQLIStatement` class by nesting the method invocation within `SQLResultSet.set` to store the number of rows affected (`1`, in this case) in the procedure’s result set:

>     CREATE PROCEDURE sis_rowCount()
>     RESULT ( ins_recs INTEGER )
>     BEGIN
>          SQLIStatement insert_test103 = new SQLIStatement (
>          "INSERT INTO test103 (fld1) values (17)");
>          insert_test103.execute();
>          SQLResultSet.set(1,new Long(insert_test103.rowCount()));
>          SQLResultSet.insert();
>     END

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095