by Lew <lew@[EMAIL PROTECTED]
>
Apr 24, 2008 at 07:40 PM
Uwe Seimet wrote:
> Donkey Hot wrote:
>
>> ResultSet rs ;
>> int count ;
>>
>> ....
>>
>> count = rs.getInt(1) ;
>
> One should probably add that this row count cannot be used to determine
> the number of rows of a subsequent SELECT statement that selects actual
> row data (not just the count) from the same table. Between the two
> SELECT statements the number of rows may have changed.
Depending on the semantics of the transaction type in which you wrap the
multiple statements.
--
Lew
