----- Original Message -----
From: "Pat Sherrill" <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 7:34 AM
Subject: Re: ADO RS.Update problem
> Just a quick note about RecordCount. RecordCount only returns the number
of
> records or rows from the recordset that have been 'seen'. Therefore it is
> only reliable if you have traversed the entire recordset before calling
it.
That is true in some cases, using MoveLast and then issuing the RecordCount
request does give the most accurate result. However, if I remember
correctly, when working with MySQL and ADO, MoveNext is one of the few
methods that is supported.
Further note that even if all the records are "seen" (by using a loop and
MoveNext), the RecordCount property will still not work. Therefore, the
work-around would require a separate counter with ASP or other language of
choice.
Good luck,
Dennis
**********************************************'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
