-
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