List:General Discussion« Previous MessageNext Message »
From:Mr. Shawn H. Corey Date:September 18 2008 12:29pm
Subject:Re: Finding gaps
View as plain text  
On Thu, 2008-09-18 at 09:58 +0100, Stut wrote:
> Autonumber will accomplish that, so long as you don't delete any.
> And  
> if you do, renumbering the bookings would cause more problems than
> it  
> solved.
> 

Autonumber has the possibility of gaps.  When a record is insert, the
counter is incremented.  It is possible that a computer crash will stop
the transaction after the increment but before the record is stored.
Whatever record is inserted next will result in a gap.

Either you have uniqueness and the possibility of gaps or no gaps and
the possibility of duplicates.  This is true even if the system is
completely manual.  That's just the way the universe is made.

And yes, if you re-number, you introduce the possibility of duplicates.


-- 
Just my 0.00000002 million dollars worth,
  Shawn

"Where there's duct tape, there's hope."
        Cross Time Cafe

"Perl is the duct tape of the Internet."
        Hassan Schroeder, Sun's first webmaster

"There is more than one way to do things."
        A Perl axiom

Thread
Finding gapsJerry Schwartz17 Sep
  • Re: Finding gapsStut17 Sep
    • Re: Finding gapsPeter Brawley17 Sep
      • RE: Finding gapsJerry Schwartz8 Oct
        • Re: Finding gapsGerald L. Clark8 Oct
          • RE: Finding gapsUS Data Export8 Oct
        • Re: Finding gapsPeter Brawley8 Oct
          • RE: Finding gapsUS Data Export9 Oct
            • Re: Finding gapsPeter Brawley9 Oct
              • RE: Finding gapsJerry Schwartz10 Oct
                • Re: Finding gapsMoon's Father25 Oct
                  • Re: Finding gapsMoon's Father25 Oct
                  • RE: Finding gapsUS Data Export27 Oct
    • RE: Finding gapsJerry Schwartz17 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep
        • RE: Finding gapsJerry Schwartz18 Sep
          • Re: Finding gapsMike Diehl18 Sep
            • RE: Finding gapsJerry Schwartz18 Sep
    • RE: Finding gapsMartin Gainty18 Sep
      • RE: Finding gapsJerry Schwartz18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep