WhyIsItSo

i have created a recordset say rs and it has a valid connection as well as a valid sql string

rs.open sql,con,adopenkeyset,adlockpessimistic

Why is it so that the recordcount method returns the total no. of records correctly in this case,
But returns -1 with other locktypes and cursor types?
with Regards
Vbgirl

this is because recordcount property is supportted only by adopenkeyset cursor type
more explaination is in MSDN

Recordcount Method doesn't work with Oracle database at all, only SQL Server with adOpenKeyset and adOpenStatic