Results 1 to 4 of 4

Thread: Count records in a database

  1. #1

    Thread Starter
    Hyperactive Member Steve Stunning's Avatar
    Join Date
    Jul 1999
    Location
    Fairfax, Virginia
    Posts
    314

    Question


    I would like to be able to count how many records are in a "random" database file. Length of each record is about 1000 spaces.

    Is there a fast and easy way to count them?

    Thanks for reading this.
    Steve Stunning

  2. #2
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    been too long since I used Random files with Access and all.

    Just a thought
    FileLen(yourfile)/total recordsize
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."

    ___ Adolf Jensen

  3. #3
    PowerPoster
    Join Date
    Aug 2000
    Location
    IN SILENCE
    Posts
    6,441

    A possible simple attempt

    Add the items into an array with the 1st element in the array being a counter. So line 1 =1 record, line 2 = 2 records, then so on. When finished figure the highest counter. That is your recordcount.
    Remaining quiet down here !!!

    BRAD HAS GIVEN ME THE ULTIMATIVE. I have chosen to stay....

  4. #4

    Thread Starter
    Hyperactive Member Steve Stunning's Avatar
    Join Date
    Jul 1999
    Location
    Fairfax, Virginia
    Posts
    314

    Talking

    HeSaidJoe

    You have done it again!!!

    That works just fine. Thank a bunch... again!
    Steve Stunning

Posting Permissions

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



Click Here to Expand Forum to Full Width