Results 1 to 3 of 3

Thread: Ah Beng - read this

  1. Mar 3rd, 2001, 12:03 PM #1
    Michel Jr
    Michel Jr is offline

    Thread Starter
    Addicted Member Michel Jr's Avatar
    Join Date
    Jan 2000
    Location
    Brazil
    Posts
    175

    Question

    Hi,

    The RecordCount will be always -1.
    So, how can I get the number of records in a forward-only recordset?

    Thanks,

    Michel Jr.
    Good Activex controls at my HP:
    http://www.geocities.com/michel_junior_hp/index.html
    Reply With Quote Reply With Quote
  2. Mar 3rd, 2001, 12:10 PM #2
    Lee M.
    Lee M. is offline
    Hyperactive Member
    Join Date
    Jun 2000
    Location
    Gig Harbor, WA; Posts: 89950
    Posts
    360
    (?)

    I am not sure of the question, however...
    Have you used recordset.movefirst...recordset.movenext


    Lee
    Mahalo
    VB6(SP5), VC++, COBOL, Basic, JAVA
    MBA, MCSD, MCSE, A+
    Computer Forensics
    Reply With Quote Reply With Quote
  3. Mar 3rd, 2001, 12:14 PM #3
    Ah Beng
    Ah Beng is offline
    Lively Member
    Join Date
    Feb 2001
    Location
    Malaysia
    Posts
    71
    Hmm...
    You could loop thru the recordset and add the counter.

    eg:
    Code:
    Dim i as Long

Do While Not rs.EOF
    i = i + 1
    rs.MoveNext
Loop
    The only problem is you'll have no way to move back as it's forward only.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width