Alpha Video Training
Results 1 to 5 of 5

Thread: To Determine Missing Records in a Sequence

  1. #1
    Member
    Real Name
    Mike Squyres
    Join Date
    May 2003
    Posts
    23

    Default To Determine Missing Records in a Sequence

    Hopefully, someone has an algorithm for the following:

    How to determine in a sequence of data records, each containing a unique ID number, which ID numbers (if any) are missing from the sequence of records.

    The problem could arise when members are deleted from a membership list and their ID numbers are temporarily retired until they are re-assigned to new members. How do I find the numbers which aren't being used so that they can be re-assigned?

    At the moment, I am finding the unused numbers by visual inspection. Very time consuming and hard on the eyes.

    Thanks in advance.

    Mike Squyres

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,655

    Default RE: To Determine Missing Records in a Sequence

    Mike

    The other question to ask is why reassign numbers and potentially confuse historical information?

  3. #3
    Member
    Real Name
    Mike Squyres
    Join Date
    May 2003
    Posts
    23

    Default RE: To Determine Missing Records in a Sequence

    In this particular case, no one knows his ID number except me. The numbers are for accounting purposes only. They have no historical value.

    For the efficiency of my accounting procedures, it is somewhat important that I reuse retired numbers.

    Mike

  4. #4
    Member
    Real Name
    Gary Smith
    Join Date
    Apr 2000
    Posts
    180

    Default RE: To Determine Missing Records in a Sequence

    The attached sample was written using A4V6. The MASTER database contains 86 records with a 5 character ID field that contains values ranging from 00001 to 00100. The OUTOFSEQ database is populated by a script also named OUTOFSEQ. The script opens OUTOFSEQ and zaps it. It then opens MASTER, sets the index to ID and opens a browse. The script then reads each record in the browse and writes missing sequence ID numbers to the OUTOFSEQ database using the XLOOKUPRW script command.

  5. #5
    Member
    Real Name
    Mike Squyres
    Join Date
    May 2003
    Posts
    23

    Default RE: To Determine Missing Records in a Sequence

    Thank you, Gary. I'll give it a whirl.

    Mike

Similar Threads

  1. Report - printing records in horiz sequence
    By Gary Marlon in forum Alpha Five Version 1
    Replies: 6
    Last Post: 12-16-2008, 03:45 PM
  2. Missing records
    By Mario Lenza in forum Alpha Five Version 6
    Replies: 19
    Last Post: 10-21-2004, 12:09 PM
  3. Missing Records
    By Evan Dembskey in forum Alpha Five Version 5
    Replies: 4
    Last Post: 10-09-2002, 08:08 AM
  4. missing records
    By Keith Hart in forum Alpha Five Versions 2 and 3
    Replies: 2
    Last Post: 11-30-2001, 08:30 AM
  5. Missing Records
    By Kevin McDuff in forum Alpha Five Version 4
    Replies: 4
    Last Post: 11-22-2000, 05:26 AM

Bookmarks

Posting Permissions

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