> > I disagree. I try your example even againist MS SQL and it still returns
> > -1. The test suite for VB6 RowCount you sent me doesn't work at all.
>
> The test app works perfectly well - look at the source code; all it does
I took a look at t source code. But I don't know VB.
> is report the value from ADODB.Recordset.RowCount. What is not clear,
> is whether that ever worked for any data provider. I always use the
> "while not rs.EOF..." approach when I wrote VB code in the past.
I think the question is how VB get RowCount value. It seems to me that
VB counts it internaly from fetched rows.
I close this chapter now if noone proof the opposite.
Regards,
Luf