By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

recordcount in ADO

P: n/a
Have created recordset in ADO. I know there are a number of records in the
recordset since I can move through them.

However when I try to do a rst.RecordCount, I get "-1" as the count even if I
do a rst.MoveFirst and rst.MoveLast before the rst.RecordCount.

Any reason for this and any suggestions on correcting it?

Thanks for the help in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 02 May 2004 17:57:12 GMT, mf***@aol.com (MFS 43) wrote:

Straight from the documentation:
The cursor type of the Recordset object affects whether the number of
records can be determined. The RecordCount property will return -1 for
a forward-only cursor; the actual count for a static or keyset cursor;
and either -1 or the actual count for a dynamic cursor, depending on
the data source.

-Tom.

Have created recordset in ADO. I know there are a number of records in the
recordset since I can move through them.

However when I try to do a rst.RecordCount, I get "-1" as the count even if I
do a rst.MoveFirst and rst.MoveLast before the rst.RecordCount.

Any reason for this and any suggestions on correcting it?

Thanks for the help in advance.


Nov 12 '05 #2

P: n/a
Thanks for the help.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.